Can anyone help with exporting all the projects listed under my site?

[Mahesh Gupta]

I'm trying to pull a CSV file with the dump of all projects listed under my site, however, I'm not certain of how to proceed further.

Any help on this would be appriciated!!!

[fran garcia gomera]

with API  (returns a JSON)

yourjira.com/api/latest/project

with DB

SELECT * FROM project;

[Mahesh Gupta]

This isn't working.

[fran garcia gomera]

Do you get an error? no data are received? have you tried both?

[Mahesh Gupta]

I've received project details except for Project lead data.

[fran garcia gomera]

in the API you should add parameter expand=lead

{{url}}/project?expand=lead

In the DB the table project has a field named LEAD with the username of the project lead

[Hernan Halabi - Elite IT Consulting Group]

Check this link, it should help you to export to csv.

I would do this while running queries for each project, like project = XYZ and then export that project to a csv