How to replicate data presented in sprint "Burn down chart" using APIs

Question

I am trying to get data that is presented in sprint burndown chart table which we can see on the bottom of the relevant burndown chart page for a sprint. I used following end point but it gives mismatching results when I manually compared it with the burndown chart table.

/rest/greenhopper/1.0/rapid/charts/scopechangeburndownchart.json?rapidViewId={__ID1__}&sprintId={__ID2__}&statisticFieldId=field_timeestimate

For the moment I only need the "Estimate time" and "Spent time" per each issue during a given sprint. The top most block and the bottom most block in the burndown chart table. But it is is better if I can scale it up to completely replicate the burndown chart outside of JIRA (you can assume this as our business requirement).

Note: I am not the admin for JIRA and I prefer less interaction with admin personals in this matter if possible

Any help would be highly appreciated, thank you.

Nilupa Rupasinghe · Answer

Hi Nic thank you for the answer. But I have been doing this already using sprint data and issue changelog. This way I am comparing the change log time entry against sprint time period and filter what ever that falls in to a particular sprint. But this is very computationally expensive and time consuming.

And the main problem is that sometimes I see discrepancies too. For example, for certain issues I see in the change log that 4h being recorded for "timespent" but in the "burndownchart" table it shows 8h. But this is happening with issues where there are lot of changes being made or weird things done on them (ex: log the time spent after marking the issue done, etc...). So depending on this, the time shown in the chart will be different. That's why I wanted to see if there is a one place that I can get this same data where it used to generate burndown chart in JIRA. But I suppose there isn't a single place.

Nic Brough -Adaptavist- · Answer

The stuff you see in a burndown chart is all calculated from the issues and sprint data.  So you'll need to fetch that over the REST interface and put together some code to replicate the calculations the chart is doing.