Fetch projects by recent activity

[Christian Isaza]

Hello, community.

Today I would like to know if there is any one to fetch from Jira, Atlassian Admin hub or API the list of the projects that have had activity in a recent period of time.

I am working to organize our Jira/Confluence access based on groups instead of individual access to projects/spaces.

To do so, I have fetched through the Jira API a list of all of our projects, but I see it is about 300+ projects and would like to focus on creating groups only for the active ones-with recent activity.

So far, I haven't had any luck googling nor with AI assistance.

If anyone can share any tips I will be really thankful.

[Marc -Devoteam-]

Hi @Christian Isaza 

Via the Jira UI and the projects option, you can order the projects by "Last Issue Update".

Or look at the JIra API, based on Get projects paginated and use the orderby option and use the lastIssueUpdatedTime property or expand option and the insights property.

[Christian Isaza]

Hey @Marc -Devoteam- thank you for your response.

If you don't mind would you please share with me an example? (maybe screenshots or something) -I have been trying during the whole day to use Get Projects paginated but it won't work; only shows the first 50 projects and for the "next page" it throws nothing. And noticed that even those first 50 projects won't show the lastissueupdatedtime.

Hence, I tried with regular (deprecated) get all projects call and it's the same; I get the projects but I do not get the lastissueupdatetime.

In both cases I used basic auth, just in case.

[Marc -Devoteam-]

{{baseUrl}}/rest/api/3/project/search?startAt=0&maxResults=50&orderBy=lastIssueUpdatedTime&expand=insights&status=live

The output is ordered by lastissueupdatetime

[Christian Isaza]

Thank you @Marc -Devoteam- unfortunately, for some reason it is not working for me. It just shows the first 50 and the rest of the pages are just empty.

[Marc -Devoteam-]

Hi @Christian Isaza 

More on pagination can be found here: https://developer.atlassian.com/cloud/jira/platform/rest/v3/intro/#pagination 

[Christian Isaza]

Hey @Marc -Devoteam- thank you so much for the help.