Any Idea Looping through REST API Pagination in PeopleSoft
Any Idea Looping through REST API Pagination in PeopleSoft.
PS side created Service Operation with following URL Index
https://apistaging.fakaAPI.com/odata/v1.0/7777/Employees/2021/12?$count=true&$skip={Skip}
Here, {Skip} as variable from documents.
Default value from API Providers for GET will 100 then next run have to pass Skip = 100 for next data set.
when i run in Postman the response body will come like (JSON Responses)
"@odata.context": "https://apistaging.fakeAPI.com/odata/v1.0/7777/$metadata#Employees",
"@odata.count": 2001,
"@odata.nextLink": "https://apistaging.faceAPI.com/odata/v1.0/7777/Employees/2021/12?$count=true&$skip=100",
"value": [
{
"ID": 25987195,
"Com": "202112",
.......
We are Parsing JSON using CreateJsonParser()