How to use API pagination in build action project_SAP Build Process Automation

[NehaU]

Hi Team,

I am working on a process where we create an Action Project and use a destination to get the cost center data from an API.

The action works fine, but there is a large amount of data available, so I am unable to get all the data. I am receiving a timeout error. We can provide inputs such as filtering for the top records, but I want to retrieve all the data. I have read about pagination in the SAP help documents, but I am a bit confused about how to implement it.

I am using this data in form creation and approval workflows for dropdown fields.

It would be greatly appreciated if anyone could help me with this.

Thank you!

[james2526]

To use API pagination in SAP Build Process Automation, set up an API call with pagination support. Use a loop to fetch data from each page until all results are retrieved. Store and process the data, checking for a NeXT Page or similar parameter to continue fetching. Use the http Request action to handle the API calls and manage pagination efficiently.

[NehaU]

Hi James, Thanks for the response. I am not using HTTP requests. We have created a destination in SAP BTP and are using principal propagation authentication. Through the Action Project, we are retrieving the data from the API. My question is, how can we implement pagination in the Action Project?