The Data Table integration reads and writes your Data Tables from inside a workflow. It is built in, so you need no connection.
In the node picker, Integrations → Data Tables holds four of these nodes: Get Rows, Insert Row, Update Rows and Delete Rows. Find First Row, Upsert Row and Count Rows come with the Data Table entry in the list of integrations.
How to create tables and define columns is described on the Data Tables page.
Filters and Row IDs
Every row has an automatic numeric ID in the column _id. Most actions accept either a Row ID for one specific row or a Filter with conditions on your columns. Update and Delete need one of the two.
Actions
Data Table: Get Rows
Returns rows, optionally narrowed by a row ID or a filter.
| Input | Required | Description |
|---|---|---|
| Data Table | Yes | The table to read from |
| Row ID | No | Return only this row |
| Filter | No | Conditions the rows must meet |
| Limit | No | Maximum number of rows to return |
| Offset | No | Number of rows to skip, for paging |
| Output | Type | Description |
|---|---|---|
rows | array | The rows found |
count | number | Number of rows found |
Data Table: Find First Row
Returns the first row that matches a filter.
| Input | Required | Description |
|---|---|---|
| Data Table | Yes | The table to search |
| Filter | No | Conditions |
| Output | Type | Description |
|---|---|---|
row | object | The first matching row, or null |
found | boolean | Whether a row was found |
rowId | number | ID of the row found |
Data Table: Insert Row
Adds one row, or several rows at once if you pass an array.
| Input | Required | Description |
|---|---|---|
| Data Table | Yes | The target table |
| Row Data | Yes | An object of column keys and values, or an array of such objects |
| Output | Type | Description |
|---|---|---|
rows | array | All inserted rows |
insertedIds | array | IDs of all inserted rows |
row | object | The first inserted row |
insertedId | number | ID of the first inserted row |
Data Table: Upsert Row
Updates the rows that match the Match Filters. If none match, it inserts a new row. Use it when a workflow may process the same item twice.
| Input | Required | Description |
|---|---|---|
| Data Table | Yes | The target table |
| Match Filters | Yes | Conditions that identify an existing row |
| Row Data | Yes | Values to write, both for update and insert |
| Output | Type | Description |
|---|---|---|
row | object | The resulting row |
wasInserted | boolean | true if a new row was created |
insertedId | number | ID of the new row, if one was inserted |
updatedCount | number | Number of rows updated |
Data Table: Update Rows
Changes the row with the given ID, or all rows that match the filter.
| Input | Required | Description |
|---|---|---|
| Data Table | Yes | The target table |
| Row ID | One of | The row to update |
| Filter | One of | Conditions for the rows to update |
| Updates | Yes | Column values to set |
| Output | Type | Description |
|---|---|---|
updatedCount | number | Number of rows changed |
updatedRows | array | The rows after the update |
Data Table: Delete Rows
Removes the row with the given ID, or all rows that match the filter.
| Input | Required | Description |
|---|---|---|
| Data Table | Yes | The target table |
| Row ID | One of | The row to delete |
| Filter | One of | Conditions for the rows to delete |
| Output | Type | Description |
|---|---|---|
deletedCount | number | Number of rows removed |
Deleting rows cannot be undone. For Update Rows and Delete Rows, consider switching on Approval required in the node so that a person confirms the change first. See Approvals.
Data Table: Count Rows
Counts the rows that match a filter without returning them.
| Input | Required | Description |
|---|---|---|
| Data Table | Yes | The table to count |
| Filter | No | Conditions |
| Output | Type | Description |
|---|---|---|
count | number | Number of matching rows |