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.
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
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
this means consolidating about 45 excel sheets?
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
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
Have you read this article? It explains how to do it via API with a few lines of Python code.
It looks like you're new here. Sign in or register to get started.
