Overview

The Delete node removes a single row from one of your tables, found by that table's key. It is how a conversation honours "forget me", cancels a booking, or releases a held slot.

How It Works

Pick a table. Only tables with a key can be deleted from
Provide a value for each of the table's key columns
The conversation continues down Deleted or Nothing to delete

What It Can Remove

A key identifies at most one row, so this node removes one row or none. There is no way to express "delete everything matching" and no way for a missing key value to widen it: if any key value comes out blank, the node takes Nothing to delete rather than guessing.

Deleting frees the space the row used, so it counts against your row allowance again straight away.

Branches

Nothing to delete is not an error. A customer asking to be forgotten twice should be told yes both times.

Output Variable

{{variable}}.deleted

Configuration Fields

Table table_key Required

The table to delete from, and a value for each of its key columns.

Output Variables

This node stores its output in a variable that can be referenced in subsequent nodes using the {{variable}} syntax.

{{variable}}.deleted boolean

Whether a row was removed

Connection Points

Input

Accepts incoming connections from other nodes

✓ Deleted deleted

A row matched the key and was removed

○ Nothing to delete not_found

No row matched, or no key value was available

✗ Error error

The delete could not run

Delete