Export To CSV

Export a table to a CSV file, including all rows or a filtered subset of rows.  The CSV file will be created within the file system.

Options

The first step for using this function is to provide the Table you want to export. Click the Choose Table button and select the table you want to use.

If your Flow will operate on different tables each time, you can choose the advanced option to provide table at runtime  which will result in an additional Table input field on the next step. See Provide a table ID at runtime.

Click Next.

Inputs

  • File

    • Filename (string) - assign a name for the CSV output file (include ".csv" as the filename extension if you want it to open up automatically in an app like Excel)
  • Filter

    • Where Expression (expression builder) - To export a subset of rows, click the button to build your criteria.  To export all rows in the table, ignore this input.
  • Options

    • Delimiter (string) - Enter a custom delimiter for your CSV file. For example, if you are would like to create a pipe delimited CSV, then you would want to enter | as your delimiter. Defaults to ,.

    • Limit (number) - The max number of rows exported to your CSV file. E.g. - a value of 100 will return a CSV with a maximum of 100 rows.

    • Offset (number) - Create a CSV starting at a specific row number in the table. For example, if you only wanted to export a CSV with all but the first 10 rows, then enter 10 as the offset value.

    • Columns (list of text) - A list of column names that will export into your csv. This allows specific columns from the table to be exported to the CSV. Use this field if you only want a specific subset of columns exported to the CSV.

  • Table ID - this input field only appears if you've selected provide table at runtime in the previous step. See Provide a table ID at runtime.

Outputs:

If you're returning a single result, you get the following outputs:

  • CSV

    • File Content (file) - The File ID of the CSV output file

See Also

About tables

Provide a table ID at runtime

Functions

About the elements of Okta Workflows