Converting Flow API responses to CSV

In some cases, you might want to convert the API response you receive from Flow into a CSV for additional data manipulation and exploration.

If you're extracting data through any of the Customer APIs, the ability to receive a response in CSV format is built natively into the API itself. Attach format=csv as a parameter in your API request to automatically receive the response in CSV format. Use additional parameters as usual.

Your request will look something like: https://<workspace.appfireflow.com/v3/customer/core/commits/?format=csv.

For other Flow APIs, such as the Metrics APIs, or if you already have your response in a JSON format, you'll need to use a third-party tool or custom script to convert your JSON response to CSV. The tool you use will depend on your organization.

For most simple conversions, we recommend using Microsoft Excel's built-in functionality to import data from JSON files. To convert your API JSON response to CSV:

1. Download your API response into a JSON file. Most third-party API tools like Postman have several options to do this.

2. In Excel, import the JSON file (external site, opens in new tab).

3. Convert the data to a table, and click the expander symbol in the column names to expand all columns and show all data. No columns should contain variables like {list} or {record} when you're done. If you can’t expand a column that should be expanded, you can delete header rows that are not part of the response, like count, next, and previous.

4. Once the columns are all expanded, close and load the table into your sheet.

From here, you can export this sheet as a CSV or continue manipulating your data in Excel.