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 rows to a Table sheet. Set count to the number of rows to append. The public API accepts 1 to 100 rows per request and defaults to 1 when count is omitted. Pass values as an array of objects keyed by column ID when you want to populate text cells as rows are created. Values beyond count are ignored, and missing values use the column default behavior. Rows are appended after the current last row. Output cells are created in a stale state so dependent computations can be recalculated.

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.