Use the CSV to JSON action to convert CSV data into JSON format.
Complete the following steps to use the CSV to JSON action in your workflow:
1. Click , drag the CSV to JSON action under the Transform utility to the canvas, place the pointer on the action, and then click or double-click the action. The CSV to JSON window opens.
2. Edit the Label, if needed. By default, the label name is the same as the action name.
3. In the CSV Data field, enter the CSV data or map an appropriate output of a previous action to provide the CSV data that you want to convert to JSON.
4. In the Header Based list, select one of the following options:
true—Returned data contains a key-value based object inside an array.
false—Returned data contains an array of array with values.
5. Click Show additional fields.
6. In the Delimiter field, enter the delimiter value.
7. In the Quote field, enter the quote value to skip delimiter inside quote. You can specify a single quote or double quotes or any character. The default is null.
8. Click Done.
Output schema
Was this helpful?