JIRA Cloud: schedule a query and download results to Excel

[Adolfo Casari]

I need to automate running a filter and exporting the results to CSV (or Excel). From there a local application opens the CSV to do some processing.

This is for Jira Cloud.

The procedure should take care of renaming or deleting the existing file, change the extension, etc.

Any hints or suggestion on a quick way to implement this? I think curl (or a nodej application) can handle this.

Thanks in advance,

[somethingblue · Accepted solution]

Hi Adolfo,

You may be able to use an add-on such as Automation for Jira to accomplish this behavior.

You can also script this in something such as Python using the Cloud Rest API.  Take a look at the Community post Solved: How can I schedule/automate Excel reports in Jira for some ideas.

In regards to the remainder of the requirments (rename the file, etc) you may need to handle this in your script.

Cheers,

Branden

[Adolfo Casari]

Thanks, that post in the Community helped me to find a solution using Curl.