Tables

Insert table rows

Write up to 500 rows in one batch, keyed by field key. Values are coerced against the field kinds and the WHOLE batch is rejected if any cell cannot be read as its field's kind, so a partial batch never lands. A computed, system, relation or attachment key in the body is refused with FIELD_READ_ONLY rather than ignored. Rows whose identity matches a deleted row are skipped, never resurrected.

post/v1/tables/{tableId}/rows

Request

  • Base URL: https://api.banksync.io
  • URL: https://api.banksync.io/v1/tables/{tableId}/rows
  • Auth: one of:
    • API key in header X-API-Key
    • HTTP bearer

Path parameters

tableIdstring required

Table ID

Request body

rowsobject[] required
mode'upsert' | 'append' | 'insert'
mergeOnstring[]
onMany'fail' | 'first'
typecastboolean

Response

Batch written

successtrue required
insertedinteger required
updatedinteger required
skippedTombstonedinteger required
placement'positioned' | 'appended'
insertedRowIdsstring[] required
updatedRowIdsstring[] required

Changes

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