Skip to content

Table operations

Use table operations to create, delete, list and update data tables. Refer to the Data Table node documentation for more information on the node itself.

Create a data table#

Use this operation to create a new data table.

Enter these parameters:

  • Resource: Select Table.
  • Operation: Select Create.
  • Name: Enter a name for the data table, or define using an expression.
  • Columns: Click Add Column to define parameters for the columns of the data table. You can add multiple columns. For each one:
    • Name: Set a name for the column, or define using an expression.
    • Type: Select the data type for the column: Boolean, Date, Number, or String.:

Create a data table options#

Use these options to further refine the action's behavior:

  • Reuse Existing Tables: Enable to return an existing table if one exists with the same name, without throwing an error.

Delete a data table#

Use this operation to permanently delete an existing data table. This action can't be undone.

Enter these parameters:

  • Resource: Select Table.
  • Operation: Select Delete.
  • Data table: Select how to identify the data table to delete:
    • From list: Select the table from a drop-down list of all your data tables.
    • By Name: Enter the name of your data table.
    • By ID: Enter the ID of your data table

List data tables#

Use this operation to list existing data tables. You can return all tables, all tables up to a defined limit, or filter for tables to return.

Enter these parameters:

  • Resource: Select Table.
  • Operation: Select List.
  • Return All: Enable to return all matching tables. Or, disable and enter a Limit for the number of tables to return, for example 50.

List data tables options#

Use these options to further refine the action's behavior:

  • Filter by Name: Enter a value or expression to return data tables whose names contain the specified text. Matching is case-insensitive.
  • Sort Field: Select a field to sort results on.
  • Sort Direction: Select whether to sort results in Ascending or Descending direction.

Update a data table#

Use this operation to update the name of an existing data tables.

Enter these parameters:

  • Resource: Select Table.
  • Operation: Select Update.
  • Data table: Select how to identify the data table to update:
    • From list: Select the table from a drop-down list of all your data tables.
    • By Name: Enter the name of your data table.
    • By ID: Enter the ID of your data table
  • New name: Enter a value or expression to set a new name for the data table.
This page was