Create Link Column with Auto Join Condition

curl --request POST \
  --url https://be.datagol.ai/noCo/api/v2/workspaces/{workspace_id}/tables/{table_id}/column \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "uiDataType": "LINK",
  "colOptions": {
    "associateTableId": "6d85b345-b626-4b87-b664-66237d7333e8",
    "associateWorkspaceId": "b3e1a902-1234-4abc-9def-7f8a90bc1234",
    "whereClause": "table_1e67d485.\"course_taken\" = table_c8be6d9c.\"status\""
  },
  "uiMetadata": {
    "title": "product link column",
    "autoJoinConfig": {
      "joinConditions": [
        {
          "id": "condition-1774312716137",
          "currentTableColumn": "course_taken",
          "linkedTableColumn": "status",
          "operator": "EQUALS"
        }
      ],
      "isSwapped": false
    }
  },
  "formula": "table_1e67d485.\"course_taken\" = table_c8be6d9c.\"status\"",
  "name": "product_link_column"
}
'

import requests

url = "https://be.datagol.ai/noCo/api/v2/workspaces/{workspace_id}/tables/{table_id}/column"

payload = {
    "uiDataType": "LINK",
    "colOptions": {
        "associateTableId": "6d85b345-b626-4b87-b664-66237d7333e8",
        "associateWorkspaceId": "b3e1a902-1234-4abc-9def-7f8a90bc1234",
        "whereClause": "table_1e67d485.\"course_taken\" = table_c8be6d9c.\"status\""
    },
    "uiMetadata": {
        "title": "product link column",
        "autoJoinConfig": {
            "joinConditions": [
                {
                    "id": "condition-1774312716137",
                    "currentTableColumn": "course_taken",
                    "linkedTableColumn": "status",
                    "operator": "EQUALS"
                }
            ],
            "isSwapped": False
        }
    },
    "formula": "table_1e67d485.\"course_taken\" = table_c8be6d9c.\"status\"",
    "name": "product_link_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({
    uiDataType: 'LINK',
    colOptions: {
      associateTableId: '6d85b345-b626-4b87-b664-66237d7333e8',
      associateWorkspaceId: 'b3e1a902-1234-4abc-9def-7f8a90bc1234',
      whereClause: 'table_1e67d485."course_taken" = table_c8be6d9c."status"'
    },
    uiMetadata: {
      title: 'product link column',
      autoJoinConfig: {
        joinConditions: [
          {
            id: 'condition-1774312716137',
            currentTableColumn: 'course_taken',
            linkedTableColumn: 'status',
            operator: 'EQUALS'
          }
        ],
        isSwapped: false
      }
    },
    formula: 'table_1e67d485."course_taken" = table_c8be6d9c."status"',
    name: 'product_link_column'
  })
};

