Automating Monthly Velocity Report Extraction with REST API in Jira

Question

Hello Community,

We currently extract velocity reports manually each month, including data for the last three sprints. The columns we need are: Sprint Name, Committed Story Points, Completed Story Points, Sprint Start Date, and Sprint End Date.

Is there a way to automate this process? If possible, could someone share a REST API script or any other method to simplify this task?

Thank you for any assistance!

mohanbabu.s · Answer

Thankyou @Bill Sheboy  We will check with this scenario.

Regards,

Mohan S

Bill Sheboy · Answer

Hi @Selvam A

I do not believe there is a current, public REST API endpoint to get that information.  There is a very old Jira Greenhopper one, and that is likely deprecated, so I would not recommend using it.

Instead, perhaps consider a workaround using automation rules and entity properties:

* Create a rule triggered on Sprint Started which adds an entity properties to the sprint for the total committed count, total committed story points, etc.
* Create a rule triggered on Sprint Completed which adds entity properties to the sprint for the total completed count, total completed story points, etc.
* Create a rule with a Scheduled trigger for reporting needs, which uses the Send Web Request action to call the REST API endpoints to gather the sprints you want to report upon, and then additional REST API calls to get their entity properties for the report.

Another approach is to investigate marketplace apps which can report this information.

Kind regards,
Bill

mohanbabu.s · Answer

Hi All,

Along with the above request, we need to auto-export and email the data only monthly or weekly.

Please help us with an solution.

Regards,

Mohan S