capabilities.work

Reset a Data Table's Data and Schema

A 4-step recipe with Workato. We can help you get access.

Recipe · 4 steps

Reset a Data Table's Data and Schema

with Workato

Truncate a data table and apply a new schema to it.

  1. Read the data table to confirm it exists before resetting it.
  2. Remove all records from the data table while preserving its structure.
  3. Apply the updated name, folder, and column schema to the table.
  4. Read the data table back to confirm the new schema is in place.
What you'll need to have ready
  • dataTableId: The unique identifier of the data table to reset.
  • name: Display name to apply to the data table.
  • folderId: ID of the folder the data table belongs to.
  • schema: The new array of column definitions to apply.
For your developer

Arazzo workflow workato:reset-data-table-schema, 4 operations: getDataTable → truncateDataTable → updateDataTable → getDataTable. Specs on APIs.io.

More recipes with Workato

Batch Publish Events and Drain the TopicBuild and Launch an AI AgentStop the First Running Recipe in a FolderClone and Activate a RecipeCurate an MCP Server's ToolsDecommission an AI AgentEquip a Genie with a Knowledge BaseProvision a Data TableProvision an MCP Server with ToolsPublish and Verify an Event Message