Update data table rows
n8n_update_datatable_rowsUpdate rows in a data table that match specified filter conditions (eq, neq, like, ilike, gt, gte, lt, lte) by setting new column values.
Instructions
Update rows matching a filter. Conditions: eq, neq, like, ilike, gt, gte, lt, lte.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"dataTableId": "<dataTableId>",
"filter": "<filter>",
"data": "<data>"
},
"name": "n8n_update_datatable_rows"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dataTableId | Yes | Data table ID | |
| filter | Yes | ||
| data | Yes | Columns and values to set | |
| returnData | No | Return updated rows | |
| dryRun | No | Simulate only |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||