Clarity PPM1

Expand all | Collapse all

How to get all projects using REST API GET method?

Jump to Best Answer
  • 1.  How to get all projects using REST API GET method?

    Posted 05-22-2017 12:15 PM

    Looks like default limit is 25 and max you could do is 200? How to get all projects?



  • 2.  Re: How to get all projects using REST API GET method?

    Posted 05-23-2017 04:29 AM

    Just a small reminder/disclaimer, the REST API is currently not supported for Customer or partner use as this is still under active development. This is documented in https://docops.ca.com/ca-ppm/15-2/en/reference/rest-apis  or the equivalent page for your PPM release.

     

    Still, if you want to use it, understanding the consequences, you can use the "offset" parameter, so that it starts in the nth project, i.e.: http://<yourserver>/ppm/rest/v1/projects?offset=X 

    The "limit" parameter is defaulting to 25 and the maximum is 200 (valid range is 1-200).

     

    The full list of parameters available for your release (they differ between releases), along with an explanation and even a method to try them on PPM itself can be checked in http://<yourserver>/niku/rest/describe/index.html (open this site after being logged into PPM).



  • 3.  Re: How to get all projects using REST API GET method?

    Posted 05-24-2017 02:45 PM

    So in that case with limit of maximum 200 you do multiple batches with Offset N if you need to pull more.



  • 4.  Re: How to get all projects using REST API GET method?
    Best Answer

    Posted 05-25-2017 02:37 AM

    That's correct. You should do it for offset=0 (of course, this is not needed for a value of 0), then 200, 400... until you got all the projects.

    Regards.



  • 5.  Re: How to get all projects using REST API GET method?

    Posted 07-20-2018 01:25 PM

    Hi Marc, Do you know if there is a way to modify the limit from 200 to larger no? Is there Bulk option available in 1000s?



  • 6.  Re: How to get all projects using REST API GET method?

    Posted 07-22-2018 11:04 AM

    The design of the REST call in PPM is restricted to 200 at this point of time and you can loop through the request to get all the projects and not at chunk. 



  • 7.  Re: How to get all projects using REST API GET method?

    Posted 05-25-2017 03:56 AM

    Hi Dharmesh,

     

    Have you considered using the WSDL?

    https://docops.ca.com/ca-ppm/15-2/en/reference/xml-open-gateway-xog-development/xog-wsdl/ 

     

    XML might not be so fun, but it works