Skip to main content
POST
/
api
/
public
/
v2
/
tables
/
{table_id}
/
sheets
/
{sheet_id}
/
rows
Add Rows
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": [
    {}
  ]
}
'
{
  "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. Adding rows creates a new sheet version. The response returns version, the current sheet version count after the rows are appended.

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

Rows added

​
success
boolean
​
rows_created
integer
​
start_row_index
integer
​
row_indices
integer[]
​
rows
object[]
​
cell_count
integer
​
row_count
integer
​
version
integer

Current sheet version_count for this response. It matches the sheet's version_count after any committed changes.