FlowmageDocs

Delete

Changes data

Deletes one row from a table — there is no undo.

Settings

SettingWhat it is
TableRequiredRows are separate per environment. Editor runs — Test node and Execute — read and write the test copy.
Row idRequiredPick the row with Table — Select first, then loop over its rows. Its id is under rows[].rowId. A retry of this step never deletes twice — it gets the first delete's answer back. A row that is already deleted fails the step with TABLE_ROW_NOT_FOUND.
Expected versionRefuses when someone changed the row in between (optimistic concurrency).
Technical details
KeyValue
tableIdtexta table id from `requires.tables`
rowIdtext
expectedVersionnumber

Output

FieldType
rowIdstring
rowVersionnumber
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": {
    "rowId": "<row id>",
    "tableId": "<table>"
  },
  "label": "Delete",
  "type": "table.delete",
  "version": 1
}