Get Table Rows
Use this action to retrieve the rows of the specified table.
Using the Get Table Rows Action
To use this action in your workflow, connect it to ThingWorx Flow. To connect to the flow, do the following:
1. Drag the Get Table Rows action under the Excel Online connector to the canvas, place the pointer on the action, and then click 
or double-click the action. The Get Table Rows action window opens.
or double-click the action. The Get Table Rows 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, select or specify the name of the folder under which the workbook is created.
5. In the Workbook ID field, select or specify the ID of the workbook to in which the table is created.
6. In the Sheet Name field, select or specify the name of the sheet in which the table is created.
7. In the Table ID/Name field, select or specify the ID or name of the table to retrieve the rows.
8. In the Rows to be Fetched field, enter the number of rows to retrieve from the table.
9. In the Rows to be Skipped field, enter the number of rows to exclude from the result, and then click Done.