Actions14
Convert JSON to CSV
AI-generatedOverview
This node operation converts JSON data into CSV format. It is useful when you have JSON objects or arrays and want to transform them into a CSV file for easier data manipulation, reporting, or integration with systems that require CSV input. For example, converting nested JSON arrays or objects into a flat CSV table for spreadsheet analysis.
Use Case Examples
- Converting a nested JSON array field named 'sentences' into CSV format.
- Converting all incoming JSON items into a CSV file when no specific nested array field is specified.
Properties
| Name | Meaning |
|---|---|
| JSON Array Field | If your data is inside a nested array, enter its key here (e.g. 'sentences'). Leave blank to convert all incoming items. |
Output
Binary
Outputs a CSV file in binary format encoded in base64, with the filename 'data.csv' and MIME type 'text/csv'.
JSON
columnIndices- An object mapping CSV column names to their respective indices in the output CSV.
Troubleshooting
- Ensure the JSON data is properly formatted and accessible at the specified nested array field if provided.
- If the JSON array field path is incorrect or does not exist, the node will convert all incoming items instead.
- Check for special characters in JSON values that may require escaping in CSV format, such as commas, quotes, or newlines.