fetch('https://be.datagol.ai/noCo/api/v2/workspaces/{workspace_id}/tables/{table_id}/column', 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/{workspace_id}/tables/{table_id}/column",
  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([
    'uiDataType' => 'LINK',
    'colOptions' => [
        'associateTableId' => '6d85b345-b626-4b87-b664-66237d7333e8',
        'associateWorkspaceId' => 'b3e1a902-1234-4abc-9def-7f8a90bc1234',
        'whereClause' => 'table_1e67d485."course_taken" = table_c8be6d9c."status"'
    ],
    'uiMetadata' => [
        'title' => 'product link column',
        'autoJoinConfig' => [
                'joinConditions' => [
                                [
                                                                'id' => 'condition-1774312716137',
                                                                'currentTableColumn' => 'course_taken',
                                                                'linkedTableColumn' => 'status',
                                                                'operator' => 'EQUALS'
                                ]
                ],
                'isSwapped' => false
        ]
    ],
    'formula' => 'table_1e67d485."course_taken" = table_c8be6d9c."status"',
    'name' => 'product_link_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/{workspace_id}/tables/{table_id}/column"

	payload := strings.NewReader("{\n  \"uiDataType\": \"LINK\",\n  \"colOptions\": {\n    \"associateTableId\": \"6d85b345-b626-4b87-b664-66237d7333e8\",\n    \"associateWorkspaceId\": \"b3e1a902-1234-4abc-9def-7f8a90bc1234\",\n    \"whereClause\": \"table_1e67d485.\\\"course_taken\\\" = table_c8be6d9c.\\\"status\\\"\"\n  },\n  \"uiMetadata\": {\n    \"title\": \"product link column\",\n    \"autoJoinConfig\": {\n      \"joinConditions\": [\n        {\n          \"id\": \"condition-1774312716137\",\n          \"currentTableColumn\": \"course_taken\",\n          \"linkedTableColumn\": \"status\",\n          \"operator\": \"EQUALS\"\n        }\n      ],\n      \"isSwapped\": false\n    }\n  },\n  \"formula\": \"table_1e67d485.\\\"course_taken\\\" = table_c8be6d9c.\\\"status\\\"\",\n  \"name\": \"product_link_column\"\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/{workspace_id}/tables/{table_id}/column")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"uiDataType\": \"LINK\",\n  \"colOptions\": {\n    \"associateTableId\": \"6d85b345-b626-4b87-b664-66237d7333e8\",\n    \"associateWorkspaceId\": \"b3e1a902-1234-4abc-9def-7f8a90bc1234\",\n    \"whereClause\": \"table_1e67d485.\\\"course_taken\\\" = table_c8be6d9c.\\\"status\\\"\"\n  },\n  \"uiMetadata\": {\n    \"title\": \"product link column\",\n    \"autoJoinConfig\": {\n      \"joinConditions\": [\n        {\n          \"id\": \"condition-1774312716137\",\n          \"currentTableColumn\": \"course_taken\",\n          \"linkedTableColumn\": \"status\",\n          \"operator\": \"EQUALS\"\n        }\n      ],\n      \"isSwapped\": false\n    }\n  },\n  \"formula\": \"table_1e67d485.\\\"course_taken\\\" = table_c8be6d9c.\\\"status\\\"\",\n  \"name\": \"product_link_column\"\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://be.datagol.ai/noCo/api/v2/workspaces/{workspace_id}/tables/{table_id}/column")

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  \"uiDataType\": \"LINK\",\n  \"colOptions\": {\n    \"associateTableId\": \"6d85b345-b626-4b87-b664-66237d7333e8\",\n    \"associateWorkspaceId\": \"b3e1a902-1234-4abc-9def-7f8a90bc1234\",\n    \"whereClause\": \"table_1e67d485.\\\"course_taken\\\" = table_c8be6d9c.\\\"status\\\"\"\n  },\n  \"uiMetadata\": {\n    \"title\": \"product link column\",\n    \"autoJoinConfig\": {\n      \"joinConditions\": [\n        {\n          \"id\": \"condition-1774312716137\",\n          \"currentTableColumn\": \"course_taken\",\n          \"linkedTableColumn\": \"status\",\n          \"operator\": \"EQUALS\"\n        }\n      ],\n      \"isSwapped\": false\n    }\n  },\n  \"formula\": \"table_1e67d485.\\\"course_taken\\\" = table_c8be6d9c.\\\"status\\\"\",\n  \"name\": \"product_link_column\"\n}"

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

{
  "id": "efdbce09-6581-4811-aa67-14344e7444b7",
  "name": "product link column",
  "uiDataType": "LINK",
  "formula": "table_1e67d485.\"course_taken\" = table_c8be6d9c.\"status\"",
  "backendDataType": "VARCHAR(255)",
  "workspaceId": "16231f3f-8208-4c51-a460-87d17244344f",
  "colOptions": {
    "id": "e19ab19c-3a38-4d28-9eff-767019524186",
    "relationType": "MANY_TO_MANY",
    "columnId": "efdbce09-6581-4811-aa67-14344e7444b7",
    "associatedColumnId": "9422e52d-9886-431e-946f-8ed5a8838dac",
    "tableId": "9c8a448d-7884-4158-bfca-202bc95b0515",
    "associateTableId": "6d85b345-b626-4b87-b664-66237d7333e8",
    "associateWorkspaceId": "b3e1a902-1234-4abc-9def-7f8a90bc1234",
    "childColumnId": "75272cd2-63c4-4d4c-b2eb-20a864834a2a",
    "parentColumnId": "f830fd3f-8624-4ae5-959f-36f1756d828a",
    "whereClause": "table_1e67d485.\"course_taken\" = table_c8be6d9c.\"status\"",
    "isItSource": true
  },
  "uiMetadata": {
    "title": "product_link_column",
    "autoJoinConfig": {
      "joinConditions": [
        {
          "id": "condition-1774312716137",
          "currentTableColumn": "course_taken",
          "linkedTableColumn": "status",
          "operator": "EQUALS"
        }
      ],
      "isSwapped": false
    }
  },
  "tableId": "9c8a448d-7884-4158-bfca-202bc95b0515"
}

Links & Joins

Create Link Column with Auto Join Condition

1️⃣ Overview

Purpose: Creates a new LINK type column with an automatic join condition between the parent and child tables. Unlike a manual link, this allows defining column-level join conditions that filter how records are linked.

This endpoint supports:

Defining join conditions between columns of two tables
Using operators like EQUALS for condition matching
Passing a raw SQL-style whereClause and formula for backend filtering

2️⃣ Endpoint

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

3️⃣ Path Parameters

Parameter	Type	Required	Description
workspaceId	UUID	✅ Yes	Workspace identifier
tableId	UUID	✅ Yes	Source (parent) table 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

{
  "uiDataType": "LINK",
  "colOptions": {
    "associateTableId": "uuid",
    "associateWorkspaceId": "uuid",
    "whereClause": "string"
  },
  "uiMetadata": {
    "title": "string",
    "autoJoinConfig": {
      "joinConditions": [
        {
          "id": "string",
          "currentTableColumn": "string",
          "linkedTableColumn": "string",
          "operator": "EQUALS"
        }
      ],
      "isSwapped": false
    }
  },
   "formula": "string",
  "name": "string"
}

7️⃣ Field Descriptions

Field	Type	Required	Description
uiDataType	string	✅ Yes	Must be `LINK`
colOptions.associateTableId	UUID	✅ Yes	The child or linked table ID
colOptions.associateWorkspaceId	UUID	✅ Yes	The workspace ID of the child (associated) table
colOptions.whereClause	string	✅ Yes	Raw SQL-style condition used for backend join filtering
uiMetadata.title	string	✅ Yes	Display name shown in the UI
uiMetadata.autoJoinConfig	object	✅ Yes	Configuration object defining the auto join conditions
uiMetadata.autoJoinConfig.joinConditions	array	✅ Yes	List of join condition objects
uiMetadata.autoJoinConfig.joinConditions[].id	string	✅ Yes	Unique identifier for the condition (client-generated)
uiMetadata.autoJoinConfig.joinConditions[].currentTableColumn	string	✅ Yes	Column name from the current (source) table to join on
uiMetadata.autoJoinConfig.joinConditions[].linkedTableColumn	string	✅ Yes	Column name from the linked (destination) table to join on
uiMetadata.autoJoinConfig.joinConditions[].operator	string	✅ Yes	Join operator — currently supports `EQUALS`
uiMetadata.autoJoinConfig.isSwapped	boolean	❌ No	Whether the join direction is swapped. Defaults to `false`
formula	string	✅ Yes	Raw SQL-style formula matching the whereClause, used for backend processing
name	string	✅ Yes	Internal column name — must be unique within the table

POST

noCo

api

workspaces

{workspace_id}

tables

{table_id}

column

Create Link Column with Auto Join Condition

curl --request POST \
  --url https://be.datagol.ai/noCo/api/v2/workspaces/{workspace_id}/tables/{table_id}/column \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "uiDataType": "LINK",
  "colOptions": {
    "associateTableId": "6d85b345-b626-4b87-b664-66237d7333e8",
    "associateWorkspaceId": "b3e1a902-1234-4abc-9def-7f8a90bc1234",
    "whereClause": "table_1e67d485.\"course_taken\" = table_c8be6d9c.\"status\""
  },
  "uiMetadata": {
    "title": "product link column",
    "autoJoinConfig": {
      "joinConditions": [
        {
          "id": "condition-1774312716137",
          "currentTableColumn": "course_taken",
          "linkedTableColumn": "status",
          "operator": "EQUALS"
        }
      ],
      "isSwapped": false
    }
  },
  "formula": "table_1e67d485.\"course_taken\" = table_c8be6d9c.\"status\"",
  "name": "product_link_column"
}
'

import requests

url = "https://be.datagol.ai/noCo/api/v2/workspaces/{workspace_id}/tables/{table_id}/column"

payload = {
    "uiDataType": "LINK",
    "colOptions": {
        "associateTableId": "6d85b345-b626-4b87-b664-66237d7333e8",
        "associateWorkspaceId": "b3e1a902-1234-4abc-9def-7f8a90bc1234",
        "whereClause": "table_1e67d485.\"course_taken\" = table_c8be6d9c.\"status\""
    },
    "uiMetadata": {
        "title": "product link column",
        "autoJoinConfig": {
            "joinConditions": [
                {
                    "id": "condition-1774312716137",
                    "currentTableColumn": "course_taken",
                    "linkedTableColumn": "status",
                    "operator": "EQUALS"
                }
            ],
            "isSwapped": False
        }
    },
    "formula": "table_1e67d485.\"course_taken\" = table_c8be6d9c.\"status\"",
    "name": "product_link_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({
    uiDataType: 'LINK',
    colOptions: {
      associateTableId: '6d85b345-b626-4b87-b664-66237d7333e8',
      associateWorkspaceId: 'b3e1a902-1234-4abc-9def-7f8a90bc1234',
      whereClause: 'table_1e67d485."course_taken" = table_c8be6d9c."status"'
    },
    uiMetadata: {
      title: 'product link column',
      autoJoinConfig: {
        joinConditions: [
          {
            id: 'condition-1774312716137',
            currentTableColumn: 'course_taken',
            linkedTableColumn: 'status',
            operator: 'EQUALS'
          }
        ],
        isSwapped: false
      }
    },
    formula: 'table_1e67d485."course_taken" = table_c8be6d9c."status"',
    name: 'product_link_column'
  })
};

