REST Connector Offset Pagination - Start Batch with 1

[vermilyacd1]

Is there a way to tell the Offset Pagination to start with an offsetParam value of 1 instead of 0? Oracle Fusion does not accept a starting value of 0.

This is v2020.

Thanks!

[Martin]

Hello vermilyacd1,

You may use the Page type pagination, parameter for first Page number is  firstPageNumber:

We are not yet in 2020 version but this is what we have in a lower version.

Here is an example:

"pagination":{
   "page":{
      "pageSizeParam":"pageSize",
      "pageSize":1000,
      "pageRecordCount":"completeResponseMap.pageSize",
      "pageNumberParam":"offset",
      "totalCountPath":"completeResponseMap.conflictcount",
      "firstPageNumber":1
   }
}

[vermilyacd1]

Thanks @Martin, I appreciate the response. Unfortunately, the firstPageNumber works when using the page option, but we're needing to use the offset option. I did try this too but Oracle spit it back. I think I will just manually build out the nextURL and add groovy logic.