This article describes how to write output from the List Users card to a CSV file in Workflows.
- Okta Workflows
Run a search with Okta – List Users with Filter card (or using any other search/filter card), and would like to save the result into a CSV file. This article explains how to do that.
The workflow has the following steps:
- Find users.
- Save to the table.
- Export the table to a CSV file.
This is the main flow:
- Okta – List Users with Filter card finds the users to save to a CSV file.
- List – For Each card goes over each user and saves the user to a table using a helper flow (see below). The entire User record is passed to the helper flow.
- Tables – Export to CSV card saves data from a table into a CSV file. Specify the CSV file name and optionally specify which columns to export. In this example, the columns Name and Email are exported.
The table has two (custom) columns: Name and Email:
This is the helper flow that saves each user found into a table:
The flow has these steps:
- Helper Flow card receives the User record.
- Get Multiple card retrieves First Name, Last Name, and Email fields from a user.
- Concatenate card creates a Full name from the First Name and Last Name fields.
- The last, Table – Create Row card, saves each user's information into a table.
Learn: How to Setup a Workflows Helper Flow (With For-Each and Streaming Cards)
When the main flow is run, the table is populated with user data:
Looking at the main flow history, the Tables – Export to CSV card returns a file that can be downloaded:
Opening User_data.csv file in Numbers:
