Export large number of records to csv

[Stephen Cawley]

I'm looking for a solution to export a large number of results to a file. We have some automation that needs to check ticket values and the process will currently run a jql and then export all of the results and do its thing. This is fine on-prem where the maxResults is large but the cloud has a lower limit and it takes considerably longer so I'm looking for alternatives to quickly export a large number of records.

I found the link below but that would export all fields where I only need a dozen or so. Is there some other way to quickly export a large number of records to a csv or json file where I can manage which fields are exported via a POST request or GET parameters?

https:///sr/jira.issueviews:searchrequest-csv-all-fields/temp/SearchRequest.xls?jqlQuery=&tempMax=1000&pager/start=1000

Thanks

[Mohamed Benziane]

Hi,

you could try to use google sheet with the jira cloud app https://community.atlassian.com/t5/Jira-articles/How-to-export-more-than-1000-issues-using-Google-Sheets/ba-p/1810436

[Jehan Bhathena]

@Stephen Cawley, I will attest to @Mohamed Benziane , I've used approach at my end too, and using the Google Sheet or Excel plugin is a much easier option since it comes out of the box and has a simple UI to follow along.

[MobilityStream]

Hi @Stephen Cawley

If you don't mind using a Marketplace app, you could use Excel Online Integration and download the issues you need as an Excel/xlsx file. You won't have to configure anything and you can download it directly out of Jira. Give it a try.

Kind regards,

The Mobility Team