Data table connector

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

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 column names change. However, if you plan to work with the connector's JSON output directly, referencing the hash value of a column is not as intuitive as referencing its name.

The Choose the desired output format field lets you select the output format that best supports your use case. Available output formats include:

• Field hash to value (default): This output format allows Workato to preserve relations and references even when the column's name changes but provides a less intuitive JSON output.
• Field name to value: This output format makes the output datapills susceptible to column name changes but results in a more human-readable output, which is ideal for working with JSON objects directly using formulas.

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:

• New records trigger (batch)
• New record trigger (real-time)
• New/updated records trigger (batch)
• New/updated record trigger (real-time)
• Create record action
• Create records action (batch)
• Delete record action
• Delete records action (batch)
• Remove values from a record
• Search records action (batch)
• Truncate table action (batch)
• Update record action
• Update records action (batch)
• Upsert record action