#Overview
Use row and cell write endpoints to push data into a list or advance workflow state. Cells are keyed by column ID.
#Endpoints
| Endpoint | Description |
|---|---|
POST /v1/lists/{tableId}/rows |
Add rows. |
PATCH /v1/lists/{tableId}/cells |
Update cells in batch. |
DELETE /v1/lists/{tableId}/rows |
Delete rows. |
#Add Rows
Objects and arrays can be sent as JSON values when the column type supports structured data.
{
"userId": "usr_123",
"rows": [
{
"cells": {
"company": "Acme",
"domain": "acme.com",
"status": "pending",
"metadata": {
"source": "import",
"priority": 3
}
}
}
]
}
curl -X POST https://api.bigmind.ai/v1/lists/tbl_123/rows \
-H "Authorization: Bearer sk_your_api_key_here" \
-H "Content-Type: application/json" \
-d '{
"userId": "usr_123",
"rows": [
{
"cells": {
"company": "Acme",
"domain": "acme.com",
"status": "pending"
}
}
]
}'
#Update Cells
Send one or more cell updates. Each update identifies the row, column, and new value.
{
"userId": "usr_123",
"updates": [
{
"rowId": "row_123",
"columnId": "status",
"value": "ready"
},
{
"rowId": "row_123",
"columnId": "notes",
"value": "Reviewed and ready for outreach"
}
]
}
curl -X PATCH https://api.bigmind.ai/v1/lists/tbl_123/cells \
-H "Authorization: Bearer sk_your_api_key_here" \
-H "Content-Type: application/json" \
-d '{
"userId": "usr_123",
"updates": [
{
"rowId": "row_123",
"columnId": "status",
"value": "ready"
}
]
}'
#Delete Rows
{
"userId": "usr_123",
"rowIds": ["row_123", "row_456"]
}
curl -X DELETE https://api.bigmind.ai/v1/lists/tbl_123/rows \
-H "Authorization: Bearer sk_your_api_key_here" \
-H "Content-Type: application/json" \
-d '{
"userId": "usr_123",
"rowIds": ["row_123"]
}'
