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