Data tables

1.0

Data tables can be used to store data in an accessible visual table format

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

Each project has a data tables tab where you can store multiple tables.

These tables can be edited directly in the UI:

To make use of them in your workflows, they can also be accessed programatically using this connector in order to lookup, edit and report on data within the tables.

Examples

Copy

Please see our main documentation page on data tables for examples of using data tables as a lookup table and for managing status updates.

These show you how to make use of some key operations:

• Look up row

• Update cell in row

Notes on using Data tables

Copy

Updating column names

Copy

When you first go to access the columns in a table you may find that the actual names aren't present in the output schema:

To fix this you can put a Terminate step after the Data tables connector and trigger a run.

You can then click the 'Use output' button in the debug logs to update the schema:

Once this is remedied you will be able to reference the columns in the subsequent workflow steps:

Data tables and Embedded customers

Copy

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

Exporting and Importing projects with data tables

Copy

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

Storage capacity

Copy

Please note the following parameters when working with Data tables:

• Character limit per cell: 255

• Maximum number of rows: 20,000

• Columns: 8 by default, 16 max

• Data limit: 50 MB

• Data type: String (use text Helpers 'change type' if required)

Uploading CSV files

Copy

You can import CSV file using Import CSV option.

CSV files are subject to the storage limits:

The next modal will display information about the uploaded CSV. Please name your data table to complete the process.

Pasting information

Copy

It is possible to copy / paste cells and rows from another spreadsheet directly into your Data table. Such as copying and pasting information from a Google Spreadsheet.

However please be aware of the following before doing so:

• You cannot copy / paste into the column headers - they must be entered individually

• You can only copy one row at a time

Delete a column

Copy

You can delete any column from a data table.