Skip to main content
PATCH
https://api-zangtable.com
/
projects
/
{project}
/
records
/
{table}
PATCH /projects/{project}/records/{table}
curl --request PATCH \
  --url https://api-zangtable.com/projects/{project}/records/{table} \
  --header 'Authorization: <authorization>'
{
  "ok": true,
  "data": {},
  "error": {},
  "request_id": "<string>"
}
Bulk-updates rows matching a where clause.

​
Endpoint details

​
Authorization
string
required
Bearer pat_... (Project API Token). Keep this token on your backend/server.
​
project
string
required
Project slug. This acts as the Project ID in API paths.
​
table
string
required
Table name inside the project.
​
ok
boolean
required
true for a successful response and false for an error response.
​
data
object | null
Endpoint-specific response data when ok is true; null on errors.
​
error
object | null
Error code and message when ok is false; null on success.
​
request_id
string
required
Request identifier you can use when troubleshooting a specific API call.

​
Authentication

Project API Token.

​
Parameters

Path: table required. Body: data required non-empty object; where optional object or condition array; allow_all optional boolean. If where is empty, allow_all must be true.

​
Request examples

Basic request: 
curl -X PATCH "$BASE_URL/projects/{project}/records/{table}" \
  -H 'Authorization: Bearer pat_PROJECT_TOKEN' \
  -H 'Content-Type: application/json' \
  --data '{"data":{"status":"archived"},"where":{"status":"inactive"}}'
Full request: 
curl -X PATCH "$BASE_URL/projects/{project}/records/{table}" \
  -H 'Authorization: Bearer pat_PROJECT_TOKEN' \
  -H 'Content-Type: application/json' \
  -H 'X-Operation-Key: edit-profile-email' \
  -H 'X-Operation-Run-Id: oprun_client_20260602_001' \
  --data '{"data":{"status":"archived","updated_by":"api"},"where":[{"column":"created_at","op":"<","value":"2026-01-01"},{"column":"deleted_at","op":"is_null"}],"allow_all":false}'

​
Response examples

Success: 
{
  "ok": true,
  "data": {
    "table": "contacts",
    "affected_rows": 3
  },
  "error": null,
  "request_id": "req_20260602T012345_123456Z_abc123def456",
  "operation_key": "edit-profile-email",
  "operation_run_id": "oprun_20260602T012300_000000Z_a1b2c3d4e5f6",
  "operation_grouping_status": "accepted_provided_run",
  "meta": {
    "generated_at": "2026-06-02T01:23:45Z"
  }
}
Error or alternate response: 
{
  "ok": false,
  "data": null,
  "error": {
    "code": "where_required",
    "message": "Bulk update requires an explicit where clause unless an admin sets allow_all=true."
  },
  "request_id": "req_20260602T012345_123456Z_abc123def456",
  "meta": {
    "generated_at": "2026-06-02T01:23:45Z"
  }
}