Skip to main content

I am using the API to pull data for reporting on Power BI. I would like to replicate the Time Phase Monthly data between Projects and Resources - basically, project assignment and the month. Has anyone had success with this over the API? Care to share your rest query? Thanks. 

Solved it myself. But now I have a new question. 

This works: 

 curl -X POST "https://api.clarizen.com/V2.0/services/data/query" -H "Authorization: ApiKey MyKey" -H "Content-Type: application/json" -d '{
    "q": "SELECT ProjectAssignment, Date, WorkItem.SYSID, WorkItem.Name, User.Name, User.RevenueRegularRate FROM RLTimePhaseMonthly",
    "paging": {
        "offset": 0,
        "limit": 10
    }

 

 

But this doesn’t (contains a WHERE filter): 
 

curl -X POST "https://api.clarizen.com/V2.0/services/data/query" -H "Authorization: ApiKey MyKey" -H "Content-Type: application/json" -d '{
    "q": "SELECT ProjectAssignment, Date, WorkItem.SYSID, WorkItem.Name, User.Name, User.RevenueRegularRate FROM RLTimePhaseMonthly WHERE User.RevenueRegularRate > 0",
    "paging": {
        "offset": 0,
        "limit": 10
    }
}'

 

 

 

Anyone know why????

 

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