JSON to CSV
Use this action to convert JSON data into CSV format.
Using the JSON to CSV Action
To use this action in your workflow, connect it to ThingWorx Flow. To connect to the flow, do the following:
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 action windows opens.
2. Edit the label name, if needed. By default, the label name is same as the action name.
3. In the Input JSON field, enter the JSON data.
4. In the Header Type field, add a relative header type, and then select a type:
Full—Displays the entire header.
None—Does not display any header.
Key—Displays the key as the header.
5. In the Wrap Values field, select whether or not you want to wrap all the values in double quotes.
true
false
6. Click + to view the additional fields, and then enter the details that follow:
Delimiter—A delimiter character. The default value is a comma (,).
Denote Object in Header as—The characters to denote an object in the header. The default value is a dot (.).
Denote Array in Header as—The characters to denote an array in the header. The default value is square brackets [].
7. Click Done.
Output Schema
The JSON to CSV action returns an output schema as shown in the figure that follows:
Was this helpful?