This knowledge base article demonstrates how to save users' Multi-Factor Authentication (MFA) information in a Google Sheets spreadsheet.

• Okta Workflows
• Okta Classic Engine
• Okta Identity Engine (OIE)

This example demonstrates how to take a list of users and save their Multi-Factor Authentication (MFA) information into a spreadsheet.

The solution has three flows:

1. List Users Flow.
2. List User MFA Flow (helper flow).
3. Save MFA Information to a Spreadsheet Flow (helper flow).

List Users Flow

The List Users flow lists all active users using the List Users with Search card. It uses the streaming option.

 

List User MFA Flow (helper flow)

This is the List User MFA helper flow:

The flow has the following steps:

1. The Helper Flow has a Record input. This is the user information. The Record object extracts the ID and Login from the user information. This is instead of using the Get Multiple card in the flow.
2. The Compose card creates an endpoint string to get MFA factors in the next card.
3. The Custom API Action card makes an API call to Okta to get MFA factors for a user. It returns MFA factors list.
4. The For Each card uses the list from the previous card to call a helper flow to save the user’s MFA information. The card passes the following information to the helper:
   • User ID.
   • User Login.
   • MFA Type – lists one MFA factor for a user.

Save MFA Information to a Spreadsheet Flow (helper flow)

This is the Save MFA to Spreadsheet flow:

The flow has the following steps:

1. The flow has three inputs:
   • User ID
   • User Login
   • MFA Type
2. The Object – Get card retrieves the MFA factor name.
3. The Google Sheets – Create Row card creates a new row with the following information:
   • User ID
   • User Login
   • MFA Type

The Google Sheets spreadsheet with user MFA information:
 

Related References

• How to Call an API when It Is Not Available from an Existing Card (Connection)