Create a Lookup Table

Go to Content > Lookup Tables and click on Create a lookup table.

• 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

  

Creating an item in a 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

{

 "NL": {

   "countryname": "Netherlands",

   "local_currency": "EUR"

 },

 "US": {

   "countryname": "United States",

   "local_currency": "USD"

 }

}

You can also use the UI editor to define the JSON structure.