What it does
Insert one row. A client-supplied id is ignored. This does not create a page version. Set sample true for a row a site template should copy. clear_sample_data removes those rows later. The row carries _created_by and _updated_by (who wrote it), so the row needs no column for the writer's name. On an own_and_shared table a new row is shared; a member or site agent passes private true to keep it to itself (and the owner).
Plans
Works on every plan: Free, Basic, Pro and Ultra.
Parameters
| Name | Type | About |
|---|---|---|
namerequired | string | The table. |
rowrequired | object | The new row's column values, by column key. |
private | boolean | Only for a member or site agent writing to an own_and_shared table: true keeps the new rows to you (and the owner). Default false: shared with every member and agent of the site. Rows that already exist keep their owner. |
site_id | string | Only for a site shared with you (whoami lists them): read or change that site's data as its member. |
idempotency_key | string | Any unique string (1-200 printable ASCII). A retry with the same key and arguments returns the first call's result instead of running again. Same as the Idempotency-Key header. |
Example
Call create_row with these arguments:
{
"name": "recipes",
"row": {
"title": "Lentil soup",
"minutes": 35,
"vegetarian": true
}
}
Ids like 01a1… stand for your own. list_sites and list_tables give you the real ones.
Related guides
- Load rowsFill a table in one go, without duplicates.