+1Hey 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
I know it is not an REST data source, but if you are already using RSD files the same options should apply to this.
<api:set attr="EnablePaging" value="true"/>
<api:set attr="pageoffsetparam" value="$skip" />
<api:set attr="pagesizeparam" value="$top" />
<api:set attr="pagesize" value="100" />
+5Hi
I know it is not an REST data source, but if you are already using RSD files the same options should apply to this.
<api:set attr="EnablePaging" value="true"/>
<api:set attr="pageoffsetparam" value="$skip" />
<api:set attr="pagesizeparam" value="$top" />
<api:set attr="pagesize" value="100" />Exactly, it makes it way easy to set up pagination for RSD files.
The only issue is that it doesn’t match with nested calls, so you will have to make Query Slicers for that.
Awesome thanks
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
