Add Row with Linked Records
Links & Joins
Add Row with Linked Records
1️⃣ Overview
Purpose: Creates a new row in the specified table and simultaneously links it to one or more records in associated tables via existing LINK columns.
This endpoint supports:
- Setting cell values for the new row at creation time
- Linking the new row to existing records in associated tables using
linkColumnId - Multiple link relations can be established in a single request
2️⃣ Endpoint
POST /noCo/api/v2/workspaces/{workspaceId}/tables/{workbook_id}/rows
3️⃣ Path Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| workspaceId | UUID | ✅ Yes | Workspace identifier |
| workbook_id | UUID | ✅ Yes | workbook where the row will be created |
4️⃣ Authentication
Requires Bearer JWT Token
Authorization: Bearer <token>
5️⃣ Request Headers
| Header | Required |
|---|---|
| Authorization | ✅ Yes |
| Content-Type: application/json | ✅ Yes |
6️⃣ Request Body Schema
{
"cellValues": {
"<columnName>": "<value>"
},
"linkRecords": [
{
"destinationRecordId": "integer",
"linkColumnId": "uuid"
}
]
}
7️⃣ Field Descriptions
| Field | Type | Required | Description |
|---|---|---|---|
| cellValues | object | ✅ Yes | Key-value map of column names and their values for the new row |
| cellValues.<columnName> | any | ❌ No | Value for a specific column — pass empty string or empty array if no value |
| linkRecords | array | ❌ No | List of link operations to perform when creating the row |
| linkRecords[].destinationRecordId | integer | ✅ Yes | PK of the record in the associated table to link to |
| linkRecords[].linkColumnId | UUID | ✅ Yes | ID of the LINK column that defines the relation |
POST
Add Row with Linked Records
Authorizations
This API uses OAuth 2.0 with the authorization code grant flow.
Path Parameters
Workspace identifier
Target table identifier
Body
application/json