Create Link Column (Manual-Link)

1️⃣ Overview

Purpose: Creates a new LINK type column in a table, establishing a bidirectional relationship between a parent table and a child/associated table.

This endpoint supports:

• Creating HAS_MANY, ONE_TO_ONE, and MANY_TO_MANY relation types
• Automatically creating a reciprocal link column in the associated table

⚠️ Note: Links are bidirectional. When a link is created from the parent with relation type HAS_MANY, a corresponding column with relation type BELONGS_TO is automatically created in the child table.

2️⃣ Endpoint

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

3️⃣ Path Parameters

4️⃣ Authentication

Requires Bearer JWT Token

Authorization: Bearer <token>

5️⃣ Request Headers

6️⃣ Request Body Schema

{
  "uiDataType": "LINK",
  "colOptions": {
    "relationType": "HAS_MANY",
    "associateTableId": "uuid",
    "associateWorkspaceId": "uuid"
  },
  "uiMetadata": {
    "title": "string"
  },
  "settings": {},
  "name": "string"
}

7️⃣ Field Descriptions

8️⃣ Example Request

curl -X POST https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{tableId}/column \
-H "Authorization: Bearer <token>" \
-H "Content-Type: application/json" \
-d '{
  "uiDataType": "LINK",
  "colOptions": {
    "relationType": "HAS_MANY",
    "associateTableId": "6a175502-6458-4314-b4c5-3c2f29626dea",
    "associateWorkspaceId": "b3e1a902-1234-4abc-9def-7f8a90bc1234"
  },
  "uiMetadata": {
    "title": "people"
  },
  "name": "people"
}'

9️⃣ Behavior Summary

Creates a LINK column in the source table.
Supports:
• HAS_MANY, ONE_TO_ONE, and MANY_TO_MANY relation types
• Bidirectional — a BELONGS_TO column is auto-created in the child table
• Column name must be unique within the table
• Returns the full column object including colOptions with resolved IDs