Get all historical issues with REST API.

[Daniel Pardo Espinoza]

Hi there, 

I´m an intern and I´m doing a project in which I need to download all the issues from JIRA using REST API, I want to know if there is a way to get all the historical issues. I was able to pull out the issues of the active sprint, but I want to know if there is a way to get the data from all the sprints that we had. Also, with the data I want to create a dashboard on Tableau, can anyone give me an idea of how to get the data to Tableau or anyone haves a suggestion of how should I do it. Also, do I need any extension or other software to prepare the data?. 

I will be very grateful if anyone can help me.

Thanks,

Daniel.

[Darryl Lee]

Hi - the easiest way to get Jira data into Tableau is to use an add-on, of which there are many:

• Tableau Connector Pro for Jira 
• Tableau for Confluence - Pro 
• Tableau Connector for Jira
• Top Tableau Connector 

But none of those are free.

As far as downloading "all the issues from JIRA using REST API", this will include historical issues, but you would want to make sure to FILTER issues based on a particular project or board, because getting all the issues would take a long time.

If this is a one-time project you are working on, then you might consider exporting the issues you are looking for as CSV, and then importing that into Tableau.

Here's some documentation about that:

https://confluence.atlassian.com/jirasoftwareserver/working-with-search-results-939938808.html#Workingwithsearchresults-Exportingyoursearchresults

https://help.tableau.com/current/pro/desktop/en-us/examples_text.htm