Post

2 followers Follow
0
Avatar

How to get the complete timesheet ?

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.

 

Glenn singh Answered

Please sign in to leave a comment.

4 comments

0
Avatar

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

Roland Pumputis 0 votes
Comment actions Permalink
0
Avatar

Hi Roland,

I got the session Id but still I am getting the below error :

{
    "errorCode": "LoginFailure",
    "message": "You are not authorized to access this service.",
    "referenceId": "2PiK9YYLBr9l0JqV1BXzgC"
}
 
Any Idea ?
Glenn singh 0 votes
Comment actions Permalink
0
Avatar

Hi Glenn,

Could you please send me screenshots of the API call body and headers?

Roland

Roland Pumputis 0 votes
Comment actions Permalink