table-rows

Set many table cell values

Apply up to 1000 manual cell edits in ONE transaction, then recompute their downstream formula cells: inline when the scope is small (see recomputed_column_ids), otherwise via a SINGLE cell-edited run covering all of them. The endpoint that makes a grid paste one request instead of N. A null value clears that cell. All-or-nothing: every column and value is validated before anything is written, so a formula column or a type mismatch anywhere rejects the whole batch and writes nothing. Same-value edits are counted in skipped and write nothing. Read-your-writes: the response carries every named row's post-write state and version.

A Select or Multi-select cell takes only the column's own options (its type_options.choices): each value is matched to one ignoring case and spacing and stored as the option is spelled, and one that names no option refuses the whole batch with a 422 cell_value_not_a_choice naming the cell and the options. restore is for the grid's undo and redo history ONLY: it writes back a value the options no longer name exactly as the cell held it. Never set it to get a new value past the options; add the value to the column's options instead.

post/tables/{table_id}/cells/bulk/

Request

  • Base URL: https://api.getoneprofile.ai (the document declares no server; this is the origin it was published from)
  • URL: https://api.getoneprofile.ai/tables/{table_id}/cells/bulk/
  • Auth: one of:
    • API key in header X-API-Key
    • HTTP bearer

Path parameters

table_idstring uuid required

Request body

restoreboolean

History only: set by the grid's undo and redo, which put back exactly what a cell held before. A Select or Multi-select value the column's options no longer name is then written back as it was, and no option is added; a number goes back with every digit it had, unrounded. Every other writer, AI agents and integrations included, leaves it false: a new value must be one of the column's options, and a number is rounded to the column's places.

Response

Successful Response

appliedinteger required

Edits that changed a value and were written.

recomputed_column_idsstring[]

Formula columns recomputed INLINE within this request. Their values in rows are final and no background run was requested. Empty when a run was queued instead.

skippedinteger required

Same-value edits that wrote nothing.

stale_column_idsstring[] required

Transitive formula dependents now marked stale across all edited rows.

Changes

No recorded changes to this operation across all 1 revision of this API.