Search

Table Definition

Last Updated: Mar 15, 2021

Articles

DataTables are used to store transient data that are used during task execution. There are two types of DataTables :

  • Default DataTables
  • Custom DataTables

All DataTables are listed in the Table Definition tab of each Node.

Default DataTables

Default DataTables are the predefined formats of table that are readily available to use. The column names of these DataTables are non-editable. The data type of all the columns is set to String by default and cannot be changed.

Types of Default DataTables

The following are the Default DataTables available:

  1. EmailAttachments: with the following columns:

    • FileName
    • FileExtension
    • FileSize
    • FileServerID
    • FileServerURL
  2. FileExplorer: with the following columns:

    • FileName
    • FileExtension
    • FileSize
    • FileServerID
    • FileServerURL
    • LastUpdatedOn
    • FilePath
  3. EmailResponse: with the following columns:

    • EmailID
    • Message
  4. UUIDTable: with a UUID column.

Apart from these, there are SingleColTable (a table with one column), TwoColsTable (a table with two columns), ThreeColsTable (a table with three columns) up to TwentyColsTable (a table with twenty columns) are available.

Image description

Custom DataTables

You can create DataTables based on the automation requirements.

Create Custom DataTable:

  1. Click the Table Definition tab of the attributes panel of a Node.
  2. Select the Custom DataTables button to select it.
  3. Click the + icon to create a Custom DataTable.
  4. Type the name of the DataTable to be created.

    Click the + icon to add another custom DataTable and the x icon to delete the required table.

  5. Type the name of the columns to be created.

    Click the + icon to add more columns to the table and the x icon to delete the required columns.

    Image description

How DataTables are used in Tasks?

You can store the transient data in Table format to use in further steps of automation.

  1. Select the Variable type as Table.
  2. All available DataTables for the Task are listed in the second drop-down. Select the required DataTable from the list.
  3. Enter name of the variable and click ADD button.

Image description

Did you find what you were looking for?