AI Workflow Testing APIs

Offset Pagination Testing API

Bizdata Offset Pagination Testing API demonstrates standard offset pagination inside eZintegration product. By referencing this API, users can configure their real APIs in the integration bridge.

Method: GET

URL: {{base_url}}/orderdetails-offset_OAuth2.0

Query Parameters:

Parameter Name	Value	Description
limit	{%max_num%}	Maximum value provided in numeric params field
offset	{%min_num%}	Minimum value provided in numeric params field

Authorization:

Type: OAuth 2.0

Refresh Token Endpoint URL: {{base_url}}/api/oauth2/token

Headers:

{
"Content-Type":"application/x-www-form-urlencoded"
}

Body:

{
"grant_type":"refresh_token",
"refresh_token":"{{refresh_token}}",
"client_id":"{{client_id}}",
"client_secret":"{{client_secret}}"
}

Pagination Details:

Pagination Type: Offset Pagination

User Key: hasMore

Key to update: offset

Data Collection Key: ['items']

Numeric Parameters:

Parameter	Value	Description
Minimum Number	0	Minimum records required per page
Maximum Number	100	Maximum records allowed per page

Notes:

Standard offset pagination.
Increment offset to fetch subsequent pages.
hasMore indicates more data availability.

Authentication Instructions:

To acquire the Base URL and create your own Client ID and Secret, please refer to the My Profile section within your Bizdata account.

Cursor Pagination Testing API

~~Overview~~

Bizdata Cursor Pagination Testing API demonstrates cursor-based pagination, useful for large datasets where offset is inefficient.

~~Endpoint~~

Method: GET

URL: {{base_url}}/orderdetails-cursor_OAuth2.0

Query ~~Parameters~~Parameters:

Parameter Name	Value	Description
limit	{%max_num%}	Maximum records per request
cursor	{%cursor_val%}	Token representing current pagination state

~~Authorization~~ Authorization:

Type: OAuth 2.0

Refresh Token Endpoint URL: {{~~token_rul}~~base_url}}/api/oauth2/token

Headers:

{
"Content-Type":"application/x-www-form-urlencoded"
}

Body:

~~Body:~~

{"grant_type":"refresh_token",
"refresh_token":"{{refresh_token}}",
"client_id":"{{client_id}}",
"client_secret":"{{client_secret}}"
}

Pagination Details:

~~Pagination Details~~

Pagination Type: Cursor Pagination

User Key: nextCursor

Data Collection Key: ['items']

Numeric ~~Parameters~~Parameters:

Parameter	Value	Description
Minimum Number	0	Minimum records per page
Maximum Number	100	Maximum records per page

Notes:

~~Notes~~

Cursor values are opaque and must not be modified.

Each response returns a cursor for the next ~~page.~~page.

Authentication

Instructions:

acquire

~~Contact~~the

Base

URL

and

create

your

~~User~~own ~~can generate~~ Client ID and ~~Client~~Secret, ~~Secret~~please inrefer to the My ~~Profile.~~Profile

section within your Bizdata account.

Total Page Count Pagination Testing API

Overview

Bizdata Total Page Count Pagination Testing API demonstrates pagination where total pages are known, allowing direct navigation.

Endpoint

Method: GET

URL: {{base_url}}/orderdetails-tpc

Query Parameters

Parameter Name

Value

Description

limit

{%max_num%}

Maximum records per page

page

{%min_num%}

Starting page number

Authorization

Type: OAuth 2.0

Refresh Token Endpoint URL: {{token_rul}}/api/oauth2/token

Headers:

{"Content-Type":"application/x-www-form-urlencoded"}

Body:

{"grant_type":"refresh_token","refresh_token":"{{refresh_token}}","client_id":"{{client_id}}","client_secret":"{{client_secret}}"}

Pagination Details

Pagination Type: Total Page Count Pagination

User Key: total_pages

Key to update: page

Data Collection Key: ['response']

Numeric Parameters

Parameter

Value

Description

Minimum Number

Minimum records per page

Maximum Number

100

Maximum records per page

Notes

Allows direct page jumps.

Contact

User can generate Client ID and Client Secret in My Profile.

Next URL Pagination API

Overview

Bizdata Next URL Pagination Testing API demonstrates following a returned URL link for pagination.

Endpoint

Method: GET

