Time Phase Data (project assignment and date) through the API

Question

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.

Shana · Answer

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????

Planview Customer Community

Login with SSO

Planview Customer Community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded