Overview

The Look up node finds a single row in one of your tables using that table's key, and puts it into the conversation for later steps to use.

How It Works

Pick a table. Only tables with a key can be looked up
Provide a value for each of the table's key columns
The conversation continues down Found or Not found

Branches

Not found is not an error. It is how you tell a returning customer apart from a new one.

When You Test a Flow

When you test a flow, Look up finds rows the test saved as well as your real rows. If the test saved a row with the same key as a real one, Look up returns the test's version.

Output Variable

A match publishes the row's values by column name, plus timestamps:

{{variable}}.<column name>
{{variable}}.created_at
{{variable}}.updated_at

Configuration Fields

Table table_key Required

The table to search, 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}}.created_at string

When the row was first saved

{{variable}}.updated_at string

When the row was last saved

Connection Points

Input

Accepts incoming connections from other nodes

✓ Found found

A row matched the key

○ Not found not_found

No row matched, or no key value was available

✗ Error error

The lookup could not run

Look up