Data tables

Data tables can be used to store data in a table format in order to enable such functionality as lookup tables.

How to use data tables

Copy

• Go to the data tables tab in your project.

• Add a data table (from scratch or import CSV)

• Add / edit your data.

• Create workflows which make use of the Data tables connector and its operations.

Please also note the following:

• The current version of data tables cannot be accessed from within an end-user solution instance.

• When exporting projects with data tables please remap the data table in the target workspace after importing

Storage capacity

Copy

Please see the Data tables connector page for information on the storage capacity of the Data tables connector

Example: Basic Lookup table

Copy

Below is an example of creating a simple lookup table.

In this example we have received a contact's details including the country they live in.

The lookup table contains a list of countries and their regions so we can use it to add a region for the contact.

1. As you can see from our source data we have a contact with a 'country' but no 'region':

2. So we use the Data tables 'Lookup row' operation to find which region matches their country:

3. The final step then combines the fields from the original data source with the 'region' result from the Data tables step:

Example: status updates

Copy

In the following scenario we are using a data table to keep track of and update the status of orders:

1. Receive webhook payload and lookup row:

2. Update status for matching row: