Rally Software

Expand all | Collapse all

How to increase the query result size in Rally LookBack API

Jump to Best Answer
  • 1.  How to increase the query result size in Rally LookBack API

    Posted 03-20-2018 03:35 PM

    When I try to access data through the lookback api using following url

     

    https://rally1.rallydev.com/slm/webservice/v2.0/releasecumulativeflowdata?workspace=https://rally1.rallydev.com/slm/webservice/v2.0/workspace/46772661387&query=&fetch=true&start=0&pagesize=10000

     

    I get , "Warnings": ["Maximum page size is 2000 -- ignoring requested size of 10000"

     

    If I specify the limit to 10000, still it gets 2000 records only. How can I get all the records?



  • 2.  Re: How to increase the query result size in Rally LookBack API
    Best Answer

    Posted 03-21-2018 05:03 AM

    Ritu,

     

    The Interactive Web Services API Documentation at, https://rally1.rallydev.com/slm/doc/webservice , has further information.  For this specific question, these two sections apply:

     

    pagesize

    Number of results to display on the page. Must be greater than 0 and less than or equal to 200 for 1.x API calls or 2000 for 2.x API calls. The default is 20.
    Example: pagesize=30

     

    start

    The start index for queries, which begins at 1. The default is 1.
    Example: start=1

    Since you have more than 2000 records to fetch, you will need to make multiple calls incrementing the "start" field as appropriate.  In the Web Services API return there is a "TotalResultCount" field that comes back, you will know how many Total Records there are to fetch.

     

    So in your case, the first call would be:

     

    https://rally1.rallydev.com/slm/webservice/v2.0/releasecumulativeflowdata?workspace=https://rally1.rallydev.com/slm/webservice/v2.0/workspace/46772661387&query=&fetch=true&pagesize=2000&start=1

     

    And the second would be:

     

    https://rally1.rallydev.com/slm/webservice/v2.0/releasecumulativeflowdata?workspace=https://rally1.rallydev.com/slm/webservice/v2.0/workspace/46772661387&query=&fetch=true&pagesize=2000&start=2001

     

    And so on.

     

    Hope that helps.


    Michael



  • 3.  Re: How to increase the query result size in Rally LookBack API

    Posted 03-21-2018 09:12 AM

    Thanks Michael for detailed explanation! We were trying to achieve it in this way, but was wondering if there was a way to get all the results together.

     

    Thanks for your help.

     

    Ritu Bhagat

    Senior Engineer

    Software Engineering

     

    Mastercard

    tel (636)722-3421 | mobile (314)852-4723

    <www.mastercard.com>



  • 4.  Re: How to increase the query result size in Rally LookBack API

    Posted 05-17-2018 07:33 AM


  • 5.  Re: How to increase the query result size in Rally LookBack API

    Posted 05-17-2018 08:57 AM

    dlesny,

     

    Do you mean it didn't reduce the number of records or there was an error?  If there was an error, ensure there is a space on both sides of the '>'.  

     

    &query=(CreationDate > "2018-01-01")



  • 6.  Re: How to increase the query result size in Rally LookBack API

    Posted 05-17-2018 09:22 AM

    GREAT!! Works  Thank you!