Automating Monthly Velocity Report Extraction with REST API in Jira

Selvam A November 17, 2024

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!image.png

2 answers

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 18, 2024

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
Contributor
November 19, 2024

Thankyou @Bill Sheboy  We will check with this scenario.

 

Regards,

Mohan S

Like Bill Sheboy likes this
0 votes
mohanbabu.s
Contributor
November 17, 2024

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events