What it does
Update part of a row. Null clears a column. This does not create a page version. The row's revision goes up when its values change, so a visitor edit drawn from the old revision is refused with a conflict.
Plans
Works on every plan: Free, Basic, Pro and Ultra.
Parameters
| Name | Type | About |
|---|---|---|
namerequired | string | The table. |
idrequired | string | The row's id. |
rowrequired | object | The columns to change. Columns you leave out keep their value; null clears one. |
site_id | string | Only for a site shared with you (whoami lists them): read or change that site's data as its member. |
Example
Call update_row with these arguments:
{
"name": "recipes",
"id": "01a1…",
"row": {
"minutes": 30
}
}
Ids like 01a1… stand for your own. list_sites and list_tables give you the real ones.
Related guides
- Tables and columnsWhere your site's data lives, and who can read it.
- Load rowsFill a table in one go, without duplicates.