Add Rows to Table
Use this action to add rows to the specified table.
Using the Add Rows to Table Action
To use this action in your workflow, connect it to ThingWorx Flow. To connect to the flow, do the following:
1. Drag the Add Rows to Table action under the Excel Online connector to the canvas, place the pointer on the action, and then click 
or double-click the action. The Add Rows to Table action window opens.
or double-click the action. The Add Rows to Table action window opens.2. Edit the label name, if needed. By default, the label name is same as the action name.
3. To add an authorization, refer to the section Authorize Excel Online in the Excel Online connector topic.
 | If you previously added an authorization for Excel Online, select an authorization from the list. |
4. In the Folder Name field, enter the name of the folder under which the workbook is created.
5. In the Workbook ID field, enter the ID of the workbook in which the table is created.
6. In the Sheet ID field, enter the ID of the sheet in which the table is created.
7. In the Table ID/Name field, enter the ID or name of the table to add rows.
8. In the Select Entry Type field, select the entry type:
◦ Single Row Entry—Specify the column values for a single row.
In the Row Values field, enter the value for the specified Column. Click Add enter multiple columns.
◦ Multiple Row Entries—Specify the row data separated by a comma or a JSON array.
▪ Input Data Type—Select the data type per the input selected.
▪ Row Data—Enter the row data. Enter the row data. If you selected Comma Separated Values as an input data type, provide data in 'Abc,123' format and if you do not want to update cell of row then you need to define 'null,123'. If you selected JSON Array as an input data type, provide data in '[\"Abc\",\"123\"]' format and if you do not want to update cell of row then you need to define '[null,\"123\"]'. Multiple rows can be added by entering multiple CSV lines or by entering an array of JSON array.
9. In the Row Values field, enter the value for the specified Column. Click Add enter multiple row values.
10. Click + to view the additional fields, and then enter the Row Index in which you want to add the row data.
11. Click Done.