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_bodyWorkBook
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
/
v2
/
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_bodyAuthorizations
This API uses OAuth 2.0 with the authorization code grant flow.
Body
application/json
Response
200
Column Updated successfully