Retrieve Logged work per day&user from API

Our programmers have tol log all the work they do on Jira issues. 

I want to create a script (bash/php/whatever) that runs daily to check if every programmer logged enough hours.  It should work something like this

  1. Get date
  2. Get user
  3. Find all the logged hours for this date & user 

 

I already do this on our self hosted Jira instance, but I use the 'RESTful Worklog Query'  add-on for that.  This addon is not available for the cloud.

I have read through the docs, but this doesn't seem to be possible? 

Any thoughts on this?

 

1 answer

0 votes

I can't see clear way to input a user and a date in order to get back all that I think you are looking for here in a single call.

However there are two different REST endpoints that you could use to find this out.   First you would need to find all the worklog ids.  You can use the /rest/api/2/worklog/updated endpoint to do this.  That REST endpoint has an optional parameter, it is a unix time value. If supplied the REST call only returns the worklogs since that time supplied.   My thought is that you could run this REST call everyday with a changing time parameter as to some time from yesterday, or 24 hours ago in the unix epoch time.

With the results of that, you can then see all the worklog ids.  You would need those ids in order to then use the rest/api/2/worklog/list endpoint.   If you make that call and supply it all the ids you got back from the first call in order to see all the worklogs via rest for all users during that time.

I know this isn't exactly what you are looking for here, but this is one way that you could use the REST API in order to get this data in a raw form.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,755 views 11 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot