Data Tables CSV Import — Dev & Embed API

Table of Contents

CSV Import for Data Tables is now available via the Dev API and Embed/OEM, extending the UI wizard shipped in May to programmatic, bulk loading.

  • Bulk Import over the Dev API — Create a file upload link, push a CSV to file storage, and trigger a server-side import of thousands of records in a single async job.
  • Append, Refresh, and Fresh-Load Modes — append adds rows to an existing table, truncate_table clears then loads, and assert_table_empty guards clean first-time loads.
  • Configurable Parsing — Specify delimiter, quote character, encoding, and header handling when creating the upload link so the parser reads the file exactly as intended.
  • Validated Column Mapping — Map CSV columns to table fields by index or label, with required-field coverage and type compatibility checked before the import runs.
  • Embed/OEM Parity — Every import endpoint has a managed_users counterpart so Embed partners can run imports on behalf of their end customers.

Learn more about Data Tables.

Get the best of Workato straight to your inbox.

Table of Contents