Common Password Request

Release date 2021-01-05

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)

BPMN Icons
- Start Event
- End Event
- Join Gateway

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

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