JSON to CSV
Use the JSON to CSV action to convert JSON data into CSV format.
Complete the following steps to use the JSON to CSV action in your workflow:
1. Click and drag the JSON to CSV action under the Transform utility to the canvas, place the pointer on the action, and then click or double-click the action. The JSON to CSV window opens.
2. Edit the Label, if needed. By default, the label name is the same as the action name.
3. In the Input JSON field, enter the JSON data or map an appropriate output of a previous action to provide the JSON data that you want to convert to CSV.
4. In the Header Type list, select the appropriate header type:
Full—Displays the entire header.
None—Does not display any header.
Relative
Key—Displays the key as the header.
5. In the Wrap Values list, select true to wrap all values in double quotes; otherwise, select false.
6. Click Show additional fields.
7. In the Delimiter field, enter a delimiter character. The default value is ‘,’.
8. In the Denote Object in Header as field, enter the characters that must be used to denote an object in the header. The default is ..
9. In the Denote Array in Header as, enter the characters that must be used to denote array in the header. The default is [].
10. Click Done.
Output schema
Was this helpful?