POST /csv

Ingest CSV rows (or JSON spreadsheet rows) as draft documents, one document per row.

Auth: Bearer JWT (WorkOS).

Query parameters

Request body

Two content types are accepted, dispatched on the Content-Type header.

multipart/form-data — fields:

• schema_name (text, required)
• file (raw CSV bytes, required). The first row is headers; every cell becomes a trimmed JSON string value.

application/json (max 10 MiB):

{
  "schema_name": "post",
  "spreadsheet_data": [ { "title": "Row 1" }, { "title": "Row 2" } ]
}

• schema_name (string, required)
• spreadsheet_data (array of objects, required)

Response

{ "inserted": 2 }

Returns 201 Created. Each row becomes a draft document; the document title is the row's first string value.

Example — JSON

curl -X POST '{CMS_API_URL}/csv?website_id=<uuid>' \
  -H 'Authorization: Bearer <workos-jwt>' \
  -H 'Content-Type: application/json' \
  -d '{"schema_name":"post","spreadsheet_data":[{"title":"Row 1"}]}'

Example — multipart CSV

curl -X POST '{CMS_API_URL}/csv?website_id=<uuid>' \
  -H 'Authorization: Bearer <workos-jwt>' \
  -F 'schema_name=post' \
  -F 'file=@data.csv'

Errors

• 400 — parse errors, missing schema_name/file, non-array spreadsheet_data, non-object rows, or empty CSV
• 401 — missing or invalid JWT
• 500 — insert failure