Update Rows

Bulk update rows matching a filter. All matching rows will have the specified fields updated. Validates against schema and unique constraints.

PUT/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 PUT \  "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",    "filter": { "status": "pending" },    "data": { "status": "active" }  }'
{
  "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"
}
PATCHUpdate RowPOSTUpsert Row