CSV to JSON
Use this action to convert the CSV data into JSON format.
Using the CSV to JSON Action
To use this action in your workflow, connect it to ThingWorx Flow. To connect to the flow, do the following:
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 action window opens.
2. Edit the label name, if needed. By default, the label name is same as the action name.
3. In the CSV Data field, enter the CSV data that you want to convert to JSON.
4. In the Header Based field, select one of the following options:
true—Returned data contains key-value based object inside an array.
false—Returns an array of array with values.
5. Click + to view the additional fields:
Delimiter—Enter delimiter value.
Quote—Enter the quote value to skip delimiter inside quote. The possible value can be a single quote or double quotes or any character. The default value is null.
6. Click Done.
Output Schema
The CSV to JSON action returns an output schema as shown in the figure that follows: