Update rows
PATCH
/v1/db/{project_id}/{table}Updates the rows that match the filter. RLS enforced — a client can only update what it can SELECT.
This English text was generated automatically from the French original and has not been reviewed yet.
#
Request
Query + body
| Parameter | Type | Required | Description |
|---|---|---|---|
<column>=<op>.<valeur> | filter | yes | Filter in query parameter (?id=eq.$ID). On the aura-db path, a request without filter is refused with 400. Alternative: target a line by its identifier with PATCH /v1/db/{project_id}/{table}/{id}. |
body | object | yes | Columns to update. Columns not present remain unchanged. |
#
Notes
Protection
Attention
The “at least one filter” safeguard is that of aura-db (MongoDB project, or Postgres without PostgREST): it responds 400. On a Postgres project served by PostgREST, this safeguard does not exist on the Aurabase side — a PATCH without filter affects all the lines that the RLS lets through. Always filter explicitly.
Astuce
Prefer: return=minimal responds 204 without body. Prefer: count=exact adds Content-Range: */{n} and Preference-Applied.
v1.0 · revised Apr 15, 2026