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_bodyLinks & 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
/
v2
/
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_bodyAuthorizations
This API uses OAuth 2.0 with the authorization code grant flow.
Path Parameters
Workspace identifier
Table identifier where the lookup column will be created
Body
application/json
Show child attributes
Show child attributes
Response
200
Lookup column(s) created successfully