Lookup Tables. How to use lookup tables

The Lookup Tables are a way for you to store data that you can then use in Templates, Flows and Journeys. Create your Lookup Tables through the dashboard, and then dynamically reference data in these tables.

Lookup Tables in Bird store and centralize data references, which can be looked up when creating email templates using Liquid templating language in HTML.

For example, every country's flags, abbreviations, or currency can be stored and updated centrally as a lookup table. Every time it is used in building an email, it can be referenced from this lookup table.

Important limitations:

• Each table can have up to 10 separate data items stored in it.
• Each item may contain up to roughly 300kB of data.

Go to Content > Lookup Tables and click on Create.

• Enter a display name
• Enter a slug with no spaces

The Slug is used to reference this table and may only contain alphanumeric characters. Note that this slug is used in referencing the email template.

• Click on Save

Create a Lookup Table.

Click on the table you've created

From the context menu that pops up, select "View"

Each item in a table is essentially a JSON document. This means you can build up a tree-structure of keys and values, where the values can be text, numbers, booleans, arrays or objects themselves. You can either enter a JSON document directly, using JSON syntax or you can use a UI editor to construct the JSON document.

JSON Editor

• Once you have saved, you will see a JSON editor. You can select either the Text or UI editor based on your preference.
• Update the lookup table using a JSON structure.

Adding an item To add an item in a JSON for organization, click on +Add Item on the left pane.

• Type a name on the top
• Click on Add Item button
• Once created, you can see the item created on the left pane.

Write the JSON Use the JSON format to define any object structure and key-value pairs below:

For example, a JSON which gives countryname and local currency based on country abbreviation

To use a lookup table in an email template, you can add the following liquid syntax to your HTML template or to an HTML element used in a drag-and-drop builder:

{% assign variable_name = "lookup-table-slug" | lookup: "item-name", "object-value" %}

{{variable_name.key_name}}

You can read lookup tables in Flows to reuse centrally defined data.

To use a lookup table, first create one as described in above.

• Navigate to the Workflows > Flows
• Create an initial flow using a trigger type of your choosing.

Add a new Perform Lookup step to your flow. Click on Add New Action and either select it from the Lookup Tables group or search for it using the Search capability on the right:

You'll be shown a configuration screen where you can select the table to read from and configure how exactly you want to perform this lookup:

You'll see three components you can configure:

• Lookup Table Slug indicates what table you want to look at. By clicking in this field, Flows will show you the available lookup tables:

• Lookup lets you determine what to retrieve and you can use the various variables available to you to construct this lookup key. Default operation is to return the value your look up points to as the root level value, but if you want to create an object of data - you can use the As capability to load it into a specific property: