If Row Exists
The If Row Exists component checks whether a DataTable contains any rows that match a specific set of conditions. It evaluates the table in read-only mode and returns a boolean (true/false) result, enabling conditional branching in decision-driven workflows.
a. Conditional Branching: Routes workflow execution based on the presence or absence of matching records.
b. Non-Destructive Evaluation: Performs a lookup check without modifying or deleting any underlying data.
Parameters
| Parameter | Description | Behavior |
|---|---|---|
| DataTable* | The DataTable to be evaluated for matching rows. | The component scans this DataTable against the defined conditions without modifying its data. |
| Must Match* | Determines how the defined conditions are evaluated when checking if a row exists. |
All Conditions – The row is considered a match only if it satisfies all specified conditions.
Any Condition – The row is considered a match if it satisfies at least one of the specified conditions. |
| Number of Conditions | Specifies the number of conditions (0–50) used to evaluate whether matching rows exist. | Based on the count entered, that many condition rows will appear, each consisting of a Column Name, Condition, and Value Text field. |
| Column Name (per condition) | Specifies the column in the DataTable to evaluate for that condition. | The row is considered a match based on the value found in this column. |
| Condition (per condition) | Defines the criterion to apply against the specified column value. | The row is considered a match if the column value satisfies this condition (e.g., equals, contains, greater than). |
| Value Text (per condition) | Specifies the value to compare against the column. | The row is considered a match if the column value satisfies the condition using this value (e.g., 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 |
|---|---|
| Result | Returns the evaluation result in JSON format, indicating true if matching rows are found or false if no rows satisfy the defined conditions, for use in subsequent workflow steps. |
