Using
Inserts one row from a JSON object body (`{column: value, …}`). An omitted AUTOINCREMENT primary key is assigned the next sequence value; this compiles onto the exact same bound INSERT plan `/sql` would use.
applies to v0.5.1POST
/store-api/rel/{domain}/tables/{table}/rows
const url = 'https://example.com/store-api/rel/example/tables/example/rows';const options = { method: 'POST', headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'}, body: '{}'};
try { const response = await fetch(url, options); const data = await response.json(); console.log(data);} catch (error) { console.error(error);}curl --request POST \ --url https://example.com/store-api/rel/example/tables/example/rows \ --header 'Authorization: Bearer <token>' \ --header 'Content-Type: application/json' \ --data '{}'Authorizations
Section titled “Authorizations”Parameters
Section titled “Parameters”Path Parameters
Section titled “Path Parameters”domain
required
string
Relational domain
table
required
string
Table name
Request Bodyrequired
Section titled “Request Bodyrequired”Media typeapplication/json
object
Example generated
{}Responses
Section titled “Responses”Row inserted
Media typeapplication/json
object
Example generated
{}NOT NULL/type/schema violation
Media typetext/plain
string
Missing read access to a linked KV/JSON domain
Media typetext/plain
string
Domain, table, or referenced body column not found
Media typetext/plain
string
PK collision, unique violation, or missing REFERENCES target
Media typetext/plain
string
Domain is being deleted
Media typetext/plain
string
Per-domain request budget exceeded
Media typetext/plain
string
Relational engine disabled
Media typetext/plain
string
Insufficient Storage — disk space or memory runs short; the write was not applied. Reads go on; retry after the seconds in Retry-After.
Media typetext/plain
string
Headers
Section titled “Headers”Retry-After
integer