Settings
| Setting | What it is |
|---|---|
| TableRequired | Rows are separate per environment. Editor runs — Test node and Execute — read and write the test copy. |
where.column | text |
where.operator | text |
where.value | any JSON |
| Change these columns | Only the columns you list change; values accept {{ }} expressions, and Clear writes a null, which empties the cell. |
| If no row matches | "fail" or "skip" |
| Row id | Instead of Which row: the id of the row to change, as a select returns it. |
| Expected version | Refuses when someone changed the row in between (optimistic concurrency). |
Technical details
| Key | Value |
|---|---|
tableId | texta table id from `requires.tables` |
where.column | text |
where.operator | text, by default "equals" |
where.value | any JSON |
values | object (any keys), by default {} |
ifNone | "fail" or "skip", by default "fail" |
rowId | text |
expectedVersion | number |
Output
| Field | Type |
|---|---|
rowId | string |
rowVersion | number |
changedA row was changed | boolean |
Sample output, and the expression for each field
- rowId"row_a"
- rowVersion2
Errors
When a step of this node stops a run, the run page shows a code. Look it up:
Example step
The step as a flow file holds it. Replace each value in <…>.
{
"config": {
"ifNone": "fail",
"rowId": "",
"tableId": "<table>",
"values": {},
"where": {
"column": "",
"operator": "equals"
}
},
"label": "Update",
"type": "table.update",
"version": 2
}Older versions
A flow that already has this version keeps running it. A new step always gets the newest.
Version 1
| Setting | What it is |
|---|---|
| TableRequired | Rows are separate per environment. Editor runs — Test node and Execute — read and write the test copy. |
| Row idRequired | Pick the row with Table — Select first, then loop over its rows. Its id is under rows[].rowId. |
| Values | Only the columns you set change; values accept {{ }} expressions, and Clear writes a null, which empties the cell. |
| Expected version | Refuses when someone changed the row in between (optimistic concurrency). |
Technical details
| Key | Value |
|---|---|
tableId | texta table id from `requires.tables` |
rowId | text |
values | object (any keys), by default {} |
expectedVersion | number |