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

How to get the all the project name details using the RestAPI

Senthil V_5pzrxa

Hi,

Am using the jira module in python to get the all project details using for one custom field, the python coding will be like below,

fieldid=cf[XXXXX]
associated_projects = []
JQL="%s is not EMPTY order by updated" % (fieldid)
issues = jira.search_issues(JQL, maxResults=1, fields="issue key")
for issue in issues:
jira_issue = jira.issue(issue.key, fields='project')
project_key = jira_issue.fields.project.key
print ("Project Key", project_key)
associated_projects.append(str(project_key))

associated_projects list have all project name details, from this above code it will take more time to fetch the all project name one by one, whether this same needs to done in one single Rest API call? to get the all project name detail for customfiled.
So that we could save the more time.

Accepted answers

All comments

Tarun Sapra

Hello @Senthil V

Here's the way to do it in a single REST call

https://community.atlassian.com/t5/Jira-questions/Jira-REST-API-to-get-projects/qaq-p/728218

Tarun Sapra

From the docs

https://docs.atlassian.com/software/jira/docs/api/REST/7.12.0/?_ga=2.179258285.804418687.1552295142-1359772982.1527518782#api/2/project-getAllProjects

Senthil V_5pzrxa

Hi Tarun Sapra,

Thanks for the information sharing, but i need some restriction is jql query.

JQL="%s is not EMPTY order by updated" % (fieldid)

I want to form this jql query like above to get the project details.

Tarun Sapra

Hello @Senthil V

But the JQL query is only going to give you issues and from those issues which can get the project keys.

In your code here

jira_issue = jira.issue(issue.key, fields='project')
project_key = jira_issue.fields.project.key
print ("Project Key", project_key)

You are only getting the project key, which you can also get from the issue key (ABC-123) in this issue key "ABC" is the project. So you can do one REST call based on the JQL and then parse the results of all issueKeys returned and each of the issueKey contains the project key as well thus you are doing everything in just one REST call.