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)"
}
EOF

import 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_body

WorkBook

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

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)"
}
EOF

import 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_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

Body

application/json

requestPageDetails

object

Show child attributes

sortOptions

object[]

Show child attributes

whereClause

string

Response

200

Get Table Data

Get Workbook Schema Update Row In Workbook

Getting Started

Workspaces

Sign up

AI Extraction

WorkBook

Links & Joins

Knowledge Graph

Enterprise Search

Get Workbook Data

1️⃣ Overview

2️⃣ Endpoint

3️⃣ Path Parameters

4️⃣ Authentication

5️⃣ Request Headers

6️⃣ Request Body Schema

7️⃣ Field Descriptions

Pagination Configuration

8️⃣ Example Request

9️⃣ Behavior Summary

Authorizations

Path Parameters

Body

Response