Tables

Update a record

Changes only the fields you send; a null value clears a field.

PATCHhttps://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

NameTypeRequiredDescription
tableIdUUIDYesThe table's id.
recordIdUUIDYesThe 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

StatusWhen
400The body is not a JSON object.
401Missing or invalid key.
403No write permission, or the key's owner is not in the workspace.
404Record or table not found.
409A rule refused it. Example code values: row_not_found, unknown_field, type_mismatch, readonly_field, required_field_missing, row_policy_denies, invalid_field_format.
422The input is malformed.
429Rate limit.