Add Lookup Column

curl --request POST \
  --url https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{tableId}/columns \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "columns": [
    {
      "description": "",
      "uiMetadata": {
        "title": "lookup column"
      },
      "uiDataType": "LOOKUP",
      "colOptions": {
        "linkColumnId": "21224153-2f85-4b24-a306-4cfbc7e73f70",
        "lookupColumnId": "9b5e408d-69bb-42ca-8fa4-ba00f7994356"
      },
      "name": "lookup_column"
    }
  ]
}
'

import requests

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

payload = { "columns": [
        {
            "description": "",
            "uiMetadata": { "title": "lookup column" },
            "uiDataType": "LOOKUP",
            "colOptions": {
                "linkColumnId": "21224153-2f85-4b24-a306-4cfbc7e73f70",
                "lookupColumnId": "9b5e408d-69bb-42ca-8fa4-ba00f7994356"
            },
            "name": "lookup_column"
        }
    ] }
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({
    columns: [
      {
        description: '',
        uiMetadata: {title: 'lookup column'},
        uiDataType: 'LOOKUP',
        colOptions: {
          linkColumnId: '21224153-2f85-4b24-a306-4cfbc7e73f70',
          lookupColumnId: '9b5e408d-69bb-42ca-8fa4-ba00f7994356'
        },
        name: 'lookup_column'
      }
    ]
  })
};

fetch('https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{tableId}/columns', 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/{tableId}/columns",
  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([
    'columns' => [
        [
                'description' => '',
                'uiMetadata' => [
                                'title' => 'lookup column'
                ],
                'uiDataType' => 'LOOKUP',
                'colOptions' => [
                                'linkColumnId' => '21224153-2f85-4b24-a306-4cfbc7e73f70',
                                'lookupColumnId' => '9b5e408d-69bb-42ca-8fa4-ba00f7994356'
                ],
                'name' => 'lookup_column'
        ]
    ]
  ]),
  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/{tableId}/columns"

	payload := strings.NewReader("{\n  \"columns\": [\n    {\n      \"description\": \"\",\n      \"uiMetadata\": {\n        \"title\": \"lookup column\"\n      },\n      \"uiDataType\": \"LOOKUP\",\n      \"colOptions\": {\n        \"linkColumnId\": \"21224153-2f85-4b24-a306-4cfbc7e73f70\",\n        \"lookupColumnId\": \"9b5e408d-69bb-42ca-8fa4-ba00f7994356\"\n      },\n      \"name\": \"lookup_column\"\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/{tableId}/columns")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"columns\": [\n    {\n      \"description\": \"\",\n      \"uiMetadata\": {\n        \"title\": \"lookup column\"\n      },\n      \"uiDataType\": \"LOOKUP\",\n      \"colOptions\": {\n        \"linkColumnId\": \"21224153-2f85-4b24-a306-4cfbc7e73f70\",\n        \"lookupColumnId\": \"9b5e408d-69bb-42ca-8fa4-ba00f7994356\"\n      },\n      \"name\": \"lookup_column\"\n    }\n  ]\n}")
  .asString();

require 'uri'
require 'net/http'

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

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  \"columns\": [\n    {\n      \"description\": \"\",\n      \"uiMetadata\": {\n        \"title\": \"lookup column\"\n      },\n      \"uiDataType\": \"LOOKUP\",\n      \"colOptions\": {\n        \"linkColumnId\": \"21224153-2f85-4b24-a306-4cfbc7e73f70\",\n        \"lookupColumnId\": \"9b5e408d-69bb-42ca-8fa4-ba00f7994356\"\n      },\n      \"name\": \"lookup_column\"\n    }\n  ]\n}"

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

Links & Joins

Add Lookup Column

1️⃣ Overview

Purpose: Adds one or more LOOKUP type columns to a specified table. A lookup column pulls field values from a linked (associated) table via an existing LINK column.

2️⃣ Endpoint

POST /noCo/api/v2/workspaces/{workspaceId}/tables/{tableId}/columns

3️⃣ Path Parameters

Parameter	Type	Required	Description
workspaceId	UUID	✅ Yes	Workspace identifier
tableId	UUID	✅ Yes	Table identifier where the lookup column 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

{
  "columns": [
    {
      "description": "string",
      "uiMetadata": {
        "title": "string"
      },
      "uiDataType": "LOOKUP",
      "colOptions": {
        "linkColumnId": "uuid",
        "lookupColumnId": "uuid"
      },
      "name": "string"
    }
  ]
}

7️⃣ Field Descriptions

Field	Type	Required	Description
columns	array	✅ Yes	Array of lookup column definitions to create
columns[].description	string	❌ No	Optional description of the column
columns[].uiMetadata.title	string	✅ Yes	Display name shown in the UI
columns[].uiDataType	string	✅ Yes	Must be `LOOKUP`
columns[].colOptions.linkColumnId	UUID	✅ Yes	ID of the existing LINK column connecting to the source table
columns[].colOptions.lookupColumnId	UUID	✅ Yes	ID of the column in the linked table whose values should be looked up
columns[].name	string	✅ Yes	Internal column name — must be unique within the table

