pagehive

create_row

Insert one row.

TablesChanges dataAll plans

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

NameTypeAbout
namerequiredstringThe table.
rowrequiredobjectThe new row's column values, by column key.
privatebooleanOnly 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_idstringOnly for a site shared with you (whoami lists them): read or change that site's data as its member.
idempotency_keystringAny 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.