Start Date Task Priority WI Project Control Number Parent Project Name
Mon Tue Wed Thru Fri Sat Sun Total
I fill the timesheet in above clarizen format. Now I have been given a task to retrieve timesheet detail with all the above information for different users. (by prodiving each user credential ).
While retrieving the above data, I also want to retireve the hours for each day in that week.
Let's say on Monday I logged the time against project A with 8 hrs. I wish to retireve complete timesheet info with this time spent.
Is there any rest api that can help me to achieve this ?
Thanks in advance.
Please sign in to leave a comment.
Hi Glenn,
I think you could achieve this by using the Query API endpoint: https://api.clarizen.com/V2.0/services/data/Query
Example:
{
q: 'SELECT Duration FROM Timesheet WHERE WorkItem="/Task/2hqixclz7ro8ha03870ypf739318" AND ReportedDate=2019-11-18 LIMIT 1000 OFFSET 0'
}
I hope this helps.
Roland
Hello Glenn,
You need to login using https://api.clarizen.com/V2.0/services/authentication/Login first. This will give you the session ID which should be used in the headers of https://api.clarizen.com/V2.0/services/data/Query call like so:
I hope this helps.
Roland
Hi Roland,
I got the session Id but still I am getting the below error :
Hi Glenn,
Could you please send me screenshots of the API call body and headers?
Roland
