JIRA Dash board API

Question

I'm looking to extract dashboard data in the form of XML/JSON from JIRA and insert it into a database, which will then be used by the customer to generate BI reports. Has anyone worked on a similar integration? Are there any official documents or references that explain how to identify and use the appropriate JIRA REST APIs (XML/JSON) for extracting dashboard data?

Stefan Salzl · Answer

Hi @Pankaj Sharadchandra Kolapkar - welcome to the community,

I would just like to fully agree to @Shreeja J .

Did that several times at customers. Basically the data for Jira Dashboards are Issues (mainly). The best and most efficient way to visualize data outside of Jira is a eg. JSON strem via api and BI-/Data engineers will do the rest to produce the requested data.

Best
Stefan

Shreeja J_th8z0r · Answer

Hello @Pankaj Sharadchandra Kolapkar Welcome to the community!

You can’t extract the whole Jira dashboard directly as XML/JSON, since dashboards are mainly a UI layer. Instead, you can use Jira REST APIs (such as search, project, or filter APIs) to pull the data behind the dashboard gadgets, load it into your database and then generate BI reports from there.

Thanks,
Shreeja