Skip to main content
PATCH
/
v1
/
tables
/
{table_id}
/
rows
Update Table Rows
curl --request PATCH \
  --url https://api.extruct.ai/v1/tables/{table_id}/rows \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "rows": [
    {
      "data": {},
      "metadata": {},
      "id": "<string>"
    }
  ],
  "run": false
}
'
[
  {
    "id": "<string>",
    "created_at": "2023-11-07T05:31:56Z",
    "parent_row_id": "<string>",
    "company_profile_id": "<string>",
    "data": {},
    "metadata": {},
    "parent_data": {}
  }
]

Overview

This endpoint updates existing row data in bulk. In most workflows, you identify the row you want to change with id and send the new data payload. Use run=false when you want to inspect the row changes before running anything. Use run=true when the update should immediately trigger execution.

Example request

export EXTRUCT_API_TOKEN="YOUR_API_TOKEN"
export TABLE_ID="YOUR_TABLE_ID"

curl -X PATCH "https://api.extruct.ai/v1/tables/${TABLE_ID}/rows" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer ${EXTRUCT_API_TOKEN}" \
  -d '{
    "rows": [
      {
        "id": "YOUR_ROW_ID",
        "data": {"input": "https://stripe.com"}
      }
    ],
    "run": false
  }'

Key parameters

  • table_id (required): target table identifier.
  • rows (required): array of row update objects; each requires data and can include id for the target row.
  • run (optional): defaults to false; set true to run after update.

Success signal

A successful response returns updated row objects with current values.

Common errors

401 Unauthorized

Check that your header is Authorization: Bearer ${EXTRUCT_API_TOKEN}.

404 Not Found

The table or row ID is invalid or unavailable in your workspace.

422 Unprocessable Entity

Most often caused by invalid rows shape or malformed JSON.

Authorizations

Authorization
string
header
required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Path Parameters

table_id
string
required

Body

application/json
rows
UpdateRowSchema · object[]
required
run
boolean
default:false

Response

Successful Response

id
string
required
created_at
string<date-time>
required

Row creation time.

parent_row_id
string | null

ID of the parent row, if any.

company_profile_id
string | null

ID of the linked company profile.

data
Data · object
metadata
object

Additional metadata

parent_data
object

Data from the parent row, if requested and available.