How to get raw data of burn-up chart?

Question

1/ Context: Care team want to get raw data of Burnup chart for self-visualization and high-level report (divided by workspace -> board (team) -> sprint)

Path example: Spaces -> Care Application -> CA JUPITER Board -> Reports

Possible solution:

- Direct: Get API of this report from Jira team

- In-direct:
+ Show Care team on logic how to mapping Jira API tables to come-up with this raw data so Care team can work around
+ Crawl / extract data of this report

Danut M _StonikByte_ · Answer

Hi @Chau Tran,

On Cloud, the raw data of the Burnup Report is not exposed via the REST API. As an alternative, you can retrieve the issues along with their fields from a sprint by using the search REST API endpoint with a JQL query such as Sprint = "My Sprint". You can then process the returned issues as needed. However, please note that this approach might not include issues that were part of the sprint but were removed after the sprint started, so the data may be incomplete. Also, you might need to parse their history (changelogs) in order to determine the issue states along the time interval.

A simpler alternative would be to search for an app (plugin) on Atlassian Marketplace that exposes the burnup chart data for you.  In case you want to try a plugin, I would recommend taking a look over Great Gadgets - an app developed by my team. It offers a Sprint Burndown Burnup Chart gadget that can also display the sprint data, which can be exported in CSV for further processing.

In addition, this plugin includes a Pivot Table & Pivot Chart gadget that would allow your teams to easily create all kind of statistics based on space (project), team or other fields in form of pivot tables, heatmap table or charts of various types directly in Jira without data export. Here is an example:

Hope this helps.

Danut.

Benjamin_tmh9yg · Answer

Hi @Chau Tran

Might be simpler to use enrich connectors to do the job. There some in the market place that are doing similar things. I would start with the Atlassian marketplace.

Here's one pulled from the marketplace for example:

https://marketplace.atlassian.com/apps/1221150/power-bi-connector-for-jira?tab=overview&hosting=cloud&utm_source=google&utm_medium=cpc&utm_campaign=sn_pbi_jira_us&utm_vendorID=1216274&utm_term=jira%20connector%20power%20bi&hsa_acc=5924481196&hsa_cam=17859100276&hsa_grp=137284966537&hsa_ad=620326695334&hsa_src=g&hsa_tgt=kwd-859082020731&hsa_kw=jira%20connector%20power%20bi&hsa_mt=e&hsa_net=adwords&hsa_ver=3&gad_source=1&gad_campaignid=17859100276&gbraid=0AAAAABHw1gfSsIPjbY3B1fwTKHuDWuDgb&gclid=CjwKCAjwvqjOBhAGEiwAngeQnZmz2bA-FCuZfjnP2IONE-v89ZN1UqofMRIFxgIuAEsiKpydLvFvnxoCIucQAvD_BwE

-Ben