Insert Data
Inserts a data in TimescaleDB.
This node is also exposed as an AI Agent tool.
This node has 1 input port and 1 output port.
Common Properties
Every node shares these.
- Name — the node's display name on the canvas.
- Color — the node's colour on the canvas.
- Delay Before (sec) — wait this long before the node runs.
- Delay After (sec) — wait this long after the node runs.
- Continue On Error — carry on instead of failing the flow. Defaults to false.
info
When Continue On Error is true the error is not raised at all, so a Catch node will not see it either.
Inputs
| Property | Field | Description |
|---|---|---|
| Client ID | inClientID | Client ID from Connect node |
| Columns | inColumns | Comma-separated column names (e.g. time،device_id،temperature) |
| Table Name | inTable | Name of the hypertable to insert into |
| Values | inValues | Array of value arrays for batch insert. Each inner array is one row (e.g. [[now()،dev1،23.5]،[now()،dev2،24.1]]) |
Outputs
| Property | Field | Description |
|---|---|---|
| Rows Inserted | outRowCount | Number of rows successfully inserted |
| Success | outSuccess | Whether the insert operation was successful |
Options
| Property | Field | Description |
|---|---|---|
| Credentials | optCredentials | TimescaleDB credentials (optional if using Connect node) |
| Timeout (seconds) | optTimeout | Maximum time in seconds to wait |
Requirements
- A Client ID from this package's Connect node, unless you set credentials directly on this node.
Related nodes
Elsewhere in the package: Connect · Disconnect · Execute Query · Create Hypertable · Drop Chunks · Enable Compression · Create Continuous Aggregate · Refresh Continuous Aggregate · Toolkit
See also
- TimescaleDB — every node in this package
- Message object — how properties read values from
msg - Handling failure — Continue On Error, Catch and retries