Skip to main content
PATCH
Change a row of a table of a site's database

Authorizations

Authorization
string
header
required

A company admin credential for your company, or a droplet installation token with the website scope for reads, except on the share routes, which refuse a droplet token.

Path Parameters

id
string<uuid>
required

The site's id.

table
string
required

The table's name, as the tables route lists it.

Pattern: ^[a-z][a-z0-9_]{0,62}$
row_id
string
required

The id of the row to change, a UUID, in lowercase or capitals.

Pattern: ^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}$

Body

application/json

The columns to change. Any other field is refused.

row
object
required

The columns to change, as column name to new value. The sites gateway checks them against the site's schema, refuses a system column, and sets updated_at.

Response

The row after the change.

The row an update changed.

row
object
required

A row, as an object of the table's columns and its four system columns (id, created_by, created_at, updated_at), with the values the sites gateway answers (integer above 2^53 as a string, json as JSON).

status
integer
required

The HTTP status.

meta
object
required

Response metadata included on every response body.