Definition and Usage
This command allows you to retrieve data from a specific cell or an entire row in a data table. It can be used to extract values from existing data tables for further processing in your automation workflow.
Parameter Values
Input parameters
Parameter | Description | Possible Values | Required | Options / Notes |
Data table | Select an existing data table or create a new one |
| Yes | You can click "Add New Sheet" to create a new data table |
Read from | Choose whether to read an entire row or a single cell from the data table | Row, Cell | Yes |
|
Row | Specify the row number. Use 1 for the first row, or -1 for the last row |
| Yes | Accepts positive or negative integers |
Column | Specify the column using either a number (1 = first, -1 = last) or a letter (e.g., A, B, C) |
| Yes (if "Cell" is selected) | Only visible when "Cell" is selected as the read option |
Error handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will trigger an error and stop the execution of the entire app. |
Retry command | If an error occurs, the action will retry the command in an attempt to resolve the issue and continue the process. |
Ignore error & continue | When an error occurs, the action will be ignored, and the workflow will continue without interruption. |
Variables produced
This action produces a variable that stores the retrieved data from the specified cell or row in the data table. The variable will contain a single value when reading a cell or an array of values when reading an entire row.
Using Variables in Conditions
You can use the {x} syntax to insert variables into parameter fields. This allows you to dynamically specify which row or column to read based on previously calculated values. For example, you could use a counter variable to read through rows sequentially in a loop.
Notes
Before using this command, ensure that the data table exists and contains the data you want to read.
When reading from a row, the result will be an array containing all values from that row.
When reading from a cell, the result will be a single value.
If you specify a row or column that doesn't exist, the command will trigger an error based on your error handling settings.
Row and column indices start at 1 for the first row/column, and you can use -1 to refer to the last row/column.