Verify CSV import by task

This page documents the canonical HTTP contract for this endpoint.

Checks run against rows still present from the task manifest. expected_rows must be a nonnegative integer. Each require_non_empty ratio is inclusive from 0 to 1. Duplicate groups normalize key cell values by trimming and lowercasing; rows with every key part empty are excluded. A failed assertion returns HTTP 200 with passed: false and details in failures.

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

expected_rows · optional
integer (>= 0)
Compare the count of manifest rows that still exist in the table.
required_columns · optional
string
Comma-separated required column keys.
duplicate_key · optional
string
Comma-separated identity key columns for duplicate check.
require_non_empty · optional
string
Comma-separated key:ratio requirements; each ratio must be between 0 and 1 inclusive. Example: post_content:0.95

Name	Type	Description
expected_rows	integer (>= 0)	Compare the count of manifest rows that still exist in the table.
required_columns	string	Comma-separated required column keys.
duplicate_key	string	Comma-separated identity key columns for duplicate check.
require_non_empty	string	Comma-separated key:ratio requirements; each ratio must be between 0 and 1 inclusive. Example: post_content:0.95

Errors

Status	Meaning
401	Invalid API key or missing auth.
403	Missing tables:read scope or table access denied.
400	Invalid require_non_empty requirement; ratio must be between 0 and 1.
404	Import manifest not found for this table/task pair.

Example

bash

curl -X GET "https://app.autotouch.ai/api/tables/67bd8c39c7d3e80f0a95b560/import-verify/7f1e0d4f-6b6e-44ff-9fd2-03f2f7ebad85?expected_rows=57&required_columns=first_name,last_name,post_content&duplicate_key=linkedin_url,post_url&require_non_empty=post_content:1" \
    -H "Authorization: Bearer stk_your_key_id.your_secret"

Response example

json

{
    "task_id": "7f1e0d4f-6b6e-44ff-9fd2-03f2f7ebad85",
    "table_id": "67bd8c39c7d3e80f0a95b560",
    "manifest": { "status": "completed", "row_count": 57, "chunk_count": 1 },
    "scope": { "rows_in_manifest": 57, "rows_existing": 57 },
    "passed": true,
    "checks": {
      "expected_rows": { "expected": 57, "actual": 57, "passed": true },
      "required_columns": { "required": ["post_content"], "missing": [], "passed": true },
      "duplicate_key": { "keys": ["linkedin_url","post_url"], "duplicates": 0, "passed": true }
    },
    "failures": []
  }