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; } } }

Get all project listing along with their status (active/inactive/archieve)

Rashi Goyal

Hi Team,

I want to fetch the list of all the projects for a particular domain(say https://xyz.com) i.e. all project names, their keys, status(if that project is marked as active/inactive/archive by that particular domain). Basically, through status, I want to track all projects.

Please suggest the API Url to get all the details asap.

@Warren do you have any idea for the same also? Anyone else having knowledge about this please respond.

Thanks

Rashi

Accepted answers

All comments

Carlos Garcia Navarro

Hi @Rashi Goyal ,

As you are in cloud, it seems that there is a feature request to cover your request:

https://jira.atlassian.com/browse/JRACLOUD-30664

(As a side note, for Server there is this ticket:

https://jira.atlassian.com/browse/JRASERVER-30664 )

That said, in Cloud you can go to Jira Settings-> Projects and check the last time that an issue was updated for every project. This could give you an idea of what projects may be inactive (if the haven't been updated in a number of months, e.g.):

Screen Shot 2020-10-14 at 11.23.16 PM.png

Regarding archived projects, this article contains details about how to manage archived projects in the Cloud: https://confluence.atlassian.com/adminjiracloud/archive-a-project-1013843066.html

From the article above, "Issues in archived projects won't appear in basic or advanced search results. You can access these issues through direct links, but you can't edit them"

Rashi Goyal

@Carlos Garcia Navarro I want to do this programmatically using an API call.

Thanks still. If you have any idea related to the API please suggest

Thanks,

Rashi

Carlos Garcia Navarro

Hi @Rashi Goyal ,

This document is a guide to the APIs to get project information:

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-projects/#api-rest-api-3-project-search-get

I ran the call /rest/api/3/project/search, but didn't get the information about 'last issue update' or information about active/inactive/archived.

I'll keep trying but I'm not sure you can get this from an API directly.

Rashi Goyal

@Carlos Garcia Navarro I am also checking the same but this is giving me the list of all projects near about 800 but in actual active/live is 130.

@Warren any suggestion from your side. I want to develop something on urgent, please guide.

Rashi

unknown

Project archiving is available for Jira Software Data Center and Jira Service Desk Data Center. For Jira Server and Jira Cloud, the endpoint:

/rest/api/{version}/project/{projectIdOrKey}

returns a value 'active' which will be either true or false. There doesn't seem to be any value returned that indicates if it's been archived.

However, the REST API v3 endpoint:

/rest/api/3/project/search

has an experimental feature that allows you to set the filter parameter of 'status' as being an array of three possible values, 'live', 'archived' or 'deleted' to filter the results. So the query:

/rest/api/3/project/search?status=archived

would return a list of projects that had the status of being archived.

Refer to this article for more information on how to use that endpoint.

Rashi Goyal

@[deleted]when I am using URL /rest/api/3/project/search?status=archived

I am getting a blank array as

stdClass Object
(
    [self] => https://netsmartz.atlassian.net/rest/api/3/project/search?maxResults=50&startAt=0&status=archived
    [maxResults] => 50
    [startAt] => 0
    [total] => 0
    [isLast] => 1
    [values] => Array
        (
        )

)

Can you please guide why this array is blank.

And also when I am using URL /rest/api/{version}/project/{projectIdOrKey}

then, which field/array will indicate that the project is archived or not.

Thanks for the help BTW

Rashi

Warren_mz9b4z

Hi @Rashi Goyal

Your return array being blank when you search for archive projects suggests that there aren't any. We don't archive projects and I get the same result, but if I use status=live then all our projects are returned.

So, what do you get for

https://netsmartz.atlassian.net/rest/api/3/project/search?maxResults=50&startAt=0&status=live

That should only return the ~130 projects that you have.

Rashi Goyal

@Warren I tried the same way but I am getting a total as 845 i.e. all projects archived/active/inactive

[maxResults] => 50
    [startAt] => 0
    [total] => 845

Does that mean there is no way to get the active projects right?

Warren_mz9b4z

Hi @Rashi Goyal

If I run that API call on our system using the 3 options, this is what I get

ARCHIVED

DELETED

LIVE

This exactly matches what is on our system, and you should be getting the same on yours. Are you certain that the API call is going through correctly?

Could you copy the API call into a browser and run it from there, like I have done? That eliminates any changes that your code may be doing. So literally copy

https://netsmartz.atlassian.net/rest/api/3/project/search?maxResults=50&startAt=0&status=live

into a browser where you're already logged in to Jira, and give us a screenshot similar to what I showed above

Rashi Goyal

@Warren please check the response. I did it in the same way.

{"self":"https://netsmartz.atlassian.net/rest/api/3/project/search?maxResults=50&startAt=0&status=live","nextPage":"https://netsmartz.atlassian.net/rest/api/3/project/search?maxResults=50&startAt=50&status=live","maxResults":50,"startAt":0,"total":845,"isLast":false,"values":[{"expand":"description,lead,issueTypes,url,projectKeys,permissions,insight","self":"https://netsmartz.atlassian.net/rest/api/3/project/13700","id":"13700","key":"AA","name":"ABC Automation","avatarUrls":{"48x48":"https://netsmartz.atlassian.net/secure/projectavatar?pid=13700&avatarId=10011","24x24":"https://netsmartz.atlassian.net/secure/projectavatar?size=small&s=small&pid=13700&avatarId=10011","16x16":"https://netsmartz.atlassian.net/secure/projectavatar?size=xsmall&s=xsmall&pid=13700&avatarId=10011","32x32":"https://netsmartz.atlassian.net/secure/projectavatar?size=medium&s=medium&pid=13700&avatarId=10011"},"projectTypeKey":"software","simplified":false,"style":"classic","isPrivate":false,"properties":{}},

Still total is 845. It must be 137

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

rest-api

api

jira-app-development

jira-software-development