Export issue results in bulk

[Anna Queen]

Hi, I am aware that I could export 1000 search results at a time, but I am looking to export more than 44k worth of rows and I was hoping that there's a better way of doing this.

[Marc - Devoteam · Accepted solution]

Hi @Anna Queen 

As you mention, you know how to export more then a 1000 issues at a time.

Currently there is no other option, as this is the limit of the API.

You could look at 3rd party apps then can export this information.

Or if you use Google Sheets, try the following, https://workspace.google.com/marketplace/app/jira_cloud_for_sheets/1065669263016 

[Jim Knepley - ReleaseTEAM]

Hi @Anna Queen 

You'll have to retrieve the list of issues in batches. Your program will repeatedly call the API, asking for the next batch until all of the records have been received.

Asking AI to knock out a Python script to do this turned out an OK foundation for a script that you might be able to adapt for your exact needs:

https://pastebin.com/X8jArK5c

[Prince Nyeche]

Have you read this article? It explains how to do it via API with a few lines of Python code.

[Aaron Pavez _ServiceRocket_]

Hi @Anna Queen 

You will need to either use a plugin for that or this workaround:

https://confluence.atlassian.com/jirakb/export-over-1000-results-to-excel-from-jira-cloud-779160833.html

Regards

[Anna Queen]

this means consolidating about 45 excel sheets?

[Aaron Pavez _ServiceRocket_]

Yes. since the limit is 1000.

But the other options mentioned are really good. Ill test the script @Jim Knepley - ReleaseTEAM shared. looks pretty good.

regards