Export filter output to CSV file automatically using JQL.

[Haran Kumar]

Hi ,

I have a filter which schedules output once in a day. I have subscribed to this filter and get notified by mail. My question is can,  I get the csv file of the filter output exported directly (automatically)  to my mail , by using JQL. (without using plugin)
I use Jira software cloud.


Thanks in Advance.

[Tom Lister · Accepted solution]

Hi

there is a rest api to search for issues

https://developer.atlassian.com/server/jira/platform/jira-rest-api-examples/#searching-for-issues-examples

It returns json

maybe with a bit of scripting and a Json-formatter you could get it to work

[Jack Brickey]

yes for sure you could code something up for this.

[Haran Kumar]

Hi Tom, 
Though I'm not a programmer , I shall look up  & try to find some scripting to solve this issue. Thank you Tom , as well as Jack.

[Aron Gombas _Midori_]

You can export Jira issues from a JQL search to Excel using the Better Excel Automation for Jira app. It is super flexible, as it relies on standard Jira Cloud Automation rules to implement this automation.

As result you will receive the exported file attached to a customizable email:

(Exporting to Excel, XLSX files to be precise, is much better than the plain-text CSV format which suffers from well known problems like encoding, data has no types, and so on.)

Your automation rule:

• should use the Scheduled trigger and run the CQL
• should use generate the Excel spreadsheet and email that to the recipient (To, Cc, Bcc supported!)

Follow the precise step-by-step guide to implement this rule. (Video version will be published in the next few days!)

(Discl. this app is developed and supported by our team.)

[Jack Brickey]

There is t a way to do this at least OOTB. You can check for an addon in the Marketplace. For example, maybe EasyBI could do this but not sure.

[Zane eazyBI Support]

Thank you @Jack Brickey for the suggestion! However, I believe, some other tool or solution would be more suitable to get JQL results on mail as CSV fail.

eazyBI is a tool for data analyzes and oriented on data usage and publishing in the application, not for data preparation for downloadable files.

On regular bases, users can receive eazyBI reports in their emails as well, but those reports are prepared in PDF format. More information on email subscription you will find in eazyBI documentation: https://docs.eazybi.com/eazybijira/publish-reports/create-dashboards#CreateDashboards-Dashboardemailsubscription

Best,
Zane / support@eazyBI.com