De-Link Records
curl --request DELETE \
--url https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/linkRecordV2 \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
[
{
"sourceRecordId": 1,
"destinationRecordId": 1,
"linkColumnId": "21224153-2f85-4b24-a306-4cfbc7e73f70"
},
{
"sourceRecordId": 1,
"destinationRecordId": 2,
"linkColumnId": "21224153-2f85-4b24-a306-4cfbc7e73f70"
}
]
'import requests
url = "https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/linkRecordV2"
payload = [
{
"sourceRecordId": 1,
"destinationRecordId": 1,
"linkColumnId": "21224153-2f85-4b24-a306-4cfbc7e73f70"
},
{
"sourceRecordId": 1,
"destinationRecordId": 2,
"linkColumnId": "21224153-2f85-4b24-a306-4cfbc7e73f70"
}
]
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.delete(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'DELETE',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify([
{
sourceRecordId: 1,
destinationRecordId: 1,
linkColumnId: '21224153-2f85-4b24-a306-4cfbc7e73f70'
},
{
sourceRecordId: 1,
destinationRecordId: 2,
linkColumnId: '21224153-2f85-4b24-a306-4cfbc7e73f70'
}
])
};
fetch('https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/linkRecordV2', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/linkRecordV2",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "DELETE",
CURLOPT_POSTFIELDS => json_encode([
[
'sourceRecordId' => 1,
'destinationRecordId' => 1,
'linkColumnId' => '21224153-2f85-4b24-a306-4cfbc7e73f70'
],
[
'sourceRecordId' => 1,
'destinationRecordId' => 2,
'linkColumnId' => '21224153-2f85-4b24-a306-4cfbc7e73f70'
]
]),
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>",
"Content-Type: application/json"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/linkRecordV2"
payload := strings.NewReader("[\n {\n \"sourceRecordId\": 1,\n \"destinationRecordId\": 1,\n \"linkColumnId\": \"21224153-2f85-4b24-a306-4cfbc7e73f70\"\n },\n {\n \"sourceRecordId\": 1,\n \"destinationRecordId\": 2,\n \"linkColumnId\": \"21224153-2f85-4b24-a306-4cfbc7e73f70\"\n }\n]")
req, _ := http.NewRequest("DELETE", url, payload)
req.Header.Add("Authorization", "Bearer <token>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.delete("https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/linkRecordV2")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("[\n {\n \"sourceRecordId\": 1,\n \"destinationRecordId\": 1,\n \"linkColumnId\": \"21224153-2f85-4b24-a306-4cfbc7e73f70\"\n },\n {\n \"sourceRecordId\": 1,\n \"destinationRecordId\": 2,\n \"linkColumnId\": \"21224153-2f85-4b24-a306-4cfbc7e73f70\"\n }\n]")
.asString();require 'uri'
require 'net/http'
url = URI("https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/linkRecordV2")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Delete.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "[\n {\n \"sourceRecordId\": 1,\n \"destinationRecordId\": 1,\n \"linkColumnId\": \"21224153-2f85-4b24-a306-4cfbc7e73f70\"\n },\n {\n \"sourceRecordId\": 1,\n \"destinationRecordId\": 2,\n \"linkColumnId\": \"21224153-2f85-4b24-a306-4cfbc7e73f70\"\n }\n]"
response = http.request(request)
puts response.read_bodyLinks & Joins
De-Link Records
1️⃣ Overview
Purpose: Removes existing links between records in a source table and records in a destination table. Supports batch de-linking of multiple record pairs in a single request.
2️⃣ Endpoint
DELETE /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 | Primary key of the record in the current (source) table |
| destinationRecordId | integer | ✅ Yes | Primary key of the record in the destination table |
| linkColumnId | UUID | ✅ Yes | LINK column ID or link dataType columnId |
8️⃣ Example Request
curl -X DELETE 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"
}
]'
```
DELETE
/
noCo
/
api
/
v2
/
workspaces
/
{workspaceId}
/
tables
/
{workbookId}
/
linkRecordV2
De-Link Records
curl --request DELETE \
--url https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/linkRecordV2 \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
[
{
"sourceRecordId": 1,
"destinationRecordId": 1,
"linkColumnId": "21224153-2f85-4b24-a306-4cfbc7e73f70"
},
{
"sourceRecordId": 1,
"destinationRecordId": 2,
"linkColumnId": "21224153-2f85-4b24-a306-4cfbc7e73f70"
}
]
'import requests
url = "https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/linkRecordV2"
payload = [
{
"sourceRecordId": 1,
"destinationRecordId": 1,
"linkColumnId": "21224153-2f85-4b24-a306-4cfbc7e73f70"
},
{
"sourceRecordId": 1,
"destinationRecordId": 2,
"linkColumnId": "21224153-2f85-4b24-a306-4cfbc7e73f70"
}
]
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.delete(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'DELETE',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify([
{
sourceRecordId: 1,
destinationRecordId: 1,
linkColumnId: '21224153-2f85-4b24-a306-4cfbc7e73f70'
},
{
sourceRecordId: 1,
destinationRecordId: 2,
linkColumnId: '21224153-2f85-4b24-a306-4cfbc7e73f70'
}
])
};
fetch('https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/linkRecordV2', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/linkRecordV2",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "DELETE",
CURLOPT_POSTFIELDS => json_encode([
[
'sourceRecordId' => 1,
'destinationRecordId' => 1,
'linkColumnId' => '21224153-2f85-4b24-a306-4cfbc7e73f70'
],
[
'sourceRecordId' => 1,
'destinationRecordId' => 2,
'linkColumnId' => '21224153-2f85-4b24-a306-4cfbc7e73f70'
]
]),
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>",
"Content-Type: application/json"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/linkRecordV2"
payload := strings.NewReader("[\n {\n \"sourceRecordId\": 1,\n \"destinationRecordId\": 1,\n \"linkColumnId\": \"21224153-2f85-4b24-a306-4cfbc7e73f70\"\n },\n {\n \"sourceRecordId\": 1,\n \"destinationRecordId\": 2,\n \"linkColumnId\": \"21224153-2f85-4b24-a306-4cfbc7e73f70\"\n }\n]")
req, _ := http.NewRequest("DELETE", url, payload)
req.Header.Add("Authorization", "Bearer <token>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.delete("https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/linkRecordV2")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("[\n {\n \"sourceRecordId\": 1,\n \"destinationRecordId\": 1,\n \"linkColumnId\": \"21224153-2f85-4b24-a306-4cfbc7e73f70\"\n },\n {\n \"sourceRecordId\": 1,\n \"destinationRecordId\": 2,\n \"linkColumnId\": \"21224153-2f85-4b24-a306-4cfbc7e73f70\"\n }\n]")
.asString();require 'uri'
require 'net/http'
url = URI("https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/linkRecordV2")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Delete.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "[\n {\n \"sourceRecordId\": 1,\n \"destinationRecordId\": 1,\n \"linkColumnId\": \"21224153-2f85-4b24-a306-4cfbc7e73f70\"\n },\n {\n \"sourceRecordId\": 1,\n \"destinationRecordId\": 2,\n \"linkColumnId\": \"21224153-2f85-4b24-a306-4cfbc7e73f70\"\n }\n]"
response = http.request(request)
puts response.read_bodyAuthorizations
This API uses OAuth 2.0 with the authorization code grant flow.
Path Parameters
Workspace identifier
Workbook identifier
Body
application/json
Response
200
Records de-linked successfully