# Data table connector

Workato’s Data table connector supports triggers and actions that enable you to use your data tables in your recipes.

Available actions Data table connector actions

# Output formats

Every column (field) in a data table is internally represented by a hash value. This allows Workato to preserve relations and references even when the column name changes. However, if you plan to work with the connector's JSON output directly, referencing the hash value of a column directly is not the most user-friendly experience.

We recommend that you use the Choose the desired output format option to meet your integration requirements. Available output format options are:

Field hash to value (default)
Field name to value - This output format makes the output datapills susceptible to column name changes in the data table.

You can observe the differences in output formats by logging the step output or copying the JSON from the output tab:

# Field hash to value

{
  "a5612739_5401_4ae7_bd07_782c1a6fb2d1": "2023-10-20T07:26:38.453000+00:00",
  "61aae604_a95e_4519_9091_bb0bf754a67f": "2023-10-20T07:26:38.453000+00:00",
  "11fbe9a6_a16d_4d7e_86ea_afe42ec03005": "e04b77b7-31d0-4602-92ee-505270baaf52",
  "565653a5_9411_4290_8b15_3a229ddb4d0a": "John Doe",
  "d944b778_611d_4294_a324_4d9cda9165bf": {
    "record_id": "8e5ab08c-af6f-4d58-a1b4-73b19a1960a0",
    "display_name": "Jane Smith"
  }
}

# Field name to value

{
  "Created at": "2023-10-20T07:26:38.453000+00:00",
  "Updated at": "2023-10-20T07:26:38.453000+00:00",
  "Record ID": "e04b77b7-31d0-4602-92ee-505270baaf52",
  "Name": "John Doe",
  "Relation": {
    "record_id": "8e5ab08c-af6f-4d58-a1b4-73b19a1960a0",
    "display_name": "Jane Smith"
  }
}

# Triggers and actions

Available triggers and actions include:

Last updated: 9/11/2024, 4:23:13 AM