DataStore Insert
Insert data into your built-in DataStore. Use this node to add new rows to any table you have created in Database Studio.
This node supports both single-row and multi-row inserts. When it receives a list of items from an upstream node, each item is inserted as a separate row.
Configuration
| Field | Description | Notes |
|---|---|---|
| Table | The DataStore table to insert into | Select from a list of your existing tables. |
| Column Mapping | Map input data to table columns | Each mapping entry has a Column (the target table column) and an Input (the value to insert, which can reference upstream data using expressions). |
| On Conflict | What to do when a row with the same key already exists | Raise Error (default), Ignore (Skip), or Update Existing. |
| Conflict Columns | Columns that determine uniqueness | Appears when On Conflict is set to Ignore or Update Existing. Select the columns that form the unique key (e.g., primary key or unique index). |
On Conflict Behavior
| Option | Behavior |
|---|---|
| Raise Error | The node fails if a duplicate key is detected. This is the default and safest option. |
| Ignore (Skip) | Rows with duplicate keys are silently skipped. Non-duplicate rows are still inserted. |
| Update Existing | If a row with the same key exists, its values are updated with the new data (upsert). |
WARNING
When using Ignore or Update Existing, you must specify the Conflict Columns so the system knows which columns define uniqueness.
Output
For each inserted row, the node outputs:
| Field | Description |
|---|---|
success | true if the insert succeeded |
table | The name of the table |
inserted_data | An object containing the inserted row data |
insert_id | The auto-generated ID of the inserted row (if applicable) |
When multiple rows are inserted, the output contains one item per row.
Streaming
This node supports piped execution mode. When receiving a large stream of items from an upstream node, rows are inserted in batches for better performance. Each successfully inserted row is passed downstream immediately without waiting for all inserts to complete.
TIP
To import data from an external API into your DataStore, connect an HTTP Request node to a DataStore Insert node and use the Column Mapping to match the API response fields to your table columns.