Link Records

curl --request POST \
  --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.post(url, json=payload, headers=headers)

print(response.text)

const options = {
  method: 'POST',
  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 => "POST",
  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("POST", 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.post("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::Post.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_body

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

noCo

api

workspaces

{workspaceId}

tables

{workbookId}

linkRecordV2

Link Records

curl --request POST \
  --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.post(url, json=payload, headers=headers)

print(response.text)

const options = {
  method: 'POST',
  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 => "POST",
  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("POST", 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.post("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::Post.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_body

Authorizations

Authorization

string

header

required

This API uses OAuth 2.0 with the authorization code grant flow.

Path Parameters

workspaceId

string<uuid>

required

Workspace identifier

workbookId

string<uuid>

required

Workbook identifier

Body

application/json

sourceRecordId

integer

required

Primary key of the record in the current (source) table

destinationRecordId

integer

required

Primary key of the record in the destination table

linkColumnId

string<uuid>

required

LINK column ID or link dataType columnId for LookUp

Response

200

Records linked successfully

Getting Started

Workspaces

Sign up

AI Extraction

WorkBook

Links & Joins

Knowledge Graph

Enterprise Search

Link Records

1️⃣ Overview

2️⃣ Endpoint

3️⃣ Path Parameters

4️⃣ Authentication

5️⃣ Request Headers

6️⃣ Request Body Schema

7️⃣ Field Descriptions

8️⃣ Example Request

9️⃣ Behavior Summary

Authorizations

Path Parameters

Body

Response