Add Row with Linked Records

curl --request POST \
  --url https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbook_id}/rows \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "cellValues": {
    "name": "",
    "notes": ""
  },
  "linkRecords": [
    {
      "destinationRecordId": 2,
      "linkColumnId": "ed7584c6-a33a-4779-b7bb-03a5d1345bb2"
    }
  ]
}
'

import requests

url = "https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbook_id}/rows"

payload = {
    "cellValues": {
        "name": "",
        "notes": ""
    },
    "linkRecords": [
        {
            "destinationRecordId": 2,
            "linkColumnId": "ed7584c6-a33a-4779-b7bb-03a5d1345bb2"
        }
    ]
}
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({
    cellValues: {name: '', notes: ''},
    linkRecords: [{destinationRecordId: 2, linkColumnId: 'ed7584c6-a33a-4779-b7bb-03a5d1345bb2'}]
  })
};

fetch('https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbook_id}/rows', 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/{workbook_id}/rows",
  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([
    'cellValues' => [
        'name' => '',
        'notes' => ''
    ],
    'linkRecords' => [
        [
                'destinationRecordId' => 2,
                'linkColumnId' => 'ed7584c6-a33a-4779-b7bb-03a5d1345bb2'
        ]
    ]
  ]),
  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/{workbook_id}/rows"

	payload := strings.NewReader("{\n  \"cellValues\": {\n    \"name\": \"\",\n    \"notes\": \"\"\n  },\n  \"linkRecords\": [\n    {\n      \"destinationRecordId\": 2,\n      \"linkColumnId\": \"ed7584c6-a33a-4779-b7bb-03a5d1345bb2\"\n    }\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/{workbook_id}/rows")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"cellValues\": {\n    \"name\": \"\",\n    \"notes\": \"\"\n  },\n  \"linkRecords\": [\n    {\n      \"destinationRecordId\": 2,\n      \"linkColumnId\": \"ed7584c6-a33a-4779-b7bb-03a5d1345bb2\"\n    }\n  ]\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbook_id}/rows")

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  \"cellValues\": {\n    \"name\": \"\",\n    \"notes\": \"\"\n  },\n  \"linkRecords\": [\n    {\n      \"destinationRecordId\": 2,\n      \"linkColumnId\": \"ed7584c6-a33a-4779-b7bb-03a5d1345bb2\"\n    }\n  ]\n}"

response = http.request(request)
puts response.read_body

{
  "id": 101,
  "cellValues": {
    "name": "",
    "notes": ""
  },
  "linkRecords": [
    {
      "destinationRecordId": 2,
      "linkColumnId": "ed7584c6-a33a-4779-b7bb-03a5d1345bb2"
    }
  ]
}

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

noCo

api

workspaces

{workspaceId}

tables

{workbook_id}

rows

Add Row with Linked Records

curl --request POST \
  --url https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbook_id}/rows \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "cellValues": {
    "name": "",
    "notes": ""
  },
  "linkRecords": [
    {
      "destinationRecordId": 2,
      "linkColumnId": "ed7584c6-a33a-4779-b7bb-03a5d1345bb2"
    }
  ]
}
'

import requests

url = "https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbook_id}/rows"

payload = {
    "cellValues": {
        "name": "",
        "notes": ""
    },
    "linkRecords": [
        {
            "destinationRecordId": 2,
            "linkColumnId": "ed7584c6-a33a-4779-b7bb-03a5d1345bb2"
        }
    ]
}
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({
    cellValues: {name: '', notes: ''},
    linkRecords: [{destinationRecordId: 2, linkColumnId: 'ed7584c6-a33a-4779-b7bb-03a5d1345bb2'}]
  })
};

fetch('https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbook_id}/rows', 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/{workbook_id}/rows",
  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([
    'cellValues' => [
        'name' => '',
        'notes' => ''
    ],
    'linkRecords' => [
        [
                'destinationRecordId' => 2,
                'linkColumnId' => 'ed7584c6-a33a-4779-b7bb-03a5d1345bb2'
        ]
    ]
  ]),
  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/{workbook_id}/rows"

	payload := strings.NewReader("{\n  \"cellValues\": {\n    \"name\": \"\",\n    \"notes\": \"\"\n  },\n  \"linkRecords\": [\n    {\n      \"destinationRecordId\": 2,\n      \"linkColumnId\": \"ed7584c6-a33a-4779-b7bb-03a5d1345bb2\"\n    }\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/{workbook_id}/rows")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"cellValues\": {\n    \"name\": \"\",\n    \"notes\": \"\"\n  },\n  \"linkRecords\": [\n    {\n      \"destinationRecordId\": 2,\n      \"linkColumnId\": \"ed7584c6-a33a-4779-b7bb-03a5d1345bb2\"\n    }\n  ]\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbook_id}/rows")

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  \"cellValues\": {\n    \"name\": \"\",\n    \"notes\": \"\"\n  },\n  \"linkRecords\": [\n    {\n      \"destinationRecordId\": 2,\n      \"linkColumnId\": \"ed7584c6-a33a-4779-b7bb-03a5d1345bb2\"\n    }\n  ]\n}"

response = http.request(request)
puts response.read_body

{
  "id": 101,
  "cellValues": {
    "name": "",
    "notes": ""
  },
  "linkRecords": [
    {
      "destinationRecordId": 2,
      "linkColumnId": "ed7584c6-a33a-4779-b7bb-03a5d1345bb2"
    }
  ]
}

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

workbook_id

string<uuid>

required

Target table identifier

Body

application/json

cellValues

object

required

Key-value map of column names and their initial values for the new row

Show child attributes

linkRecords

object[]

List of link operations to attach when creating the row

Show child attributes

Response

200 - application/json

Row created and linked successfully

integer

Auto-generated primary key of the newly created row

cellValues

object

The column values stored for the new row

Show child attributes

linkRecords

object[]

Confirmation of link relations established

Show child attributes

Add Lookup Column Get All Link Tables of Current Table

Getting Started

Workspaces

Sign up

AI Extraction

WorkBook

Links & Joins

Knowledge Graph

Enterprise Search

Add Row with Linked Records

1️⃣ Overview

2️⃣ Endpoint

3️⃣ Path Parameters

4️⃣ Authentication

5️⃣ Request Headers

6️⃣ Request Body Schema

7️⃣ Field Descriptions

Authorizations

Path Parameters

Body

Response