Dear all,
I am currently using Infor ION and SunSystems - API Gateway.
I want to retrieve all journal entries from SunSystems Ledger A using a REST API endpoint:
text:
/businessobject/v1/{businessUnit}/ledger-lines/query-json?ledgerCode=A&page=0&pageSize=100
The API response includes a links structure with a next URL for the subsequent pages, as shown below:
json:
{
"links": [
{
"rel": "self",
"href": "https://.../query-json?ledgerCode=A&page=0&pageSize=100"
},
{
"rel": "next",
"href": "https://.../query-json?ledgerCode=A&page=1&pageSize=100"
}
],
"content": [...]
}
What I have done
- Created a Connection Point for the SunSystems API endpoint in ION
- Set up the Connection Point with request parameters: ledgerCode=A, page=0, pageSize=100
- The Connection Point successfully calls the API and returns the first page of data (100 records)
The Problem:
I observed that the Connection Point does not automatically follow the next URL to retrieve subsequent pages. It only returns the first page (page=0) and does not aggregate data from all pages.
My Questions:
- Does the Infor ION Connection Point have a built-in mechanism to automatically follow the next URL and fetch all pages of data until the complete dataset is retrieved?
- If not, what is the recommended standard approach within Infor ION to handle this pagination scenario? For example:
- Is there a specific configuration within the Connection Point or Data Flow that supports automatic pagination?
Any guidance, documentation references, or examples would be greatly appreciated.
Thank you for your support!
