Request for Guidance on JIRA API for Burn Chart Data Extraction

[Nandhini Vijayakumar]

Hi Team,

We are currently developing a dashboard in Qlik Sense and need to extract data from the burn chart using the JIRA API. This data will populate the velocity report, including metrics such as committed, completed, and scope change, on the dashboard.

Could you please guide us on how to retrieve the burn chart data through the JIRA API?

Thank you!

[Martins Vanags_eazyBI]

HI Nandini,

I am Martins from the eazyBI support team.

If you consider using third-party Jira apps, eazyBI imports issue change history, which helps you create reports with the sprint scope change

See one report example here:

https://eazybi.com/accounts/1000/cubes/Issues/reports/243468-sprint-issue-balance

You can read more about "sprint scope measures" on the eazyBI documentation page.

It also has an API that maybe can be useful to extract the sprint data on committed, completed etc. issues for your current dashboard:

https://docs.eazybi.com/eazybi/set-up-and-administer/customization/report-results-export-api

Martins / eazyBI team

[Marc - Devoteam]

Hi @Nandhini Vijayakumar 

This would require you to search all issues related to the burn down chart.

You then will have all issues, and you will need to do the calculations in Qlik Sense

Reports are not accessible via the API.

[Nandhini Vijayakumar]

Got it, Marc. Do we have any options for calculating the committed story points at the sprint start?

[Marc - Devoteam]

HI @Nandhini Vijayakumar 

Committed Story Points is a value that Jira calculates when a sprint is started by looking at the Story Points field of the standard issues in your sprint, but it is not stored in a field that you can export.

You would need to export the issues in your sprint, including the Story Points values, right at the beginning of your sprint. 

Or pull the information using Automation that triggers at the Start of each sprint, and save the information elsewhere using Send Email or another output option.

[Nandhini Vijayakumar]

Thank you, Marc

[Marc - Devoteam]

Please accept my answer as a solution, if my answer helped to solve your request.

This will help other community member trying to solve the same.

[SO MATTHEW CHRISTIAN SUTIKNO]

Hi Mark, i am also trying to build a custom dashboard for project monitoring, and it uses burn down chart data, im trying to fetch burndown chart data but it seems building the data itself requires complex calculation , i need the issues count as the y-axis, 

let me know if you have any solution, thankyou