Example: Paging that uses the starting after scenario
- Last Updated: January 15, 2024
- 1 minute read
- DataDirect Connectors
- JDBC
- Autonomous REST Connector 6.0
- Documentation
For this example, we are going to configure paging for the Stripe service, which requires a
value to be set for the starting_after query parameter when making requests
for the next page of data in the result set. The following is a simple JSON response from a
Stripe service:
{
"data": [
{ "id": "50031003", "name": "ABC Company" },
{ "id": "20143243", "name": "General Imports INC." }
],
"has_more" : true
}
To configure paging for Stripe, specify the starting_after parameter using
#nextPageParameter property. In addition, you must designate the field
that contains the object identifier using the #nextPageElement property.
Since the identifier field in our response is id and is embedded in the
data object, we would specify the path /data/id. The
following is an example configuration for the Stripe service:
"#pageSizeParameter": "limit",
"#maximumPageSize": 100,
"#nextPageParameter": "starting_after",
"#nextPageElement": "/data/id",
"#hasMoreElement": "/has_more",