Export jira issues for jql in excel using Automation rule or rest api

[shahjad ahemad]

How we can export jql search result in excel sheet using automation rule or rest api. 

[Aron Gombas _Midori_]

Use the Better Excel Automation for Jira app.

It introduces 3 new automation actions that you can add to your automation rules:

1. Send Excel (you will need this one for emailing!)
2. Save Excel 
3. Attach Excel

In the shot below, you can see a rule that is executed periodically, runs a JQL search, then exports the results to an Excel spreadsheet (.xlsx) and emails to multiple recipients ("To" and "Cc" as well).

[Boris Berenberg - Modus Create]

We natively support generating a CSV export of JQL results and emailing it (https://atlasauthority.atlassian.net/wiki/spaces/NAFJC/pages/2264072590/How+To+Set+Up+Notifications?src=search#Exporting-Issues-as-CSV) in Notification Assistant for Jira.

[Alex Koxaras _Relational_]

Hi @shahjad ahemad 

You can read this post about exporting the issues with REST API: https://community.atlassian.com/t5/Jira-questions/How-to-get-all-issues-in-jira-using-rest-api/qaq-p/826281

[shahjad ahemad]

Hi @Alex Koxaras _Relational_ 

How I can export the JQL reason. in the above link I don't see anything how they exported the data in excel. I'm able to run JQL query using rest api but don't how I can export those results in excel.. Please help me.

[Alex Koxaras _Relational_]

First of all, I've got a question: Why you don't use the export functionality that Jira provides? https://support.atlassian.com/jira-cloud-administration/docs/export-issues/

[shahjad ahemad]

Because we are creating JQL using rest api and we want to publish the excel sheet to user on email. 

[shahjad ahemad]

let us know if there are any solution possible to export JQL using rest Api.

[Alex Koxaras _Relational_]

Read this then https://community.atlassian.com/t5/Jira-articles/How-to-export-all-issues-from-Jira-via-API/ba-p/2126063