How can we get data of Velocity Chart from Jira?

[Meet Lalpurwala]

In Jira's report section, It displays Velocity Chart. We want to extract the data from that chart and store it in our database. How can we fetch Velocity Chart data from Jira? Currently, We fetch data from Jira but It does not contain data from Velocity Chart.  

[Bill Sheboy]

Hi @Meet Lalpurwala -- Welcome to the Atlassian Community!

Although there are old, internal REST API functions to get some of the sprint reports, those could be removed at any time and so should not be relied upon.

Instead, consider using the supported REST API functions or automation rules (with sprint triggers) to gather this information.  Here are some references to help do that:

https://developer.atlassian.com/cloud/jira/software/rest/api-group-sprint/#api-group-sprint

https://support.atlassian.com/cloud-automation/docs/jira-automation-triggers/#Sprint-created--started--or-completed

Kind regards,
Bill

[Meet Lalpurwala]

Thanks for the reply @Bill Sheboy  But this is not what we are looking for.

As you can be in the below screenshot, Jira shows us the Velocity report under the Report section. We want to create a similar report in our BI tool. Our requirement is to fetch data shown in the attached screenshot like Complete, Commitment, and sprint. Is there any possible way to directly fetch this data?

[Bill Sheboy]

I do not believe that is possible in the format it is shown on the built-in velocity report, and with the public methods.

Instead you could call the REST API to gather the issues in a sprint and then parse their sprint, status, and resolved fields to determine the counts by sprint within your BI tool.

[Meet Lalpurwala]

@Bill Sheboy , Thanks for the reply. Do you know if Jira has any plans to include sprint report-related data in newer APIs? and also does JIRA have mentioned any date to sunset old APIs?

[Bill Sheboy]

Hi @Meet Lalpurwala 

I do not have access to that information, and I suspect the answer is "no".  There is a suggestion to add some of sprint tracking to the latest REST API since the Greenhopper ones are sunset: https://jira.atlassian.com/browse/JSWCLOUD-16390

You could try posting this as a question in the developer community to see if Atlassian responds in that forum: https://community.developer.atlassian.com/

[Syamnath Reghunath]

@Meet Lalpurwala  @Bill Sheboy  We have a similar task to create a BI report on Historical Velocity Chart data - Committed vs Completed Story Points. @Meet Lalpurwala  I hope you had successfully implemented this. Kindly share your inputs. Thanks

[Bill Sheboy]

Hi @Syamnath Reghunath -- Welcome to the Atlassian Community!

As this is an older thread, I recommend creating a new question and linking to this one.  That will ensure more people see it to offer suggestions.

In the interim, I have no additional suggestions beyond what I already provided, and I am not using any specific BI reporting tools to do so.

Kind regards,
Bill