URL: {{base_url}}/orderdetails-nexturl_OAuth2.0

Query Parameters

Parameter Name

Value

Description

limit

{%max_num%}

Maximum records per page

page

{%min_num%}

Starting page number

Authorization

Type: OAuth 2.0

Refresh Token Endpoint URL: {{token_rul}}/api/oauth2/token

Headers:

{"Content-Type":"application/x-www-form-urlencoded"}

Body:

{"grant_type":"refresh_token","refresh_token":"{{refresh_token}}","client_id":"{{client_id}}","client_secret":"{{client_secret}}"}

Pagination Details

Pagination Type: Next URL Pagination

User Key: @odata.nextLink

Data Collection Key: ['response']

Numeric Parameters

Parameter

Value

Description

Minimum Number

Minimum records per page

Maximum Number

100

Maximum records per page

Notes

Next URL must be called exactly as provided.

Contact

User can generate Client ID and Client Secret in My Profile.

Pagination with Body API

Overview

Bizdata Pagination with Body API demonstrates a pagination approach where parameters are sent in the request body instead of query parameters. This is useful for APIs that require POST requests for retrieving paginated data.

Endpoint

Method: POST

URL: {{base_url}}/orderdetails-paginationbody

Query Parameters

Parameter Name

Value

Description

pageSize

{%max_num%}

Maximum records per page

pageToken

{%min_num%}

Starting point for records

Headers

Content-Type: application/json

Body

{"pageToken":1,"pageSize":100}

Authorization

Type: OAuth 2.0

Refresh Token Endpoint URL: {{token_rul}}/api/oauth2/token

Headers:

{"Content-Type":"application/x-www-form-urlencoded"}

Body:

{"grant_type":"refresh_token","refresh_token":"{{refresh_token}}","client_id":"{{client_id}}","client_secret":"{{client_secret}}"}

Pagination Details

Pagination Type: Pagination with Body

User Key: nextPageToken

Key to update: pageToken

Data Collection Key: ['items']

Numeric Parameters

Parameter

Value

Description

Minimum Number

Minimum records per page

Maximum Number

100

Maximum records per page

Notes

Useful for APIs requiring POST requests with pagination parameters in the body.

Contact

User can generate Client ID and Client Secret in My Profile.

No Auth API

Overview

Bizdata No Auth API demonstrates pagination without authentication. It is useful for public datasets where authentication is not required.

Endpoint

Method: GET

URL: {{base_url}}/Orderdetails-noauth

Numeric Parameters

Parameter

Value

Description

Minimum Number

Minimum records per page

Maximum Number

1000

Maximum records per page

Notes

No authentication required.

Standard offset pagination applies.

Contact

Support Portal: help.bizdata360.com

Email: support@bizdata360.com

Basic Auth API

Overview

Bizdata Basic Auth API demonstrates pagination with basic authentication. Useful for legacy APIs requiring username and password.

Endpoint

Method: GET

URL: {{base_url}}/orderdetails-basicauth

Authorization

Username: {{Username}}

Password: {{Password}}

Numeric Parameters

Parameter

Value

Description

Minimum Number

Minimum records per page

Maximum Number

1000

Maximum records per page

Notes

Basic authentication required.

Contact

Support Portal: help.bizdata360.com

Email: support@bizdata360.com

OAuth2.0 API

Overview

Bizdata OAuth2.0 API demonstrates standard OAuth2.0 authentication with refresh token for pagination.

Endpoint

Method: GET

URL: {{base_url}}/orderdetails-OAuth2.0

Authorization

Type: OAuth 2.0

Refresh Token Endpoint URL: {{token_rul}}/api/oauth2/token

Headers:

{"Content-Type":"application/x-www-form-urlencoded"}

Body:

{"grant_type":"refresh_token","refresh_token":"{{refresh_token}}","client_id":"{{client_id}}","client_secret":"{{client_secret}}"}

Numeric Parameters

Parameter

Value

Description

Minimum Number

Minimum records per page

Maximum Number

1000

Maximum records per page

Notes

Standard offset pagination applies.

Contact

User can generate Client ID and Client Secret in My Profile.

Support Portal: help.bizdata360.com

Email: support@bizdata360.com

Salesforce API

Overview

Bizdata Salesforce API demonstrates OAuth2.0 pagination for Salesforce datasets.

