Get total story points completed in a sprint using rest api or sql in Jira DB

Bernardo Paroli

Can anyone help me to get the Story points completed in a specific sprint?

We usually connect directly to the rest api or database (mysql) to feed this kind of info into other management tools in the company.

I don´t mind programming something that has to traverse every issue in the sprint or whatever, but i just kind find out how JIRA knows that issue with that SP estimate was completed in that sprint.

The data can be viewed in JIRA in the velocity report, but examining SQLs logs doesn´t tell much.

Regards,

Sebastian

Eric Franklin_d8jeul

Hey Sebastian,

There's an older post covering this that I believe is still relevant:

https://community.atlassian.com/t5/Answers-Developer-Questions/Is-there-a-Greenhopper-REST-API-for-accessing-story-points-for-a/qaq-p/562639

 

First you need to get the rapidview ID for the that sprint, do this here are steps:

1. Run /rest/greenhopper/1.0/rapidview to get list of rapid views with the IDs.
2. After you get the rapid view ID, you will need to get list of sprints in that rapid view by running/rest/greenhopper/1.0/sprints/{rapidViewId}
3. After obtaining the Sprint ID, you can run /rest/greenhopper/1.0/rapid/charts/sprintreport?rapidViewId={rapidViewId}&sprintId={sprintID} to get list of issues for that sprint.

 

ANd once you have all the issues completed you can sum the total story points, hours logged, or any other data you are interested in.

A later post mentions /sprint being deprecated and being replaced by /sprintquery but based on the recent api docs, I believe /sprint is still applicable. I could be wrong though. Let me know if this helps (I know that post is really old but I think the answer is still accurate).