Update Column

curl --request PUT \
  --url https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/columns/{columnId} \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "id": "6d9ae325-6fcd-4bd6-a732-b59e424fc095",
  "name": "question",
  "uiDataType": "SINGLE_LINE_TEXT",
  "colOptions": {},
  "uiMetadata": {
    "title": "Question",
    "precision": null
  }
}
'

import requests

url = "https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/columns/{columnId}"

payload = {
    "id": "6d9ae325-6fcd-4bd6-a732-b59e424fc095",
    "name": "question",
    "uiDataType": "SINGLE_LINE_TEXT",
    "colOptions": {},
    "uiMetadata": {
        "title": "Question",
        "precision": None
    }
}
headers = {
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json"
}

response = requests.put(url, json=payload, headers=headers)

print(response.text)

const options = {
  method: 'PUT',
  headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
  body: JSON.stringify({
    id: '6d9ae325-6fcd-4bd6-a732-b59e424fc095',
    name: 'question',
    uiDataType: 'SINGLE_LINE_TEXT',
    colOptions: {},
    uiMetadata: {title: 'Question', precision: null}
  })
};

fetch('https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/columns/{columnId}', 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/{workbookId}/columns/{columnId}",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "PUT",
  CURLOPT_POSTFIELDS => json_encode([
    'id' => '6d9ae325-6fcd-4bd6-a732-b59e424fc095',
    'name' => 'question',
    'uiDataType' => 'SINGLE_LINE_TEXT',
    'colOptions' => [
        
    ],
    'uiMetadata' => [
        'title' => 'Question',
        'precision' => null
    ]
  ]),
  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/{workbookId}/columns/{columnId}"

	payload := strings.NewReader("{\n  \"id\": \"6d9ae325-6fcd-4bd6-a732-b59e424fc095\",\n  \"name\": \"question\",\n  \"uiDataType\": \"SINGLE_LINE_TEXT\",\n  \"colOptions\": {},\n  \"uiMetadata\": {\n    \"title\": \"Question\",\n    \"precision\": null\n  }\n}")

	req, _ := http.NewRequest("PUT", 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.put("https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/columns/{columnId}")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"id\": \"6d9ae325-6fcd-4bd6-a732-b59e424fc095\",\n  \"name\": \"question\",\n  \"uiDataType\": \"SINGLE_LINE_TEXT\",\n  \"colOptions\": {},\n  \"uiMetadata\": {\n    \"title\": \"Question\",\n    \"precision\": null\n  }\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/columns/{columnId}")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Put.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"id\": \"6d9ae325-6fcd-4bd6-a732-b59e424fc095\",\n  \"name\": \"question\",\n  \"uiDataType\": \"SINGLE_LINE_TEXT\",\n  \"colOptions\": {},\n  \"uiMetadata\": {\n    \"title\": \"Question\",\n    \"precision\": null\n  }\n}"

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

WorkBook

Update Column

1️⃣ Overview

Purpose:
Updates an existing column’s metadata and configuration within a specified table in a workspace.

This endpoint supports:

Updating column display name
Changing UI data type
Updating UI metadata (title, precision, etc.)
Modifying column options

2️⃣ Endpoint

PUT /noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/columns/{columnId}

3️⃣ Path Parameters

Parameter	Type	Required	Description
workspaceId	UUID	✅ Yes	Workspace identifier
workbookId	UUID	✅ Yes	Table identifier
columnId	UUID	✅ Yes	Column 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

{
  "id": "uuid",
  "name": "string",
  "uiDataType": "string",
  "colOptions": {},
  "uiMetadata": {
    "title": "string",
    "precision": null
  }
}

7️⃣ Field Descriptions

Column Configuration

Field	Type	Required	Description
id	UUID	✅ Yes	Unique identifier of the column to update
name	string	✅ Yes	Internal column name
uiDataType	string	✅ Yes	Column type (e.g., SINGLE_LINE_TEXT, NUMBER, DATE)
uiMetadata	object	✅ Yes	Metadata for UI display
uiMetadata.title	string	✅ Yes	Display name shown in the UI

8️⃣ Example Request

curl -X PUT https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/columns/{columnId} \
-H "Authorization: Bearer <token>" \
-H "Content-Type: application/json" \
-d '{
  "id": "6d9ae325-6fcd-4bd6-a732-b59e424fc095",
  "name": "question",
  "uiDataType": "SINGLE_LINE_TEXT",
  "colOptions": {},
  "uiMetadata": {
    "title": "Question",
    "precision": null
  }
}'

