Get Row(s)
The Get Row(s) component retrieves specific rows from an existing datatable based on user-defined condition rules. It queries data without altering the original table, making it ideal for downstream workflow logic and data validation.
a. Filtering & Search: Fetch single or multiple records matching custom key-value conditions.
b. Sorting & Limits: Control result order and cap maximum returned rows for optimized performance.
Parameters
| Parameter | Description | Behaviour |
|---|---|---|
| DataTable* | Specifies the source DataTable from which rows will be retrieved. | The component scans the selected DataTable and retrieves rows that match the defined conditions. |
| Must Match* | Determines how the defined conditions are evaluated when selecting rows. |
All Conditions – Retrieves rows only if all specified conditions are satisfied.
Any Condition – Retrieves rows if at least one specified condition is satisfied. |
| Number of Conditions | Specifies the number of conditions (0–50) used to evaluate and filter rows. | Based on the count entered, that many condition rows will appear, each consisting of a Column Name, Condition, and Value Text field. |
| Sort By* | Specifies the column and sort order (ascending or descending) used to organize the retrieved rows. | Matching rows are sorted according to the selected column and order before retrieval. |
| Number of Limits | Specifies the maximum number of rows to retrieve. | The component retrieves only up to the specified number of matching rows. If not set, all matching rows are retrieved. |
| SELECT Query | Provide the SQL query or criteria to retrieve rows from the configured DataTable. |
In Tool Mode, the query executes dynamically based on the user’s input conditions.
In Manual Mode, the exported table schema in JSON format can be used to create a row retrieval template. |
| Column Name (per condition) | Specifies the column in the DataTable to evaluate. | A row is considered a match based on the value present in the selected column. |
| Condition (per condition) | Defines the criterion to apply against the specified column value. | A row is considered a match if the column value satisfies the selected condition (for example: equals, contains, greater than). |
| Value Text (per condition) | Specifies the value to compare against the column. | A row is considered a match if the column value satisfies the condition using the provided value (for example: contains, case sensitive). |
| Parameter | Description |
|---|---|
| Timeout (seconds) | Maximum wait time for the download request to complete before the operation times out. Default: 30 seconds. |
| Retry count | The number of automated download attempts if the initial request fails. |
| Delay between retries (s) | Wait time between consecutive retry attempts. Default: 1 second. |
| Delay before execution (s) | Time to wait before the component starts processing. Default: 0 seconds. |
| Delay after execution (s) | Time to wait after the component finishes processing. Default: 0 seconds. |
| Continue on Error |
Determines the behavior when an unrecoverable error occurs:
Stop Workflow – Halts workflow execution. Continue – Skips this step and continues without passing the error downstream. Continue Using Error Output – Continues execution and routes error details through the error output handle. |
Output
| Output | Description |
|---|---|
| Table Schema | Returns the structure of the DataTable, including all column names and their data types in JSON format. |
| Data Fetch | Retrieves the actual rows from the DataTable that match the defined filter conditions in JSON format. |
| Dataframe | Returns the retrieved rows in a structured tabular format for further processing within the workflow. |
