SpreadSheet to JSON
Use this action to convert the spreadsheet (xlsx file) to a JSON file.
Using SpreadSheet 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 SpreadSheet to JSON action under the SpreadSheet utility to the canvas, place the pointer on the action, and then click or double-click the action. The SpreadSheet 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 Workbook Object field, enter the workbook object returned by spreadsheet read.
4. Click Done.
Output Schema
The SpreadSheet to JSON action returns an output schema as shown in the figure that follows: