> ## Documentation Index
> Fetch the complete documentation index at: https://docs.zangtable.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Records

> Read and write rows in your tables.

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

```bash theme={null}
curl "$BASE_URL/projects/$PROJECT/records/recipes?limit=50&offset=0" \
  -H "Authorization: Bearer $ZANGTABLE_TOKEN"
```

## Insert a row

```bash theme={null}
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

```bash theme={null}
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"}
    ]
  }'
```

<CardGroup cols={2}>
  <Card title="List records" icon="list" href="/reference/records/list-records" />

  <Card title="Create record" icon="plus" href="/reference/records/create-record" />

  <Card title="Bulk update" icon="pen-line" href="/reference/records/bulk-update-records" />

  <Card title="Delete record" icon="trash" href="/reference/records/delete-record" />
</CardGroup>