Batch writes

POST /{appUid}/autocrud/{table}/batch writes many rows of one table in one request and one transaction. Either every row is written, or none is.

The body carries exactly one of three keys:

curl -X POST "$AUTHORIC_URL/$APP_UID/autocrud/invoices/batch" \
  -H "Authorization: Bearer $TOKEN" \
  -H "Content-Type: application/json" \
  -H "Idempotency-Key: 2c7a9e41-5d3b-4f08-a1e6-8b0d9c4f7a25" \
  -d '{
    "update": [
      { "uid": "0199b8e5-2f61-7a3c-8d40-91b6e7c2a5f3", "values": { "status": "approved" } },
      { "uid": "0199b8e5-4a08-7c1e-b5d2-3f9a6e1c8b47", "values": { "status": "approved" } }
    ]
  }'

What is checked

• Every row, as its single-row write. Each row passes the same permission (row conditions included), validation, references, redaction rules and limits as a POST, PATCH or DELETE of that one row would. A batch needs the permission of the write it carries: a batch of creates needs create on the table, a batch of deletes needs delete. A table that locks the operation refuses the batch.
• One refused row refuses the batch. Nothing is written, and the error's details.index names the row's position in the array, counting from 0.
• Rows are named by uid. An update or delete names each row by its uid. A uid that names no row you can reach is 404 ROW_NOT_FOUND, with its details.index. There is no write by condition over REST; a handler can do that with updateWhere and deleteWhere.
• Up to 500 rows. A larger batch is refused with BATCH_TOO_LARGE and details.maxRows. Split it.

Live subscribers hear about the batch's changes once it commits, as they would hear about the same writes made one at a time. See Realtime.

Safe to send again

Send an Idempotency-Key with every batch. A repeat with the same key and body answers with the first response and writes nothing, so a batch whose response was lost can be sent again. The rules are the API's usual ones; see Idempotency.

Errors to branch on

The client SDK sends a batch with createMany, updateMany and deleteMany; see Rows and realtime.

Next