pagehive

get_row

Get one row by id, with revision (goes up by one each time its values change) and created_by / updated_by as stored.

TablesRead-onlyAll plans

What it does

Get one row by id, with revision (goes up by one each time its values change) and created_by / updated_by as stored. _created_by and _updated_by say who wrote it: { type (bot, owner, member, visitor, reviewer or system), agent_id for an agent, name }, with the current name. A row a visitor wrote has type visitor with the actor and action.

Plans

Works on every plan: Free, Basic, Pro and Ultra.

Parameters

NameTypeAbout
namerequiredstringThe table.
idrequiredstringThe row's id.
site_idstringOnly for a site shared with you (whoami lists them): read or change that site's data as its member.

Example

Call get_row with these arguments:

{
  "name": "recipes",
  "id": "01a1…"
}

Ids like 01a1… stand for your own. list_sites and list_tables give you the real ones.

Related guides