9️⃣ Behavior Summary

Updates an existing column's metadata and configuration.
Supports:
• Updating internal column name  
• Changing UI data type  
• Updating display title via uiMetadata  
• Setting precision for numeric columns  
• Passing additional column options via colOptions  
• Server-side validation before update

PUT

noCo

api

workspaces

{workspaceId}

tables

{workbookId}

columns

{columnId}

Update Column

curl --request PUT \
  --url https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/columns/{columnId} \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "id": "6d9ae325-6fcd-4bd6-a732-b59e424fc095",
  "name": "question",
  "uiDataType": "SINGLE_LINE_TEXT",
  "colOptions": {},
  "uiMetadata": {
    "title": "Question",
    "precision": null
  }
}
'

import requests

url = "https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/columns/{columnId}"

payload = {
    "id": "6d9ae325-6fcd-4bd6-a732-b59e424fc095",
    "name": "question",
    "uiDataType": "SINGLE_LINE_TEXT",
    "colOptions": {},
    "uiMetadata": {
        "title": "Question",
        "precision": None
    }
}
headers = {
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json"
}

response = requests.put(url, json=payload, headers=headers)

print(response.text)

const options = {
  method: 'PUT',
  headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
  body: JSON.stringify({
    id: '6d9ae325-6fcd-4bd6-a732-b59e424fc095',
    name: 'question',
    uiDataType: 'SINGLE_LINE_TEXT',
    colOptions: {},
    uiMetadata: {title: 'Question', precision: null}
  })
};

fetch('https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/columns/{columnId}', 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/{workbookId}/columns/{columnId}",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "PUT",
  CURLOPT_POSTFIELDS => json_encode([
    'id' => '6d9ae325-6fcd-4bd6-a732-b59e424fc095',
    'name' => 'question',
    'uiDataType' => 'SINGLE_LINE_TEXT',
    'colOptions' => [
        
    ],
    'uiMetadata' => [
        'title' => 'Question',
        'precision' => null
    ]
  ]),
  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/{workbookId}/columns/{columnId}"

	payload := strings.NewReader("{\n  \"id\": \"6d9ae325-6fcd-4bd6-a732-b59e424fc095\",\n  \"name\": \"question\",\n  \"uiDataType\": \"SINGLE_LINE_TEXT\",\n  \"colOptions\": {},\n  \"uiMetadata\": {\n    \"title\": \"Question\",\n    \"precision\": null\n  }\n}")

	req, _ := http.NewRequest("PUT", 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.put("https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/columns/{columnId}")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"id\": \"6d9ae325-6fcd-4bd6-a732-b59e424fc095\",\n  \"name\": \"question\",\n  \"uiDataType\": \"SINGLE_LINE_TEXT\",\n  \"colOptions\": {},\n  \"uiMetadata\": {\n    \"title\": \"Question\",\n    \"precision\": null\n  }\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/columns/{columnId}")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Put.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"id\": \"6d9ae325-6fcd-4bd6-a732-b59e424fc095\",\n  \"name\": \"question\",\n  \"uiDataType\": \"SINGLE_LINE_TEXT\",\n  \"colOptions\": {},\n  \"uiMetadata\": {\n    \"title\": \"Question\",\n    \"precision\": null\n  }\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

workbookId

string

required

columnId

string

required

Body

application/json

string

required

name

string

required

uiDataType

string

required

uiMetadata

object

required

Show child attributes

colOptions

object

Response

200

Column Updated successfully

Create Column Delete Column

Getting Started

Workspaces

Sign up

AI Extraction

WorkBook

Links & Joins

Knowledge Graph

Enterprise Search

Update 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