Skip to content
Aurabase Logo
aurabase

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.

Query + body#

ParameterTypeRequiredDescription
<column>=<op>.<value>filteryesFilter 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}.
bodyobjectyesColumns to update. Columns not present remain unchanged.

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 every row that RLS lets through. Always filter explicitly.

Tip

Prefer: return=minimal responds 204 without body. Prefer: count=exact adds Content-Range: */{n} and Preference-Applied.