Add Rows

Append one or more rows to a sheet. Text column values can be set immediately; non-text column cells are created with stale status and must be triggered via a recalculation.

POST /api/public/v2/tables/{table_id}/sheets/{sheet_id}/rows

Add Rows

cURL

curl --request POST \
  --url https://api.promptlayer.com/api/public/v2/tables/{table_id}/sheets/{sheet_id}/rows \
  --header 'Content-Type: application/json' \
  --header 'X-API-KEY: <api-key>' \
  --data '
{
  "count": 1,
  "values": [
    {}
  ]
}
'

201

{
  "success": true,
  "rows_created": 123,
  "start_row_index": 123,
  "row_indices": [
    123
  ],
  "rows": [
    {
      "row_index": 123,
      "cells": {}
    }
  ],
  "cell_count": 123,
  "row_count": 123,
  "version": 123
}

Append one or more rows (up to 100 at a time) to a sheet.

Text column values can be set immediately via the values array. Non-text column cells are created with stale status — trigger a recalculation to compute them.

Authorizations

X-API-KEY · string · header · required

Path Parameters

table_id · string<uuid> · required

sheet_id · string<uuid> · required

Body

application/json

count · integer · default: 1

Number of rows to append (1–100).

Required range: 1 <= x <= 100

values · object[] | null

Per-row initial values for text columns. Each element is a map of column_id → value.

Response

201

application/json

Rows added

success · boolean

rows_created · integer

start_row_index · integer

row_indices · integer[]

rows · object[]

Show child attributes

cell_count · integer

row_count · integer

version · integer