Link Records
Links & Joins
Link Records
1️⃣ Overview
Purpose: Links one or more records from a source table to records in a destination table via a LINK column. Supports batch linking of multiple record pairs in a single request.
2️⃣ Endpoint
POST /noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/linkRecordV2
3️⃣ Path Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| workspaceId | UUID | ✅ Yes | Workspace identifier |
| workbookId | UUID | ✅ Yes | Workbook identifier |
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
[
{
"sourceRecordId": integer,
"destinationRecordId": integer,
"linkColumnId": "uuid"
}
]
7️⃣ Field Descriptions
| Field | Type | Required | Description |
|---|---|---|---|
| sourceRecordId | integer | ✅ Yes | The row ID of the source record in the current table that you want to link to the destination record. |
| destinationRecordId | integer | ✅ Yes | The row ID of the destination record in the linked table that you want to link to the source record. |
| linkColumnId | UUID | ✅ Yes | ID of the LINK type column in the current table, or the link dataType columnId for a LookUp column |
8️⃣ Example Request
curl -X POST https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/linkRecordV2 \
-H "Authorization: Bearer <token>" \
-H "Content-Type: application/json" \
-d '[
{
"sourceRecordId": 1,
"destinationRecordId": 1,
"linkColumnId": "21224153-2f85-4b24-a306-4cfbc7e73f70"
},
{
"sourceRecordId": 1,
"destinationRecordId": 2,
"linkColumnId": "21224153-2f85-4b24-a306-4cfbc7e73f70"
}
]'
9️⃣ Behavior Summary
Links records between two tables via a LINK column.
Supports:
• Batch linking multiple record pairs in one request
• sourceRecordId — PK of the record in the current table
• destinationRecordId — PK of the record in the destination table
• linkColumnId — the LINK column ID or link dataType columnId for LookUp
POST
Link Records
Authorizations
This API uses OAuth 2.0 with the authorization code grant flow.
Path Parameters
Workspace identifier
Workbook identifier
Body
application/json
Response
200
Records linked successfully