Update Row In Workbook
1️⃣ Overview
Purpose:
Updates an existing row in a specified table within a workspace.
This endpoint allows:
-
Updating one or more column values in a row
-
Triggering AI column regeneration (if dependent fields change)
-
Recomputing formulas (if applicable)
2️⃣ Endpoint
PUT /noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows
3️⃣ Path Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| workspaceId | UUID | ✅ Yes | Identifier of the workspace |
| workbookId | UUID | ✅ Yes | Identifier of the table |
4️⃣ Authentication
Requires Authorization
Authorization: Bearer <token>
5️⃣ Required Permissions
User must have:
-
Row edit permission
-
Table edit access
-
Workspace access
If row updates affect:
-
AI columns → AI execution permission required
-
Formula columns → system recalculates automatically
6️⃣ Request Headers
| Header | Required |
|---|---|
| Authorization | ✅ Yes |
| Content-Type: application/json | ✅ Yes |
7️⃣ Request Body Schema
{ "id": "number | string", "cellValues": { "columnName": "value" }
8️⃣ Field Descriptions
| Field | Type | Required | Description |
|---|---|---|---|
| id | Row identifier | ✅ Yes | Unique row ID |
| cellValues | Object | ❌ | Key-value map using column names |
9️⃣ Example Request
curl -X PUT \https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows \-H "Authorization: Bearer <token>" \-H "Content-Type: application/json" \-d '{ "id": 1, "cellValues": { "name": "dega" }
AI Column Interaction
If the table contains AI-enabled columns:
-
Updating dependent fields may:
-
Automatically regenerate AI values
-
Trigger asynchronous processing
-
-
If AI column is manual-override enabled:
- System may preserve manual values
✅ Validation Rules
-
Row ID must exist
-
Cannot update system-generated columns
-
Cannot update formula-only columns
-
Data must match column type
-
Required columns cannot be null