Create Column

curl --request POST \
  --url https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbook_Id}/column \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "uiDataType": "SINGLE_LINE_TEXT",
  "uiMetadata": {
    "title": "sample text"
  },
  "name": "sample_text"
}
'

import requests

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

payload = {
    "uiDataType": "SINGLE_LINE_TEXT",
    "uiMetadata": { "title": "sample text" },
    "name": "sample_text"
}
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: 'SINGLE_LINE_TEXT',
    uiMetadata: {title: 'sample text'},
    name: 'sample_text'
  })
};

fetch('https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbook_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/{workspaceId}/tables/{workbook_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' => 'SINGLE_LINE_TEXT',
    'uiMetadata' => [
        'title' => 'sample text'
    ],
    'name' => 'sample_text'
  ]),
  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/{workbook_Id}/column"

	payload := strings.NewReader("{\n  \"uiDataType\": \"SINGLE_LINE_TEXT\",\n  \"uiMetadata\": {\n    \"title\": \"sample text\"\n  },\n  \"name\": \"sample_text\"\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/{workbook_Id}/column")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"uiDataType\": \"SINGLE_LINE_TEXT\",\n  \"uiMetadata\": {\n    \"title\": \"sample text\"\n  },\n  \"name\": \"sample_text\"\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbook_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\": \"SINGLE_LINE_TEXT\",\n  \"uiMetadata\": {\n    \"title\": \"sample text\"\n  },\n  \"name\": \"sample_text\"\n}"

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

WorkBook

Create Column

1️⃣ Overview

Purpose:
Creates a new column inside a workbook.

Supports multiple column types such as:

Text column
Number column
Date column
Other supported UI data types

2️⃣ Endpoint

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

3️⃣ Path Parameters

Parameter	Type	Required	Description
workspaceId	UUID	✅ Yes	Workspace identifier
workbookId	UUID	✅ Yes	Workbook identifier

4️⃣ Authentication

Requires authentication using:

Authorization: Bearer <token>

5️⃣ Request Headers

Header	Required
Authorization	✅ Yes
Content-Type: application/json	✅ Yes

6️⃣ Request Body Schema

{
  "uiDataType": "string",
  "uiMetadata": {},
  "name": "string"
}

7️⃣ Field Descriptions

Column Configuration

Field	Type	Required	Description
uiDataType	string	✅ Yes	Column type (e.g., SINGLE_LINE_TEXT, NUMBER, DATE etc.)
uiMetadata	object	✅ Yes	Metadata for UI display (e.g., `{ "title": "My Column" }`)
name	string	✅ Yes	Internal column name (snake_case recommended)

8️⃣ Example Request

curl --location 'https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/column' \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '{
  "uiDataType": "SINGLE_LINE_TEXT",
  "uiMetadata": {
    "title": "sample text"
  },
  "description": "some description" "name": "sample_text"
}'

9️⃣ Behavior Summary

Creates a new workbook column.
Supports:
• Multiple UI data types (TEXT, NUMBER, DATE, etc.)  
• UI metadata configuration for rendering  
• Snake_case internal column naming  
• Server-side validation before creation

POST

noCo

api

workspaces

{workspaceId}

tables

{workbook_Id}

column

Create Column

curl --request POST \
  --url https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbook_Id}/column \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "uiDataType": "SINGLE_LINE_TEXT",
  "uiMetadata": {
    "title": "sample text"
  },
  "name": "sample_text"
}
'

import requests

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

payload = {
    "uiDataType": "SINGLE_LINE_TEXT",
    "uiMetadata": { "title": "sample text" },
    "name": "sample_text"
}
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: 'SINGLE_LINE_TEXT',
    uiMetadata: {title: 'sample text'},
    name: 'sample_text'
  })
};

fetch('https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbook_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/{workspaceId}/tables/{workbook_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' => 'SINGLE_LINE_TEXT',
    'uiMetadata' => [
        'title' => 'sample text'
    ],
    'name' => 'sample_text'
  ]),
  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/{workbook_Id}/column"

	payload := strings.NewReader("{\n  \"uiDataType\": \"SINGLE_LINE_TEXT\",\n  \"uiMetadata\": {\n    \"title\": \"sample text\"\n  },\n  \"name\": \"sample_text\"\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/{workbook_Id}/column")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"uiDataType\": \"SINGLE_LINE_TEXT\",\n  \"uiMetadata\": {\n    \"title\": \"sample text\"\n  },\n  \"name\": \"sample_text\"\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbook_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\": \"SINGLE_LINE_TEXT\",\n  \"uiMetadata\": {\n    \"title\": \"sample text\"\n  },\n  \"name\": \"sample_text\"\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

required

workbook_Id

string

required

Body

application/json

uiDataType

string

required

uiMetadata

object

required

Show child attributes

name

string

required

description

string

Response

200

Create Column

Generate AI Column Update Column

Getting Started

Workspaces

Sign up

AI Extraction

WorkBook

Links & Joins

Knowledge Graph

Enterprise Search

Create Column

1️⃣ Overview

2️⃣ Endpoint

3️⃣ Path Parameters

4️⃣ Authentication

5️⃣ Request Headers

6️⃣ Request Body Schema

7️⃣ Field Descriptions

Column Configuration

8️⃣ Example Request

9️⃣ Behavior Summary

Authorizations

Path Parameters

Body

Response