Tables
Update a record
Changes only the fields you send; a null value clears a field.
PATCH
https://app.getera.io/api/v1/tables/{tableId}/records/{recordId}API key
The fields you send change; the rest stay as they are. To clear a field, send null as its value.
Authentication
An API key in the x-api-key header; write permission in Tables. See Authentication.
Path parameters
| Name | Type | Required | Description |
|---|---|---|---|
tableId | UUID | Yes | The table's id. |
recordId | UUID | Yes | The record's id. |
Body
A JSON object: field key → new value. Arrays are refused.
Example
curl -X PATCH https://app.getera.io/api/v1/tables/3f2a9c1e-0000-4000-8000-000000000001/records/8b1d0c4e-0000-4000-8000-000000000010 \
-H "x-api-key: ERA_API_KEY" \
-H "Content-Type: application/json" \
-d '{"status": "Refunded", "note": null}'Response
{ "id": "8b1d0c4e-0000-4000-8000-000000000010" }Errors
| Status | When |
|---|---|
400 | The body is not a JSON object. |
401 | Missing or invalid key. |
403 | No write permission, or the key's owner is not in the workspace. |
404 | Record or table not found. |
409 | A rule refused it. Example code values: row_not_found, unknown_field, type_mismatch, readonly_field, required_field_missing, row_policy_denies, invalid_field_format. |
422 | The input is malformed. |
429 | Rate limit. |