Endpoint

Method: GET

URL: {{base_url}}/services/data/v1.0/query/?q=SELECT+CUSTOMER_ID,CUSTOMERNAME,CUSTOMEREMAIL,CUSTOMERPHONE+FROM+QA_CUSTOMER_DATA

Authorization

Type: OAuth 2.0

Refresh Token Endpoint URL: {{token_rul}}/api/oauth2/token

Headers:

{"Content-Type":"application/x-www-form-urlencoded"}

Body:

{"grant_type":"refresh_token","refresh_token":"{{refresh_token}}","client_id":"{{client_id}}","client_secret":"{{client_secret}}"}

Numeric Parameters

Parameter

Value

Description

Minimum Number

Minimum records per page

Maximum Number

1000

Maximum records per page

Notes

Follows Salesforce query structure.

Contact

User can generate Client ID and Client Secret in My Profile.

Support Portal: help.bizdata360.com

Email: support@bizdata360.com

Netsuite Source API

Overview

Bizdata Netsuite Source API demonstrates OAuth1.0a signature-based authentication with cursor pagination for Netsuite datasets.

Endpoint

Method: GET

URL: {{base_url}}/services/rest/query/v1/suiteql?

Query Parameters

Parameter Name

Value

Description

limit

{%max_num%}

Maximum records per page

offset

{%min_num%}

Starting point for records

Headers

Authorization: {%signature%}

Pre-request Script

import datetime

import random

import string

import hashlib

import base64

import hmac

import urllib.parse

request_method = 'POST'

url = 'https:// {{base_url}} /partner/services/rest/query/v1/suiteql'

oauth_consumer_id = {{oauth_consumer_id}}

oauth_consumer_key = {{oauth_consumer_key}}

oauth_consumer_secret ={{}}oauth_consumer_secret}}

oauth_token ={{oauth_token}}

oauth_token_secret ={{oauth_token_secret}}

oauth_signature_method = 'HMAC-SHA256'

oauth_timestamp = str(int(datetime.datetime.now().timestamp()))

oauth_nonce = ''.join(random.choices(string.ascii_letters + string.digits, k = 11))

oauth_version = '1.0'

normalized_request_method = request_method.replace(' ', '')

normalized_string_url = urllib.parse.quote(url, safe = '')

normalized_params = {'oauth_consumer_key': oauth_consumer_key,'oauth_token': oauth_token,'oauth_signature_method': oauth_signature_method,'oauth_timestamp': oauth_timestamp,'oauth_nonce': oauth_nonce,'oauth_version': oauth_version,'limit':max_num,'offset':min_num}

sorted_params = dict(sorted(normalized_params.items()))

normalized_string_parmas = [k+'='+v for k,v in sorted_params.items()]

normalized_string_parmas = '&'.join([str(elem) for elem in normalized_string_parmas])

normalized_string_parmas.replace(' ','')

normalized_string_parmas = urllib.parse.quote(normalized_string_parmas, safe = '')

base_string = request_method + '&' + normalized_string_url + '&' + normalized_string_parmas

base_string = str.encode(base_string)

signature_key = oauth_consumer_secret + '&' + oauth_token_secret

signature_key = str.encode(signature_key)

oauth_signature = hmac.new(signature_key, base_string, hashlib.sha256)

oauth_signature.hexdigest()

oauth_signature = base64.b64encode(oauth_signature.digest())

oauth_signature = oauth_signature.decode('UTF-8')

oauth_signature = urllib.parse.quote(oauth_signature, safe = '')

signature ='OAuth realm="'f'{oauth_consumer_id}",oauth_consumer_key="'f'{oauth_consumer_key}",oauth_token="'f'{oauth_token}",oauth_signature_method="'f'{oauth_signature_method}",oauth_timestamp="'f'{oauth_timestamp}",oauth_nonce="'f'{oauth_nonce}",oauth_version="'f'{oauth_version}",oauth_signature="'f'{oauth_signature}"'Pagination Details

Pagination Type: Offset Pagination

User Key: hasMore

Key to update: offset

Data Collection Key: ['items']

Numeric Parameters

Parameter

Value

Description

Minimum Number

Minimum records per page

Maximum Number

100

Maximum records per page

Notes

Requires OAuth1.0a signature.

Contact

User can generate Client ID and Client Secret in My Profile.