how to get the all the project details

[Abilash]

how to pull data from Jira, including project name, project type, owner, and members.

[Staffan Redelius]

Hi @Abilash 

It is not possible to extract that information via a JQL in Jira. There is a pretty extensive REST-api where you can extract a lot of information.

Here is a link to the REST Api's https://developer.atlassian.com/cloud/jira/platform/rest/v3/intro/#about

Best regards,
/Staffan

[Stephen_Lugton]

It depends how you want the information displayed, for example here's a Prompt you can use in Rovo:

Please answer the following 3 questions:

Who is the owner of this space?
What is the project type of this space?
Who are the project members in this space? When answering this question only return active members.

[Martin Runge]

Hi @Abilash

@Staffan Redelius is right, since JQL only searches for issues, you cannot use it to extract project metadata. Here are the three quickest ways to get this data:

• The Quick UI Way for project admins
  Go to View all spaces". This page lists in a table all details that you can highlight and copy-paste directly into a spreadsheet.
  
  

• The REST API Way: To extract everything programmatically, you must combine two endpoints.

  • GET /rest/api/3/project/search?expand=lead
    Which returns project name, type, and owner

  • GET /rest/api/3/project/{projectKey}/role

  Run this for each project to extract the assigned users and groups/members
• You could use marketplace apps like ProjectRak or Scriptrunner, which also offer options.