Need help with your APIs? I offer API discovery, governance & evangelism services. Explore services →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

Workato Data Tables API

Data tables are structured storage within Workato for persisting and querying records used in recipe automation.

Workato Data Tables API is one of 11 APIs that Workato publishes on the APIs.io network, described by a machine-readable OpenAPI specification and an AsyncAPI event-driven specification.

This API exposes 2 JSON Schema definitions.

Tagged areas include Data Tables. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, authentication docs, an API reference, rate-limit docs, an AsyncAPI specification, and 2 JSON Schemas.

This API exposes 6 operations across 3 paths, and defines 5 schemas. It is described by OpenAPI 3.1.0, at version 1.0.

Requests are made against 5 base URLs: https://www.workato.com, https://app.eu.workato.com, https://app.jp.workato.com, https://app.sg.workato.com, https://app.au.workato.com.

6 operations 3 paths 5 schemas 1 DELETE2 GET2 POST1 PUT

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.1.0
API Version
1.0
Servers
https://www.workato.com
https://app.eu.workato.com
https://app.jp.workato.com
https://app.sg.workato.com
https://app.au.workato.com
Authentication
HTTP Bearer
Terms of Service
Resource Areas
1

Authentication & Security 1

Workato Data Tables API declares 1 security scheme for authenticating requests. It accepts HTTP bearer tokens (bearerAuth). By default, every request must be authenticated.

  • bearerAuth — API client token obtained from the Workato platform. Include as Authorization: Bearer {token}.

Paths & Operations 6

Across 3 paths, the API surfaces 6 operations — 1 DELETE, 2 GET, 2 POST, 1 PUT. Each is listed below with its method, path, parameters, and response codes.

Data Tables 6

Data tables are structured storage within Workato for persisting and querying records used in recipe automation.

GET
/api/data_tables
Workato List Data Tables
listDataTables 2 params → 200401
POST
/api/data_tables
Workato Create a Data Table
createDataTable body → 200400401
GET
/api/data_tables/{data_table_id}
Workato Get a Data Table
getDataTable 1 param → 200401404
PUT
/api/data_tables/{data_table_id}
Workato Update a Data Table
updateDataTable 1 param body → 200400401404
DELETE
/api/data_tables/{data_table_id}
Workato Delete a Data Table
deleteDataTable 1 param → 200401404
POST
/api/data_tables/{data_table_id}/truncate
Workato Truncate a Data Table
truncateDataTable 1 param → 200401404

Schemas 5

The contract defines 5 schemas that model the data the API accepts and returns. The most detailed are DataTable (6 properties), DataTableColumn (4 properties), DataTableInput (3 properties), ErrorResponse (2 properties). Each schema is shown below with its type and property counts.

DataTableColumn
object
A column definition in a data table schema.
4 properties 2 required
SuccessResponse
object
Standard success response.
1 property
DataTableInput
object
Input schema for creating or updating a data table.
3 properties 3 required
DataTable
object
A structured data storage table within the Workato workspace.
6 properties
ErrorResponse
object
Standard error response.
2 properties

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

workato-data-tables-api-openapi.yml Raw ↑

Other APIs Workato publishes across the network.

Workato Embedded Partner API
Workato Genies API
Workato Knowledge Bases API
Workato MCP Servers API
Workato Messages API
Workato Policies API
Workato Recipes API
Workato Skills API
Workato Tools API
Workato User Groups API