Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

How to increase number of records returned by REST API call?

Questions
Tags
Users
Badges
Timur Markunin
(649●5●166●146) Apr 10 '13, 7:43 a.m.
 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

0 votes

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. 

1 answer
9,758 views
0 votes

One answer

Permanent link
Kot T.
JAZZ DEVELOPER (1.5k●1●13●19) Apr 10 '13, 8:39 a.m.
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"/>

2 votes

Comments
Timur Markunin
Apr 10 '13, 10:13 a.m.
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?

Kot T.
JAZZ DEVELOPER Apr 10 '13, 4:45 p.m.
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.

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 11,108

Question asked: Apr 10 '13, 7:43 a.m.

Question was seen: 9,758 times

Last updated: Apr 10 '13, 4:45 p.m.

Confirmation Cancel Confirm