Get Row Data By ID
1️⃣ Overview
Purpose:
Retrieves a single row’s complete data from a specified table within a workspace using its unique row ID.
This endpoint returns:
-
All column values for the row
-
AI-generated values (if applicable)
-
Formula-calculated values
-
System fields (if configured to return them)
2️⃣ Endpoint
GET /noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows/{rowId}
3️⃣ Path Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| workspaceId | UUID | ✅ Yes | Identifier of the workspace |
| workbookId | UUID | ✅ Yes | Identifier of the table |
| rowId | string / number | ✅ Yes | Unique identifier of the row |
4️⃣ Authentication
Requires Bearer JWT Token
Authorization: Bearer <token>
5️⃣ Required Permissions
User must have:
-
Workspace access
-
Table view permission
-
Row read permission
If table contains:
-
AI columns → permission to view generated content required
-
Restricted columns → values may be masked or omitted
6️⃣ Request Headers
| Header | Required |
|---|---|
| Authorization | ✅ Yes |
| Content-Type: application/json | Optional |
7️⃣ Request Example
curl -X GET https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows/{rowId} \
-H "Authorization: Bearer <token>"
8️⃣ Successful Response
Example Response
{ "id": 1, "values": { "name": "dega", "status": "Active", "ai_summary": "Generated summary text", "created_at": "2026-02-20T10:00:00Z" }, "createdAt": "2026-02-20T10:00:00Z", "updatedAt": "2026-02-26T12:45:00Z"}
9️⃣ Response Fields
| Field | Description |
|---|---|
| id | Row identifier |
| values | Key-value map of column names and values |
| createdAt | Row creation timestamp |
| updatedAt | Last modification timestamp |
🔄 Behavior
When this endpoint is called:
-
Validate workspace access
-
Validate table existence
-
Validate row existence
-
Validate user read permissions
-
Retrieve row data
-
Include:
-
Standard column values
-
AI-generated values
-
Formula results
-
-
Return structured JSON response
🤖 AI Column Handling
If the table contains AI-enabled columns:
-
Returns last generated value
-
Does not trigger regeneration
-
If generation is asynchronous and pending:
-
May return null
-
Or may return processing status (implementation-dependent)
-
📊 Formula Column Handling
If a column is a formula:
-
Returned value is the computed result
-
Manual override is not applicable
📌 Behavior Summary
This endpoint retrieves complete data for a specific row by ID within a workspace table. It supports standard column retrieval, AI-generated values, formula-computed values, and permission-based visibility.