2021-09-14 / Workflow Apps / ,
Common Password Request
Manage common passwords. Passwords are recorded in Google Sheets and retrieved/updated via the API. The password user requests disclosure at the [1. Password Request] Step. When the administrator approves it, the password is automatically acquired and disclosed at the [3. Password confirmation] Step. After confirmation, the password recorded in the Data Item is deleted.
BPMN Nodes
  • 1 1. Password Request The user inquires for the ID and password of the device to use
  • 3 1x. Respond to rejection The user corrects the contents of the inquiry.
  • 2 2. Approval (Password Renewal) The device administrator answers the inquiry. If no answer is given, the password will be automatically notified after 10 minutes. The administrator can also update your password.
  • 11 3. Password Confirmation The user confirms the disclosed ID and password.
  • 13 4. Password Renewal The administrator updates the ID and password. If not updating or left for 60 minutes, the Process will end
  • 5 x1. Request generation The system generates an HTTP request to fill in the new ID and password on GoogleSheets.
  • 8 x2. URL gen The system generates an HTTP request to get the value of cells in Google Sheet.
  • 10 x3. Response handling The system parses the response from the Google API and sets the resulting value in the Data Items.
  • 12 x4. Data deletion The system blanks over data items that store confidential information.
  • 17 x5. Request generation The system generates an HTTP request to fill in the new ID and password on GoogleSheets.
  • 19 x6. Data deletion The system blanks over data items that store confidential information.
Workflow Diagram (click to open)
Variables (click to open)
  • = Password Request = 0:
  • Target system q_System 1:
  • Reason for Request q_Reason 2:
  • Remarks q_Remarks 3:
  • = Auto-response = 4:
  • Log-in ID q_Login_ID 5: Automatically set at x3, and overwritten to be blank at x4
  • Log-in Password q_Login_Password 6: Automatically set at x3, and overwritten to be blank at x4
  • = Password Renewal, etc. = 7:
  • Renewed Log-in ID q_Renewed_ID 8: Automatically overwritten to be blank at x4 or x6
  • Renewed Password q_Renewed_Password 9: Automatically overwritten to be blank at x4 or x6
  • Spreadsheet Id q_Spreadsheet 10: 1A9G9qXXXXXXTcdBoKcOQXXXXXQukedgFXXXXXTg0TYeU
  • (get URL) q_URL 11: Automatically set at x2, and overwritten to be blank at x4
  • (Request) q_Request 12: Automatically set at x1 or x5, and overwritten to be blank at x4 or x6
  • (Response) q_Response 13: Automatically set at x3, and overwritten to be blank at x4
  • (Communication error) q_Error 14: Automatically set at x3

Download

common-password-request-20160725-209-en.qar

Only available for Professional edition.

Notes

  • You need to associate the Swimlane settings according to your organizational structure upon import
  • Immediately after importing, a setting error will occur
    • Make the necessary settings in edit mode
  • Modify the settings related to Google Sheets set in the Data Item according to your environment
    • The Initial value in Spreadsheet Id: Part in the URL of the target Google Sheet
      • https：//docs.google.com/spreadsheets/d/1A9G9qXXXXXXTcdBoKcOQXXXXXQukedgFXXXXXTg0TYeU/edit#gid=0
    • Choice ID in Target System: Part in the URL of the target Google Sheet
      • https：//docs.google.com/spreadsheets/d/1A9G9qXXXXXXTcdBoKcOQXXXXXQukedgFXXXXXTg0TYeU/edit#gid=1017762745
  • Regarding the values output to Google Sheets, please note the following points 
    • The values in column A are to avoid the “Leap year problem” in MS-Excel
      • When exporting the sheet as MS-Excel, please set the format of column A of Excel to the date time
    • The date and time in column B is output as UTC

Arrangement Tips

  • You can increase the number of target systems by adding sheets in Google Sheets and Select-type Data Item “Target system” options.

See also

%d bloggers like this: