Get Workbook Data
curl --request POST \
--url https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/cursor \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data @- <<EOF
{
"requestPageDetails": {
"pageNumber": 1,
"pageSize": 500
},
"sortOptions": [
{
"columnName": "first_name",
"direction": "DESC"
},
{
"columnName": "last_updated",
"direction": "ASC"
}
],
"whereClause": "(`first_name` like '%d%' and `years_of_experience` > 4 and `start_date` between '2004-01-01' and '2009-12-31' and `is_active` = true)"
}
EOFimport requests
url = "https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/cursor"
payload = {
"requestPageDetails": {
"pageNumber": 1,
"pageSize": 500
},
"sortOptions": [
{
"columnName": "first_name",
"direction": "DESC"
},
{
"columnName": "last_updated",
"direction": "ASC"
}
],
"whereClause": "(`first_name` like '%d%' and `years_of_experience` > 4 and `start_date` between '2004-01-01' and '2009-12-31' and `is_active` = true)"
}
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({
requestPageDetails: {pageNumber: 1, pageSize: 500},
sortOptions: [
{columnName: 'first_name', direction: 'DESC'},
{columnName: 'last_updated', direction: 'ASC'}
],
whereClause: '(`first_name` like \'%d%\' and `years_of_experience` > 4 and `start_date` between \'2004-01-01\' and \'2009-12-31\' and `is_active` = true)'
})
};
fetch('https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/cursor', 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}/cursor",
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([
'requestPageDetails' => [
'pageNumber' => 1,
'pageSize' => 500
],
'sortOptions' => [
[
'columnName' => 'first_name',
'direction' => 'DESC'
],
[
'columnName' => 'last_updated',
'direction' => 'ASC'
]
],
'whereClause' => '(`first_name` like \'%d%\' and `years_of_experience` > 4 and `start_date` between \'2004-01-01\' and \'2009-12-31\' and `is_active` = true)'
]),
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}/cursor"
payload := strings.NewReader("{\n \"requestPageDetails\": {\n \"pageNumber\": 1,\n \"pageSize\": 500\n },\n \"sortOptions\": [\n {\n \"columnName\": \"first_name\",\n \"direction\": \"DESC\"\n },\n {\n \"columnName\": \"last_updated\",\n \"direction\": \"ASC\"\n }\n ],\n \"whereClause\": \"(`first_name` like '%d%' and `years_of_experience` > 4 and `start_date` between '2004-01-01' and '2009-12-31' and `is_active` = true)\"\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}/cursor")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"requestPageDetails\": {\n \"pageNumber\": 1,\n \"pageSize\": 500\n },\n \"sortOptions\": [\n {\n \"columnName\": \"first_name\",\n \"direction\": \"DESC\"\n },\n {\n \"columnName\": \"last_updated\",\n \"direction\": \"ASC\"\n }\n ],\n \"whereClause\": \"(`first_name` like '%d%' and `years_of_experience` > 4 and `start_date` between '2004-01-01' and '2009-12-31' and `is_active` = true)\"\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/cursor")
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 \"requestPageDetails\": {\n \"pageNumber\": 1,\n \"pageSize\": 500\n },\n \"sortOptions\": [\n {\n \"columnName\": \"first_name\",\n \"direction\": \"DESC\"\n },\n {\n \"columnName\": \"last_updated\",\n \"direction\": \"ASC\"\n }\n ],\n \"whereClause\": \"(`first_name` like '%d%' and `years_of_experience` > 4 and `start_date` between '2004-01-01' and '2009-12-31' and `is_active` = true)\"\n}"
response = http.request(request)
puts response.read_bodyWorkBook
Get Workbook Data
1️⃣ Overview
Purpose:
Retrieves records from a workbook within a workspace using cursor-based pagination.
Supports:
-
Filtering queries
-
Sorting rules
-
Pagination traversal
2️⃣ Endpoint
POST /noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/cursor
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
{
"requestPageDetails": {
"pageNumber": 1,
"pageSize": 500
},
"sortOptions": [],
"whereClause": "string"
}
7️⃣ Field Descriptions
Pagination Configuration
| Field | Type | Required | Description |
|---|---|---|---|
| requestPageDetails | object | ✅ Yes | Pagination configuration |
| requestPageDetails.pageNumber | number | ✅ Yes | Page number to retrieve (increment to fetch next page) |
| requestPageDetails.pageSize | number | ✅ Yes | Number of records per page |
| sortOptions | array | ❌ No | Sorting rules for query results |
| whereClause | string | ❌ No | SQL-like conditional filter expression |
8️⃣ Example Request
curl -X POST https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/cursor \
-H "Authorization: Bearer <token>" \
-H "Content-Type: application/json" \
-d '{
"requestPageDetails": {
"pageNumber": 1,
"pageSize": 500
},
"sortOptions": [
{
"columnName": "first_name",
"direction": "DESC"
},{
"columnName": "last_updated",
"direction": "ASC"
}
],
"whereClause": "(`first_name` like '%d%' and `years_of_experience` > 4 and `start_date` between '2004-01-01' and '2009-12-31' and `is_active` = true)"
}'
9️⃣ Behavior Summary
Retrieves workbook records using cursor-based pagination.
Supports:
• Dynamic filtering using whereClause
• Multi-field sorting using sortOptions
• Efficient pagination traversal using pageNumber and pageSize
• Large dataset handling without loading entire workbook data
POST
/
noCo
/
api
/
v2
/
workspaces
/
{workspaceId}
/
tables
/
{workbookId}
/
cursor
Get Workbook Data
curl --request POST \
--url https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/cursor \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data @- <<EOF
{
"requestPageDetails": {
"pageNumber": 1,
"pageSize": 500
},
"sortOptions": [
{
"columnName": "first_name",
"direction": "DESC"
},
{
"columnName": "last_updated",
"direction": "ASC"
}
],
"whereClause": "(`first_name` like '%d%' and `years_of_experience` > 4 and `start_date` between '2004-01-01' and '2009-12-31' and `is_active` = true)"
}
EOFimport requests
url = "https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/cursor"
payload = {
"requestPageDetails": {
"pageNumber": 1,
"pageSize": 500
},
"sortOptions": [
{
"columnName": "first_name",
"direction": "DESC"
},
{
"columnName": "last_updated",
"direction": "ASC"
}
],
"whereClause": "(`first_name` like '%d%' and `years_of_experience` > 4 and `start_date` between '2004-01-01' and '2009-12-31' and `is_active` = true)"
}
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({
requestPageDetails: {pageNumber: 1, pageSize: 500},
sortOptions: [
{columnName: 'first_name', direction: 'DESC'},
{columnName: 'last_updated', direction: 'ASC'}
],
whereClause: '(`first_name` like \'%d%\' and `years_of_experience` > 4 and `start_date` between \'2004-01-01\' and \'2009-12-31\' and `is_active` = true)'
})
};
fetch('https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/cursor', 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}/cursor",
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([
'requestPageDetails' => [
'pageNumber' => 1,
'pageSize' => 500
],
'sortOptions' => [
[
'columnName' => 'first_name',
'direction' => 'DESC'
],
[
'columnName' => 'last_updated',
'direction' => 'ASC'
]
],
'whereClause' => '(`first_name` like \'%d%\' and `years_of_experience` > 4 and `start_date` between \'2004-01-01\' and \'2009-12-31\' and `is_active` = true)'
]),
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}/cursor"
payload := strings.NewReader("{\n \"requestPageDetails\": {\n \"pageNumber\": 1,\n \"pageSize\": 500\n },\n \"sortOptions\": [\n {\n \"columnName\": \"first_name\",\n \"direction\": \"DESC\"\n },\n {\n \"columnName\": \"last_updated\",\n \"direction\": \"ASC\"\n }\n ],\n \"whereClause\": \"(`first_name` like '%d%' and `years_of_experience` > 4 and `start_date` between '2004-01-01' and '2009-12-31' and `is_active` = true)\"\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}/cursor")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"requestPageDetails\": {\n \"pageNumber\": 1,\n \"pageSize\": 500\n },\n \"sortOptions\": [\n {\n \"columnName\": \"first_name\",\n \"direction\": \"DESC\"\n },\n {\n \"columnName\": \"last_updated\",\n \"direction\": \"ASC\"\n }\n ],\n \"whereClause\": \"(`first_name` like '%d%' and `years_of_experience` > 4 and `start_date` between '2004-01-01' and '2009-12-31' and `is_active` = true)\"\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/cursor")
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 \"requestPageDetails\": {\n \"pageNumber\": 1,\n \"pageSize\": 500\n },\n \"sortOptions\": [\n {\n \"columnName\": \"first_name\",\n \"direction\": \"DESC\"\n },\n {\n \"columnName\": \"last_updated\",\n \"direction\": \"ASC\"\n }\n ],\n \"whereClause\": \"(`first_name` like '%d%' and `years_of_experience` > 4 and `start_date` between '2004-01-01' and '2009-12-31' and `is_active` = true)\"\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
Get Table Data