Skip to main content
Question

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

  • January 31, 2025
  • 1 reply
  • 45 views

Forum|alt.badge.img+1
  • Gold Active Participant

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. 

This topic has been closed for replies.

1 reply

Forum|alt.badge.img+1
  • Author
  • Gold Active Participant
  • January 31, 2025

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