Insert Row
The Insert Row(s) component appends new records to an existing DataTable during workflow execution. It populates table columns with user-defined or dynamic workflow values, making it ideal for transaction logging, auditing, and real-time data capture.
a. Data Appending: Inserts single or batch rows directly to the bottom of the target table.
b. Dynamic Mapping: Binds variables from upstream steps directly into specified column fields.
c. Schema Protection: Maintains existing table structures and data types during insertion.
Parameters
| Parameter | Description | Behavior |
|---|---|---|
| DataTable* | Select the target DataTable into which the new row will be inserted. | The component inserts a new row into the selected DataTable without affecting existing rows. |
| Select Columns | Choose the columns to populate for the new row and define the corresponding values to insert. | Only the selected columns are populated with the specified values during the insertion process. |
| Insert Query | Provide the SQL query or data values to insert a new row into the configured DataTable. |
Tool Mode – Executes the query dynamically based on the user's input values.
Manual Mode – Uses the exported JSON table schema to generate a row insertion 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 (e.g., 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 (e.g., contains, case sensitive). |
Note: Based on the columns selected in Select Columns, corresponding dynamic value fields will be displayed. Each field accepts either a global variable or manually entered text.
| 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 schema of the DataTable, including column names, data types, and structural constraints. |
| Data Insert | Confirms the new row inserted into the DataTable, detailing the values populated for each selected column. |
| Dataframe | Returns the updated DataTable in a structured tabular format for downstream workflow steps. |
