Bulk create rows - Autotouch AI

This page documents the canonical HTTP contract for this endpoint.

The response follows BulkDataResponse with exactly rowsCreated, columnsCreated, and columnTypes; the example values are illustrative.

Path parameters

table_idrequired
string
The table ID.

Name	Type	Description
table_idrequired	string	The table ID.

Body parameters

origin · optional
string
Origin for created columns; default api. Allowed: manual, csv, api, ai, email_finder, email_validator, phone_finder, outreach, onboarding, crm_export, list_builder, agent_run, agent_source, system.
datarequired
array<object>
List of row objects keyed by column key; property values accept arbitrary JSON. No route-specific row count bound is declared.
detectTypes · optional
boolean
Auto-detect column data types from values. Default true.
createMissingColumns · optional
boolean
Create columns that do not yet exist. Default true; when false, data keys without existing columns are ignored.

Name	Type	Description
origin	string	Origin for created columns; default api. Allowed: manual, csv, api, ai, email_finder, email_validator, phone_finder, outreach, onboarding, crm_export, list_builder, agent_run, agent_source, system.
datarequired	array<object>	List of row objects keyed by column key; property values accept arbitrary JSON. No route-specific row count bound is declared.
detectTypes	boolean	Auto-detect column data types from values. Default true.
createMissingColumns	boolean	Create columns that do not yet exist. Default true; when false, data keys without existing columns are ignored.

Errors

Status	Meaning
401	Authentication required.
403	Access denied.
404	Table not found.
422	Invalid request body or origin enum.

Example

bash

curl -X POST "https://app.autotouch.ai/api/tables/67bd8c39c7d3e80f0a95b560/data" \
  -H "Authorization: Bearer stk_your_key_id.your_secret" \
  -H "Content-Type: application/json" \
  -d '{
    "data": [
      { "name": "John Doe", "email": "john@acme.com" },
      { "name": "Jane Smith", "email": "jane@beta.io" }
    ],
    "detectTypes": true
  }'

Request body

json

{
  "data": [
    { "name": "John Doe", "email": "john@acme.com", "company": "Acme Corp" },
    { "name": "Jane Smith", "email": "jane@beta.io", "company": "Beta Inc" }
  ],
  "detectTypes": true,
  "createMissingColumns": true
}

Response example

json

{
  "rowsCreated": 2,
  "columnsCreated": 3,
  "columnTypes": {"name": "text", "email": "text", "company": "text"}
}