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

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

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

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

Table table_key Required

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

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

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