Add Rows (Bulk)
curl --request POST \
--url https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows/bulk \
--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"
}
},
{
"cellValues": {
"first_name": "Jane",
"years_of_experience": 3,
"is_active": false,
"start_date": "2023-06-01T05:00:00+00:00"
}
}
]
'import requests
url = "https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows/bulk"
payload = [{ "cellValues": {
"first_name": "John",
"years_of_experience": 5,
"is_active": True,
"start_date": "2024-02-18T05:00:00+00:00"
} }, { "cellValues": {
"first_name": "Jane",
"years_of_experience": 3,
"is_active": False,
"start_date": "2023-06-01T05: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'
}
},
{
cellValues: {
first_name: 'Jane',
years_of_experience: 3,
is_active: false,
start_date: '2023-06-01T05:00:00+00:00'
}
}
])
};
fetch('https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows/bulk', 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/bulk",
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'
]
],
[
'cellValues' => [
'first_name' => 'Jane',
'years_of_experience' => 3,
'is_active' => false,
'start_date' => '2023-06-01T05: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/bulk"
payload := strings.NewReader("[\n {\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 },\n {\n \"cellValues\": {\n \"first_name\": \"Jane\",\n \"years_of_experience\": 3,\n \"is_active\": false,\n \"start_date\": \"2023-06-01T05:00:00+00:00\"\n }\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/bulk")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("[\n {\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 },\n {\n \"cellValues\": {\n \"first_name\": \"Jane\",\n \"years_of_experience\": 3,\n \"is_active\": false,\n \"start_date\": \"2023-06-01T05:00:00+00:00\"\n }\n }\n]")
.asString();require 'uri'
require 'net/http'
url = URI("https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows/bulk")
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 {\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 },\n {\n \"cellValues\": {\n \"first_name\": \"Jane\",\n \"years_of_experience\": 3,\n \"is_active\": false,\n \"start_date\": \"2023-06-01T05:00:00+00:00\"\n }\n }\n]"
response = http.request(request)
puts response.read_bodyWorkBook
Add Rows (Bulk)
1️⃣ Overview
Purpose:
Adds multiple new rows to a workbook within a workspace in a single request.
2️⃣ Endpoint
POST /noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows/bulk
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
Bulk 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/bulk \
-H "Authorization: Bearer <token>" \
-H "Content-Type: application/json" \
--data-raw '[{"cellValues":{"first_name":"John","years_of_experience":5,"is_active":true,"start_date":"2024-02-18T05:00:00+00:00"}},{"cellValues":{"first_name":"Jane","years_of_experience":3,"is_active":false,"start_date":"2023-06-01T05:00:00+00:00"}}]'
9️⃣ Behavior Summary
Inserts multiple new records into the workbook in a single request.
Supports:
• Top-level array of row objects — not wrapped in a parent object
• Internal column names must be used as keys
• Data validation is performed on all rows before insertion
• Date values must follow YYYY-MM-DD format
• All rows are inserted atomically.
POST
/
noCo
/
api
/
v2
/
workspaces
/
{workspaceId}
/
tables
/
{workbookId}
/
rows
/
bulk
Add Rows (Bulk)
curl --request POST \
--url https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows/bulk \
--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"
}
},
{
"cellValues": {
"first_name": "Jane",
"years_of_experience": 3,
"is_active": false,
"start_date": "2023-06-01T05:00:00+00:00"
}
}
]
'import requests
url = "https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows/bulk"
payload = [{ "cellValues": {
"first_name": "John",
"years_of_experience": 5,
"is_active": True,
"start_date": "2024-02-18T05:00:00+00:00"
} }, { "cellValues": {
"first_name": "Jane",
"years_of_experience": 3,
"is_active": False,
"start_date": "2023-06-01T05: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'
}
},
{
cellValues: {
first_name: 'Jane',
years_of_experience: 3,
is_active: false,
start_date: '2023-06-01T05:00:00+00:00'
}
}
])
};
fetch('https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows/bulk', 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/bulk",
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'
]
],
[
'cellValues' => [
'first_name' => 'Jane',
'years_of_experience' => 3,
'is_active' => false,
'start_date' => '2023-06-01T05: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/bulk"
payload := strings.NewReader("[\n {\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 },\n {\n \"cellValues\": {\n \"first_name\": \"Jane\",\n \"years_of_experience\": 3,\n \"is_active\": false,\n \"start_date\": \"2023-06-01T05:00:00+00:00\"\n }\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/bulk")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("[\n {\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 },\n {\n \"cellValues\": {\n \"first_name\": \"Jane\",\n \"years_of_experience\": 3,\n \"is_active\": false,\n \"start_date\": \"2023-06-01T05:00:00+00:00\"\n }\n }\n]")
.asString();require 'uri'
require 'net/http'
url = URI("https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows/bulk")
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 {\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 },\n {\n \"cellValues\": {\n \"first_name\": \"Jane\",\n \"years_of_experience\": 3,\n \"is_active\": false,\n \"start_date\": \"2023-06-01T05:00:00+00:00\"\n }\n }\n]"
response = http.request(request)
puts response.read_body