Batch Update Rows

Update multiple specific rows by their IDs in a single request. Each entry in the `updates` array specifies a row ID and the fields to update. Validates against the table schema and unique constraints. Up to 1000 rows can be updated per request.

PATCH/api/v1/tables/{tableId}/rows

Authorization

apiKey
X-API-Key<token>

Your Sim API key (personal or workspace). Generate one from the Sim dashboard under Settings > API Keys.

In: header

Path Parameters

tableId*string

The unique identifier of the table.

Request Body

application/json

TypeScript Definitions

Use the request body type in TypeScript.

Response Body

application/json

application/json

application/json

application/json

application/json

application/json

curl -X PATCH \  "https://www.sim.ai/api/v1/tables/{tableId}/rows" \  -H "X-API-Key: YOUR_API_KEY" \  -H "Content-Type: application/json" \  -d '{    "workspaceId": "YOUR_WORKSPACE_ID",    "updates": [      { "rowId": "row_abc123", "data": { "status": "active" } },      { "rowId": "row_def456", "data": { "status": "archived" } }    ]  }'
{
  "success": true,
  "data": {
    "message": "Rows updated successfully",
    "updatedCount": 2,
    "updatedRowIds": [
      "row_abc123",
      "row_def456"
    ]
  }
}
{
  "error": "string",
  "details": [
    {}
  ]
}
{
  "error": "string"
}
{
  "error": "string"
}
{
  "error": "string"
}
{
  "error": "string"
}