Hey community,
I am trying to set up pagination for my REST connector to ADP. I need to use the CData parameters $skip & $top.
My first call should be: https://api.eu.adp.com/hr/v2/workers?$skip=0&$top=100
Then I need to increment the $skip parameter by 100 so the next call would be: https://api.eu.adp.com/hr/v2/workers?$skip=100&$top=100
In need to end when I receive an empty response.
Anyone that has experience with this?
Best answer by Thomas Lind
Hi @Niels Jonker
I know it is not an REST data source, but if you are already using RSD files the same options should apply to this.
https://support.timextender.com/data-sources-112/advanced-rsd-file-options-884#Record+Offset <api:set attr ="EnablePaging" value ="true" />
<api:set attr ="pageoffsetparam" value ="$skip" />
<api:set attr ="pagesizeparam" value ="$top" />
<api:set attr ="pagesize" value ="100" />
View original