fetch('https://be.datagol.ai/noCo/api/v2/workspaces/{workspace_id}/tables/{table_id}/column', 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/{workspace_id}/tables/{table_id}/column",
  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([
    'uiDataType' => 'LINK',
    'colOptions' => [
        'associateTableId' => '6d85b345-b626-4b87-b664-66237d7333e8',
        'associateWorkspaceId' => 'b3e1a902-1234-4abc-9def-7f8a90bc1234',
        'whereClause' => 'table_1e67d485."course_taken" = table_c8be6d9c."status"'
    ],
    'uiMetadata' => [
        'title' => 'product link column',
        'autoJoinConfig' => [
                'joinConditions' => [
                                [
                                                                'id' => 'condition-1774312716137',
                                                                'currentTableColumn' => 'course_taken',
                                                                'linkedTableColumn' => 'status',
                                                                'operator' => 'EQUALS'
                                ]
                ],
                'isSwapped' => false
        ]
    ],
    'formula' => 'table_1e67d485."course_taken" = table_c8be6d9c."status"',
    'name' => 'product_link_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/{workspace_id}/tables/{table_id}/column"

	payload := strings.NewReader("{\n  \"uiDataType\": \"LINK\",\n  \"colOptions\": {\n    \"associateTableId\": \"6d85b345-b626-4b87-b664-66237d7333e8\",\n    \"associateWorkspaceId\": \"b3e1a902-1234-4abc-9def-7f8a90bc1234\",\n    \"whereClause\": \"table_1e67d485.\\\"course_taken\\\" = table_c8be6d9c.\\\"status\\\"\"\n  },\n  \"uiMetadata\": {\n    \"title\": \"product link column\",\n    \"autoJoinConfig\": {\n      \"joinConditions\": [\n        {\n          \"id\": \"condition-1774312716137\",\n          \"currentTableColumn\": \"course_taken\",\n          \"linkedTableColumn\": \"status\",\n          \"operator\": \"EQUALS\"\n        }\n      ],\n      \"isSwapped\": false\n    }\n  },\n  \"formula\": \"table_1e67d485.\\\"course_taken\\\" = table_c8be6d9c.\\\"status\\\"\",\n  \"name\": \"product_link_column\"\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/{workspace_id}/tables/{table_id}/column")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"uiDataType\": \"LINK\",\n  \"colOptions\": {\n    \"associateTableId\": \"6d85b345-b626-4b87-b664-66237d7333e8\",\n    \"associateWorkspaceId\": \"b3e1a902-1234-4abc-9def-7f8a90bc1234\",\n    \"whereClause\": \"table_1e67d485.\\\"course_taken\\\" = table_c8be6d9c.\\\"status\\\"\"\n  },\n  \"uiMetadata\": {\n    \"title\": \"product link column\",\n    \"autoJoinConfig\": {\n      \"joinConditions\": [\n        {\n          \"id\": \"condition-1774312716137\",\n          \"currentTableColumn\": \"course_taken\",\n          \"linkedTableColumn\": \"status\",\n          \"operator\": \"EQUALS\"\n        }\n      ],\n      \"isSwapped\": false\n    }\n  },\n  \"formula\": \"table_1e67d485.\\\"course_taken\\\" = table_c8be6d9c.\\\"status\\\"\",\n  \"name\": \"product_link_column\"\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://be.datagol.ai/noCo/api/v2/workspaces/{workspace_id}/tables/{table_id}/column")

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  \"uiDataType\": \"LINK\",\n  \"colOptions\": {\n    \"associateTableId\": \"6d85b345-b626-4b87-b664-66237d7333e8\",\n    \"associateWorkspaceId\": \"b3e1a902-1234-4abc-9def-7f8a90bc1234\",\n    \"whereClause\": \"table_1e67d485.\\\"course_taken\\\" = table_c8be6d9c.\\\"status\\\"\"\n  },\n  \"uiMetadata\": {\n    \"title\": \"product link column\",\n    \"autoJoinConfig\": {\n      \"joinConditions\": [\n        {\n          \"id\": \"condition-1774312716137\",\n          \"currentTableColumn\": \"course_taken\",\n          \"linkedTableColumn\": \"status\",\n          \"operator\": \"EQUALS\"\n        }\n      ],\n      \"isSwapped\": false\n    }\n  },\n  \"formula\": \"table_1e67d485.\\\"course_taken\\\" = table_c8be6d9c.\\\"status\\\"\",\n  \"name\": \"product_link_column\"\n}"

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

{
  "id": "efdbce09-6581-4811-aa67-14344e7444b7",
  "name": "product link column",
  "uiDataType": "LINK",
  "formula": "table_1e67d485.\"course_taken\" = table_c8be6d9c.\"status\"",
  "backendDataType": "VARCHAR(255)",
  "workspaceId": "16231f3f-8208-4c51-a460-87d17244344f",
  "colOptions": {
    "id": "e19ab19c-3a38-4d28-9eff-767019524186",
    "relationType": "MANY_TO_MANY",
    "columnId": "efdbce09-6581-4811-aa67-14344e7444b7",
    "associatedColumnId": "9422e52d-9886-431e-946f-8ed5a8838dac",
    "tableId": "9c8a448d-7884-4158-bfca-202bc95b0515",
    "associateTableId": "6d85b345-b626-4b87-b664-66237d7333e8",
    "associateWorkspaceId": "b3e1a902-1234-4abc-9def-7f8a90bc1234",
    "childColumnId": "75272cd2-63c4-4d4c-b2eb-20a864834a2a",
    "parentColumnId": "f830fd3f-8624-4ae5-959f-36f1756d828a",
    "whereClause": "table_1e67d485.\"course_taken\" = table_c8be6d9c.\"status\"",
    "isItSource": true
  },
  "uiMetadata": {
    "title": "product_link_column",
    "autoJoinConfig": {
      "joinConditions": [
        {
          "id": "condition-1774312716137",
          "currentTableColumn": "course_taken",
          "linkedTableColumn": "status",
          "operator": "EQUALS"
        }
      ],
      "isSwapped": false
    }
  },
  "tableId": "9c8a448d-7884-4158-bfca-202bc95b0515"
}

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

Source (parent) table identifier

Body

application/json

uiDataType

enum<string>

required

Available options:

LINK

colOptions

object

required

Show child attributes

uiMetadata

object

required

Show child attributes

formula

string

required

Raw SQL-style formula matching the whereClause, used for backend processing

name

string

required

Internal column name — must be unique within the table

Response

200 - application/json

Link column with auto join condition created successfully

string<uuid>

Unique identifier of the created link column

name

string

Internal column name, unique within the table

uiDataType

string

Always returns LINK for link columns

formula

string

Raw SQL-style formula used for the join condition

backendDataType

string

Underlying database data type assigned to the column

workspaceId

string<uuid>

Workspace this column belongs to

colOptions

object

Show child attributes

uiMetadata

object

Show child attributes

tableId

string<uuid>

Table ID where this column resides

Create Link Column (Manual-Link)Add Lookup Column

Getting Started

Workspaces

Sign up

AI Extraction

WorkBook

Links & Joins

Knowledge Graph

Enterprise Search

Create Link Column with Auto Join Condition

1️⃣ Overview

2️⃣ Endpoint

3️⃣ Path Parameters

4️⃣ Authentication

5️⃣ Request Headers

6️⃣ Request Body Schema

7️⃣ Field Descriptions

Authorizations

Path Parameters

Body

Response