Hi, I am looking for the API from where I can fetch work-logs of all the users under the ADMIN account. I want to generate a report having details : * Full Name * Jira User Name * Email ID * Project Manager * Skill Set Please share the reference API asap. Thanks & Regards, Rashi

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Programatically pull work-logs of all the users of admin account. Need REST API

Rashi Goyal

Hi,

I am looking for the API from where I can fetch work-logs of all the users under the ADMIN account.

I want to generate a report having details :

Full Name
Jira User Name
Email ID
Project Manager
Skill Set

Please share the reference API asap.

Thanks & Regards,

Rashi

Accepted answers

Warren_mz9b4z

Hi @Rashi Goyal

You seem to contradict what you're looking for.

To me work logs are the time that a user has logged against various issues, but then in your report you only mention user-specific info. Using the following API call

rest/api/3/user/search?query=%

will return all users that you have permissions to view. It will return the accountId and dispayName for each user. The other items are not available (project manager and skill set are not part of Jira data)

All comments

Warren_mz9b4z

Hi @Rashi Goyal

You seem to contradict what you're looking for.

To me work logs are the time that a user has logged against various issues, but then in your report you only mention user-specific info. Using the following API call

rest/api/3/user/search?query=%

Rashi Goyal

Hi @Warren ,

Thanks for the answer.

I want to generate a report where I can list user and their time logged for the particular day.

Like User, A logged 7 hrs for the particular day.

So may I consider the above-mentioned solution for the same? Please confirm

Rashi

Warren_mz9b4z

Hi @Rashi Goyal

Okay, I now understand what you're trying to do.

The API query that I gave above could be used to get the list of all users, or you can just supply the list.

If you use Tempo (Jira's time tracking app) then getting logs is quite simple, you use the following API call

https://api.tempo.io/core/3/worklogs/user/UserID?from=StartDate&to=EndDate

where the dates have the format yyyy-MM-dd

If you don't use Tempo, then you need to crawl through the history of each ticket to get the details. You'll set up an API call and include expand=changelog which gives you access to the history - you will then need to work through each history checking for logged time and build up each user's count.

Rashi Goyal

Hi @Warren ,

I am not able to get the records of a particular date that I am passing. Please check my code-shared below:

$url = "https://netsmartz.atlassian.net/rest/api/2/search";

$r = '{
"jql": "project = NFLTV AND worklogDate=2020-09-29",
"maxResults": 1,
"fields": [
"summary",
"status",
"assignee",
"worklog"
]
}';

$this->curl_method($url, $r);
die('------');

Here, the worklogDate filter is not working. Rest is working fine for me. Please suggest the solution for the same. I am using POST for this.

Thanks in advance

Rashi

Rashi Goyal

Hi @Warren ,

Can you please check my above query and guide asap? I want to resolve this asap.

Rashi

Warren_mz9b4z

Hi @Rashi Goyal

Yes you're correct, you will need to paginate if you have 707 total records. I'm not sure why you keep passing in maxResults=2, that would mean over 350 API calls! My previous answer described how to paginate

For pagination, you pass in the parameter startAt. As you will see, your first API call defaults to startAt=0, so your next call would need to set startAt to 0 + 50 (i.e. startAt=50) and the call after that startAt=100 etc.

But I'll expand on that for you.

Using the API query that you've supplied, I'll expand it to show you what you need to do. For your first call, you would use

https://netsmartz.atlassian.net/rest/api/2/search?jql=project=SKL&worklogDate=2020-09-30&expand=changelog&maxResults=50&startAt=0

For your next call, it would be

https://netsmartz.atlassian.net/rest/api/2/search?jql=project=SKL&worklogDate=2020-09-30&expand=changelog&maxResults=50&startAt=50

Then the next one would be

https://netsmartz.atlassian.net/rest/api/2/search?jql=project=SKL&worklogDate=2020-09-30&expand=changelog&maxResults=50&startAt=100

So you can see that with each successive call, the only change is startAt=xx, where xx increases by 50 each time because maxResults is set to 50. You will need to code your solution to keep increasing the startAt value until startAt > total.

Now for the user's ID, if you look at the screenshot below, each history has a section which lists the user that made the change, so you can get it from there without doing anything else

Michael Raj_18ewee

Or you can set maxResults to 1000 and it will work...

Warren_mz9b4z

Hi @Michael Raj

No that won't work! Since about 2017 Atlassian have limited the number of returned records. The absolute maximum you are able to get from one call is 100 records, but I believe that you need to have changed a setting within Jira and I didn't want to get into that with @Rashi Goyal at the moment. By default, the limit is set to 50, hence my description of getting 50 records at a time

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud

rest-api