Skip to main content

Good afternoon, Planview team,

I hope this message finds you well.

I am reaching out to request clarification regarding the limitations and governance mechanisms of the AdaptiveWork API, as outlined in the REST API Guide - Version 2.

Specifically, I would like to understand how to handle queries that require extracting more than 100 records, given that the documentation mentions the following:

  • Request batch limiting: The total number of requests that can be processed in a single call to the web service is 100.
  • Request limiting: The total size of requests sent in a single call to the web service must not exceed 25 MB.
  • Call limiting: 1,000 API calls per paid license per day, with a maximum of 1,000,000 calls per day.
  • Rate limiting: Up to 25 requests per second are allowed, with the quota being global for the organization, not per user.
  • Request conditions limiting: The total number of conditions (OR/AND/IF, etc.) in a single API call should not exceed 200 by default. If the quota is exceeded, the error "errorCode": "General", "message": "CZQL query has a maximum limit of 200 conditions" is displayed.

Considering that the data we need to extract may exceed 100 records, what are the best practices or recommended methods for making queries that involve handling a large volume of data? I would appreciate any guidance or strategies you can provide to optimize this process and ensure that requests are managed efficiently within the established limits.

Thank you in advance for your attention, and I look forward to your response.

Best regards

Hi Lucia. Many thanks for using the Community to post your question about the AdativeWork API. I would suggest posting this question in the AdaptiveWork channel - AdaptiveWork | Planview Customer Community.

I have spoken to the moderator, and she is working on a response for you.

Hi Lucia, Since you are looking to extract the data our technical team suggested to use CZQL query to fetch the data from AW. Here is the link for https://api.clarizen.com/V2.0/services/data/Query for your reference. 

Here you would need to use pagination. It will allow you to fetch up-to 5000 records at one go (This is confirmed by our Integration team). 

For Eg: 

{
    "q":"select Name from project" ,
    "paging": {
        "from": 0,
        "limit": 5000
    }
}

here I am asking to fetch the data from 0 to 5000 records at one go. 

 

If you still need additional help on how to get this done, I would suggest you raise a ticket for us to help you further. 

Hello Vikas, 

I AM PASSING THE PARAMATERS TO THIS QUERY -https://api2.clarizen.com/v2.0/services/data/query?q=SELECT SYSID FROM task&from=0&limit=1 AND THE RESULT WHEN RUNNING IT IN POSTMAN IS ],
    “pagination": {
        “from": 100
        “limit": 100
        “hasMore": true
    }
} I DON'T KNOW IF YOU CAN TELL ME MORE ABOUT HOW TO EXTEND THESE PROPERTIES IN THE WAY YOU EXPLAIN. 

 

Reply


Terms of UseCookie settings
All Data Subject Access Requests (DSARs), and requests of “Do Not Sell My Personal Information” according to the CCPA, must be submitted through the Planview DSAR portal located here

Planview has appointed a Data Privacy Officer (DPO) to be responsible for overseeing our Privacy Management Program and related privacy compliance measures. DPO can be contacted at privacy@planview.com