Skip to main content
POST
Insert rows into 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}$

Body

application/json

The rows to insert. Any other field is refused.

rows
object[]
required

The rows to insert, 1 to 100, all or none. Each is an object of column name to value. The sites gateway checks the columns and values against the site's schema, and sets the four system columns, so a row that names one is refused.

Required array length: 1 - 100 elements

Response

The rows were inserted.

The rows an insert added.

rows
object[]
required

The inserted rows, in the order sent, with created_by set to the admin's user id.

status
integer
required

The HTTP status.

meta
object
required

Response metadata included on every response body.