Export a Table to a CSV file, including all rows or a filtered subset of rows. The CSV file will be created within the filesystem - from there you can use an upload card from a cloud service connector (Google Drive, Box, etc.) to move it to another cloud service, or an SFTP upload, etc. CSV files can be imported into most spreadsheet programs including Excel.
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.
Click Next to move to the next step.
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.
- 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
- Table ID - this input field only appears if you’ve selected ”provide table at runtime” in the previous step.
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