SharpenDB DELETEDataSharpensharpenDbDelete· Version 1.0.0
Run a DELETE query on a table in SharpenDB.
Removes rows from a SharpenDB table that match the Where conditions you specify; condition values can reference $(name) variables. A delete is refused, and takes invalidInput with the reason, when it has no condition, when a condition's value is blank (IS NULL, IS NOT NULL, IS TRUE, and IS NOT TRUE need none), or when a condition matches every row: a LIKE pattern of only %, or a NOT IN list holding an empty value. Any data returned can be captured into variables by JSONPath. The flow takes default when the delete succeeds. A query SharpenDB does not answer within 20 seconds takes timeout, or fallback when timeout is not wired. The node's Timeout field is not applied: it does not change that 20-second limit.
Integration required
Fields
| Field | Type | Required | Description |
|---|---|---|---|
Tabletable | dynamicDropdown | Required | The table to delete from. |
Wherewhere | dynamic array of fields with options | Required | WHERE conditions to filter which rows to delete. Each condition compares a table field using an operator against a value. |
Where OperatorwhereConditionOperator | string | Optional | What operator (AND/OR) to use for the where condition. |
Variablesvariables | array of objects | Optional | Save variables from the data returned. |
Timeouttimeout | number | Optional | Not applied yet: SharpenDB queries always wait up to 20 seconds, whatever this is set to. |
Exits
System exits (auto-injected, hidden when unwired): invalidInput, fallback.