How can I automatically display a Jira burndown chart and sprint report in Confluence?

[Jim Tailor]

I’m creating a Confluence page to keep stakeholders informed about our development progress. I’d like to automatically embed a Jira burndown chart and sprint report into the page instead of manually recreating or updating them each time.

Is there a way to make this process automated or at least achievable in a single action so the data stays up to date?

[Marc -Devoteam-]

HI @Jim Tailor 

Welcome to the community.

This could be done by creating a template on the Confluence space.

You would need to get the content of an empty Confluence page based on this template

The remaining issue is that you would still need to update the related macros, based on the Sprint name/ID.

Based on automation, you could then create a new page, when closing the sprint. You would have to do this via an API call (web request action in automation)

You would first need to create a variable that stores the sprint name or ID, then based on the JSON of the template confluence page, do a web request action, in that action the full content of the page should be in the post of the web request, using the variable in this content, where the macro's are used for the burndown and sprint report so it places the name or id of the sprint in these macro's.

Its a very technological solution, to achieve this, but it can be done via automation.