Get all projects using Rest API as well as all data releated to that project (project metadata)

Question

Hi there

I am trying to get a list of all projects using Rest API as well as the metadata of each of the projects

I used this: /rest/api/2/project

It doesn't give me back all this information I require such as the date the project was created, the creator, number of issues linked to the project etc.

Can anyone please help in advising how I can get meta data for all projects, instead of running a RestAPI for each project using projectKey or ID

Lesedi Molokomme · Answer

No particular reason, besides the fact that that what I am familiar with. I have some basic SQL knowledge - how would I go about creating a SQL request for your database, I dont even know how to access our DB

Thomas Deiler_db00h3 · Answer

Dear @Lesedi Molokomme ,

unfortunately this is not possible with one call. You have do to this per project.

If you think, the REST API should be extended, then feel free to create a new suggestion at https://jira.atlassian.com

So long

Thomas

Roman Kersky · Answer

HI, why REST API ? Can you try creating a SQL request for your database ?