How to increase number of records returned by REST API call?
Hello,
I'm trying to get all users allocation XML using REST API. I've tried https://kvhoclm3.delta.internal:9443/ccm/rpt/repository/apt?fields=apt%2FworkResourceDetails%2F%28contributor%2FuserId|assignment|startDate|endDate%29 and it returns only 100 records.
I've tried https://kvhoclm3.delta.internal:9443/ccm/rpt/repository/apt?fields=apt%2FworkResourceDetails%2F%28contributor%2FuserId|assignment|startDate|endDate%29&size=1000
and again only 100 records.
Any ideas on how I could retrieve all records?
-thanks in advance
One answer
The URL should return all the records, but only display 100 element per page. You can use the URL at the top of the page to navigate to the following pages.
<apt Version="1.0.0" rel="next" href="https://kvhoclm3.delta.internal:9443/ccm/rpt/repository/apt?fields=apt%2FworkResourceDetails%2F%28contributor%2FuserId%7Cassignment%7CstartDate%7CendDate%29&id=<id>&size=100&pos=100"/>
<apt Version="1.0.0" rel="next" href="https://kvhoclm3.delta.internal:9443/ccm/rpt/repository/apt?fields=apt%2FworkResourceDetails%2F%28contributor%2FuserId%7Cassignment%7CstartDate%7CendDate%29&id=<id>&size=100&pos=100"/>
Comments
Hi Kot!
Could you please clarify how it works?
I guess 'size' means size of XML chunk?
What about 'pos'?
I'm asking because I've tried your proposal and empty XML was returned:
<apt Version="1.0.0"/>
I could see in RTC UI that particular person has more assignments than in returned XML.
-thanks in advance?
Hi Timur,
You are right. Size is the # of elements returned per page. pos is the starting element to be loaded.
For example, assuming you have 50 elements returned from the above URL and you set the size to return 10 elements per page. pos will be 10 when you want to go to the second page, and 20 when you want to go to the 3rd page.
Comments
Sandy Grewal
JAZZ DEVELOPER Apr 10 '13, 9:55 a.m.Hi,
At the end of the URL on first line do you see "&size=1000&pos=1000" ?
Timur Markunin
Apr 10 '13, 10:09 a.m.Hi Sandy! Yes, I see it.