Skip to main content
Record routes operate on rows inside one table. Records are JSON objects, and values should be simple JSON values like strings, numbers, booleans, or null. Arrays and nested objects are rejected.

​
List rows

curl "$BASE_URL/projects/$PROJECT/records/recipes?limit=50&offset=0" \
  -H "Authorization: Bearer $ZANGTABLE_TOKEN"

​
Insert a row

curl -X POST "$BASE_URL/projects/$PROJECT/records/recipes" \
  -H "Authorization: Bearer $ZANGTABLE_TOKEN" \
  -H "Content-Type: application/json" \
  --data '{"title":"Lemon pasta","status":"active"}'

​
Bulk update with a where clause

curl -X PATCH "$BASE_URL/projects/$PROJECT/records/recipes" \
  -H "Authorization: Bearer $ZANGTABLE_TOKEN" \
  -H "Content-Type: application/json" \
  --data '{
    "data": {"status":"archived"},
    "where": [
      {"column":"status","op":"=","value":"active"}
    ]
  }'

List records

Create record

Bulk update

Delete record