8️⃣ Example Request

curl -X POST https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{tableId}/columns \
-H "Authorization: Bearer <token>" \
-H "Content-Type: application/json" \
-d '{
  "columns": [
    {
      "description": "",
      "uiMetadata": {
        "title": "Name (from People)"
      },
      "uiDataType": "LOOKUP",
      "colOptions": {
        "linkColumnId": "21224153-2f85-4b24-a306-4cfbc7e73f70",
        "lookupColumnId": "9b5e408d-69bb-42ca-8fa4-ba00f7994356"
      },
      "name": "name_1774285509977"
    }
  ]
}'

9️⃣ Behavior Summary

Creates one or more LOOKUP columns in the target table.
Supports:
• Batch creation of multiple lookup columns in one request
• linkColumnId — references the existing LINK column in the current table
• lookupColumnId — references the column from the linked table to display
• Column name must be unique within the table

POST

noCo

api

workspaces

{workspaceId}

tables

{tableId}

columns

Add Lookup Column

curl --request POST \
  --url https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{tableId}/columns \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "columns": [
    {
      "description": "",
      "uiMetadata": {
        "title": "lookup column"
      },
      "uiDataType": "LOOKUP",
      "colOptions": {
        "linkColumnId": "21224153-2f85-4b24-a306-4cfbc7e73f70",
        "lookupColumnId": "9b5e408d-69bb-42ca-8fa4-ba00f7994356"
      },
      "name": "lookup_column"
    }
  ]
}
'

import requests

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

payload = { "columns": [
        {
            "description": "",
            "uiMetadata": { "title": "lookup column" },
            "uiDataType": "LOOKUP",
            "colOptions": {
                "linkColumnId": "21224153-2f85-4b24-a306-4cfbc7e73f70",
                "lookupColumnId": "9b5e408d-69bb-42ca-8fa4-ba00f7994356"
            },
            "name": "lookup_column"
        }
    ] }
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({
    columns: [
      {
        description: '',
        uiMetadata: {title: 'lookup column'},
        uiDataType: 'LOOKUP',
        colOptions: {
          linkColumnId: '21224153-2f85-4b24-a306-4cfbc7e73f70',
          lookupColumnId: '9b5e408d-69bb-42ca-8fa4-ba00f7994356'
        },
        name: 'lookup_column'
      }
    ]
  })
};

fetch('https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{tableId}/columns', 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/{tableId}/columns",
  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([
    'columns' => [
        [
                'description' => '',
                'uiMetadata' => [
                                'title' => 'lookup column'
                ],
                'uiDataType' => 'LOOKUP',
                'colOptions' => [
                                'linkColumnId' => '21224153-2f85-4b24-a306-4cfbc7e73f70',
                                'lookupColumnId' => '9b5e408d-69bb-42ca-8fa4-ba00f7994356'
                ],
                'name' => 'lookup_column'
        ]
    ]
  ]),
  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/{tableId}/columns"

	payload := strings.NewReader("{\n  \"columns\": [\n    {\n      \"description\": \"\",\n      \"uiMetadata\": {\n        \"title\": \"lookup column\"\n      },\n      \"uiDataType\": \"LOOKUP\",\n      \"colOptions\": {\n        \"linkColumnId\": \"21224153-2f85-4b24-a306-4cfbc7e73f70\",\n        \"lookupColumnId\": \"9b5e408d-69bb-42ca-8fa4-ba00f7994356\"\n      },\n      \"name\": \"lookup_column\"\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/{tableId}/columns")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"columns\": [\n    {\n      \"description\": \"\",\n      \"uiMetadata\": {\n        \"title\": \"lookup column\"\n      },\n      \"uiDataType\": \"LOOKUP\",\n      \"colOptions\": {\n        \"linkColumnId\": \"21224153-2f85-4b24-a306-4cfbc7e73f70\",\n        \"lookupColumnId\": \"9b5e408d-69bb-42ca-8fa4-ba00f7994356\"\n      },\n      \"name\": \"lookup_column\"\n    }\n  ]\n}")
  .asString();

require 'uri'
require 'net/http'

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

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  \"columns\": [\n    {\n      \"description\": \"\",\n      \"uiMetadata\": {\n        \"title\": \"lookup column\"\n      },\n      \"uiDataType\": \"LOOKUP\",\n      \"colOptions\": {\n        \"linkColumnId\": \"21224153-2f85-4b24-a306-4cfbc7e73f70\",\n        \"lookupColumnId\": \"9b5e408d-69bb-42ca-8fa4-ba00f7994356\"\n      },\n      \"name\": \"lookup_column\"\n    }\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

tableId

string<uuid>

required

Table identifier where the lookup column will be created

Body

application/json

columns

object[]

required

Show child attributes

Response

200

Lookup column(s) created successfully

Create Link Column with Auto Join Condition Add Row with Linked Records

Getting Started

Workspaces

Sign up

AI Extraction

WorkBook

Links & Joins

Knowledge Graph

Enterprise Search

Add Lookup Column

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