Rollback CSV import by task

This page documents the canonical HTTP contract for this endpoint.

With dry_run=true, the response returns rows_candidate_count and does not mutate rows. A real rollback deletes manifest-tracked rows created by the import and returns requested/deleted/failed counts plus up to 25 sample IDs. Rows updated by upsert are not restored. Repeating a completed rollback returns already_rolled_back; a busy table mutation returns 409.

Path parameters

table_idrequired
string
Target table ID.
task_idrequired
string
CSV import task ID.

Name	Type	Description
table_idrequired	string	Target table ID.
task_idrequired	string	CSV import task ID.

Query parameters

dry_run · optional
boolean
Default false. When true, returns rows_candidate_count without deleting rows.

Name	Type	Description
dry_run	boolean	Default false. When true, returns rows_candidate_count without deleting rows.

Errors

Status	Meaning
401	Invalid API key or missing auth.
403	Missing tables:write scope or table access denied.
404	Import manifest not found for this table/task pair.
409	Research Table rows are busy with another mutation.

Example

bash

curl -X POST "https://app.autotouch.ai/api/tables/67bd8c39c7d3e80f0a95b560/import-rollback/7f1e0d4f-6b6e-44ff-9fd2-03f2f7ebad85" \
    -H "Authorization: Bearer stk_your_key_id.your_secret"

Response example

json

{
    "task_id": "7f1e0d4f-6b6e-44ff-9fd2-03f2f7ebad85",
    "table_id": "67bd8c39c7d3e80f0a95b560",
    "rolled_back": true,
    "requested_count": 57,
    "deleted_count": 57,
    "failed_count": 0,
    "deleted_row_ids_sample": [],
    "failed_row_ids_sample": []
  }