Add Row
curl --request POST \
--url https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"cellValues": {
"first_name": "John",
"years_of_experience": 5,
"is_active": true,
"start_date": "2024-02-18T05:00:00+00:00"
}
}
'import requests
url = "https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows"
payload = { "cellValues": {
"first_name": "John",
"years_of_experience": 5,
"is_active": True,
"start_date": "2024-02-18T05:00:00+00:00"
} }
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({
cellValues: {
first_name: 'John',
years_of_experience: 5,
is_active: true,
start_date: '2024-02-18T05:00:00+00:00'
}
})
};
fetch('https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows', 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}/rows",
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([
'cellValues' => [
'first_name' => 'John',
'years_of_experience' => 5,
'is_active' => true,
'start_date' => '2024-02-18T05:00:00+00:00'
]
]),
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}/rows"
payload := strings.NewReader("{\n \"cellValues\": {\n \"first_name\": \"John\",\n \"years_of_experience\": 5,\n \"is_active\": true,\n \"start_date\": \"2024-02-18T05:00:00+00:00\"\n }\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/{workbookId}/rows")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"cellValues\": {\n \"first_name\": \"John\",\n \"years_of_experience\": 5,\n \"is_active\": true,\n \"start_date\": \"2024-02-18T05:00:00+00:00\"\n }\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows")
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 \"cellValues\": {\n \"first_name\": \"John\",\n \"years_of_experience\": 5,\n \"is_active\": true,\n \"start_date\": \"2024-02-18T05:00:00+00:00\"\n }\n}"
response = http.request(request)
puts response.read_bodyWorkBook
Add Row
1️⃣ Overview
Purpose:
Adds a new row to a workbook within a workspace.
2️⃣ Endpoint
POST /noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows
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 |
6️⃣ Request Body Schema
{
"cellValues": {}
}
7️⃣ Field Descriptions
Row Data
| Field | Type | Required | Description |
|---|---|---|---|
| cellValues | object | ✅ Yes | Key-value mapping of workbook column internal names to their values |
8️⃣ Example Request
curl -X POST https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows \
-H "Authorization: Bearer <token>" \
-H "Content-Type: application/json" \
-d '{
"cellValues": {
"first_name": "John",
"years_of_experience": 5,
"is_active": true,
"start_date": "2024-02-18T05:00:00+00:00"
}
}'
9️⃣ Behavior Summary
Inserts a new record into the workbook.
Supports:
• Dynamic column-value mapping using cellValues object
• Internal column names must be used as keys
• Data validation is performed before insertion
• Date values must follow YYYY-MM-DD format
POST
/
noCo
/
api
/
v2
/
workspaces
/
{workspaceId}
/
tables
/
{workbookId}
/
rows
Add Row
curl --request POST \
--url https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"cellValues": {
"first_name": "John",
"years_of_experience": 5,
"is_active": true,
"start_date": "2024-02-18T05:00:00+00:00"
}
}
'import requests
url = "https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows"
payload = { "cellValues": {
"first_name": "John",
"years_of_experience": 5,
"is_active": True,
"start_date": "2024-02-18T05:00:00+00:00"
} }
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({
cellValues: {
first_name: 'John',
years_of_experience: 5,
is_active: true,
start_date: '2024-02-18T05:00:00+00:00'
}
})
};
fetch('https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows', 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}/rows",
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([
'cellValues' => [
'first_name' => 'John',
'years_of_experience' => 5,
'is_active' => true,
'start_date' => '2024-02-18T05:00:00+00:00'
]
]),
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}/rows"
payload := strings.NewReader("{\n \"cellValues\": {\n \"first_name\": \"John\",\n \"years_of_experience\": 5,\n \"is_active\": true,\n \"start_date\": \"2024-02-18T05:00:00+00:00\"\n }\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/{workbookId}/rows")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"cellValues\": {\n \"first_name\": \"John\",\n \"years_of_experience\": 5,\n \"is_active\": true,\n \"start_date\": \"2024-02-18T05:00:00+00:00\"\n }\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows")
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 \"cellValues\": {\n \"first_name\": \"John\",\n \"years_of_experience\": 5,\n \"is_active\": true,\n \"start_date\": \"2024-02-18T05:00:00+00:00\"\n }\n}"
response = http.request(request)
puts response.read_body