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 |
Type: OAuth 2.0
Refresh Token Endpoint URL: {{base_url}}/api/oauth2/token
Headers:
{
"Content-Type":"application/x-www-form-urlencoded"
} Body:
{
"grant_type":"password",
"client_id":"{{client_id}}",
"client_secret":"{{client_secret}}",
"username":"{{username}}",
"password":"{{password}}"
} 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
Bizdata Cursor Pagination Testing API demonstrates cursor-based pagination, useful for large datasets where offset is inefficient.
Method: GET
URL: {{base_url}}/orderdetails-cursor_OAuth2.0
Query Parameters:
| Parameter Name | Value | Description |
| limit | {%max_num%} | Maximum records per request |
| cursor | {%cursor_val%} | Token representing current pagination state |
Type: OAuth 2.0
Refresh Token Endpoint URL: {{base_url}}/api/oauth2/token
Headers:
{
"Content-Type":"application/x-www-form-urlencoded"
} Body:
{
"grant_type":"password",
"client_id":"{{client_id}}",
"client_secret":"{{client_secret}}",
"username":"{{username}}",
"password":"{{password}}"
} Pagination Details:
Pagination Type: Cursor Pagination
User Key: nextCursor
Data Collection Key: ['items']
Numeric Parameters:
| Parameter | Value | Description |
| Minimum Number | 0 | Minimum records per page |
| Maximum Number | 100 | Maximum records per page |
Notes:
- Cursor values are opaque and must not be modified.
- Each response returns a cursor for the next page.
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.
Total Page Count Pagination Testing API
Bizdata Total Page Count Pagination Testing API demonstrates pagination where total pages are known, allowing direct navigation.
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 |
Refresh Token Endpoint URL: {{base_url}}/api/oauth2/token
Headers:
{
"Content-Type":"application/x-www-form-urlencoded"
} Body:
{
"grant_type":"password",
"client_id":"{{client_id}}",
"client_secret":"{{client_secret}}",
"username":"{{username}}",
"password":"{{password}}"
} 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 | 1 | Minimum records per page |
| Maximum Number | 100 | Maximum records per page |
Notes:
- Allows direct page jumps.
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.
Next URL Pagination Testing API
Bizdata Next URL Pagination Testing API demonstrates following a returned URL link for pagination.
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 |
Type: OAuth 2.0
Refresh Token Endpoint URL: {{base_url}}/api/oauth2/token
Headers:
{
"Content-Type":"application/x-www-form-urlencoded"
} Body:
{
"grant_type":"password",
"client_id":"{{client_id}}",
"client_secret":"{{client_secret}}",
"username":"{{username}}",
"password":"{{password}}"
} Pagination Details:
Pagination Type: Next URL Pagination
User Key: @odata.nextLink
Data Collection Key: ['response']
Numeric Parameters:
| Parameter | Value | Description |
| Minimum Number | 1 | Minimum records per page |
| Maximum Number | 100 | Maximum records per page |
Notes:
- Next URL must be called exactly as provided.
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.
Pagination with Body Testing API
Bizdata Pagination with Body Testing 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.
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:
| Header Name | Value |
| Content-Type | application/json |
Body:
{
"pageToken":1,"pageSize":100
} Type: OAuth 2.0
Refresh Token Endpoint URL: {{base_url}}/api/oauth2/token
Headers:
{
"Content-Type":"application/x-www-form-urlencoded"
} Body:
{
"grant_type":"password",
"client_id":"{{client_id}}",
"client_secret":"{{client_secret}}",
"username":"{{username}}",
"password":"{{password}}"
} 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 | 1 | Minimum records per page |
| Maximum Number | 100 | Maximum records per page |
Notes:
- Useful for APIs requiring POST requests with pagination parameters in the body.
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.
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
0
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
Username: {{Username}}
Password: {{Password}}
Numeric Parameters
Parameter
Value
Description
Minimum Number
0
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
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
0
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
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
0
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
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
0
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.