Delete

Integrations • table_delete •

Remove a row from one of your tables

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

  1. Pick a table. Only tables with a key can be deleted from
  2. Provide a value for each of the table's key columns
  3. 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.

When You Test a Flow

Deleting while you test a flow never removes a real row. A row the test saved is removed. If the key only matches a real row, the flow still continues down Deleted, as it would for real, and the real row stays where it is.

Output Variable

{{variable}}.deleted

Configuration Fields

Table table_key Required

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

Show details

Pick one of your workspace's tables, then give a value for each of its key columns. The values can use variables from earlier in the flow, so the row matched depends on the conversation.

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

More in Integrations

Request a demo
This form is running on UniversalChatbot.