Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

How to use a Pagination in Oracle Fusion REST Connector

adityachadde
New Contributor III
New Contributor III

Hi,

We are trying to import entitlements Oracle Fusion Application using REST Connector. Oracle Fusion Entitlements API returns only 500 records per page. 

To get the remaining Entitlement values in postman we are using below format:

URL/hcmRestApi/scim/Roles?sortBy=name&count=500&startIndex=1

URL/hcmRestApi/scim/Roles?sortBy=name&count=500&startIndex=501

URL/hcmRestApi/scim/Roles?sortBy=name&count=500&startIndex=1001

and so on.

We want to achieve this thing using saviynt REST Connector Pagination Concept.

We tried below pagination in below format:

"pagination": {
              "offset": {
                "offsetParam": "startIndex",
                "batchParam": "count",
                "batchSize": 500,
                "totalCountPath": "completeResponseMap.totalResults"
              }
            }

"pagination": {
          "offset": {
            "offsetParam": "startIndex",
            "batchParam": "count",
            "batchSize": 500,
            "totalCountPath": {
              "connection": "acctAuth",
              "http": {
                "url": "URL/hcmRestApi/scim/Roles",
                "httpHeaders": {
                  "Authorization": "${access_token}"
                },
                "httpContentType": "application/json",
                "httpMethod": "GET"
              }
            }
          }
        }

 

"pagination": {
          "offset": {
            "offsetParam": "offset",
            "batchParam": "limit",
            "batchSize": 500,
            "totalCountPath": {
              "connection": "acctAuth",
              "http": {
                "url": "URL/hcmRestApi/scim/Roles",
                "httpHeaders": {
                  "Authorization": "${access_token}"
                },
                "httpContentType": "application/json",
                "httpMethod": "GET"
              },
              "totalCountPath": "totalResults"
            }
            }
           }

We are unable to import all the Entitlements. 

We are getting below response in postman

{
    "itemsPerPage"500,
    "startIndex"1,
    "Resources": [
      DATA...............................
]
How we can use the Pagination to change the start index and import all entitlements?
Please Suggest correct Pagination format to achieve this.
 
Thank You.
Aditya Chadde
 
 
1 REPLY 1

rushikeshvartak
All-Star
All-Star

Please refer example of pagination (Example 4)

https://saviynt.freshdesk.com/support/solutions/articles/43000521736-rest-connector-guide%C2%A0 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.