Datatable Operations
The Datatable Operations component enables workflows to retrieve, filter, sort, aggregate, and transform data from an existing datatable without altering the original source. It exposes table metadata including schema, columns, and constraints, to validate and safely execute queries.
a. Manual Mode: Directly executes user-provided CRUD (Create, Read, Update, Delete) queries without generating system queries.
b. Tool Mode: Automatically generates and executes built-in queries requested by an agent, returning structured results directly to the workflow.
Parameters
| Parameter | Description |
|---|---|
| Datatable* | Specifies the source DataTable to operate on. Contains the data the workflow will use. |
| PostgreSQL Query |
Provide the SQL query you want the agent to execute on the configured PostgreSQL database. The query can include operations such as SELECT, INSERT, UPDATE, or DELETE.
The workflow executes the exact query you provide and returns the results. In Tool Mode, the query is executed dynamically based on the user’s request to the agent. |
| Action | Displays the slug name of the table or operation. Available only in Tool Mode. |
| 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 |
|---|---|
| Get Table Meta Information | Returns metadata of the table in JSON format, including column names, data types, and schema details. |
| Execute Query | Returns results of the executed query in JSON format, along with a success status (true/false). |
