How to auto update a confluence page depending Jira custom field

Question

Hello

Here my needs :

- at the end of the sprint, I want to auto update a confluence page (always the same) with some informations present on Jira, and depending about some conditions

the SQL condition will be : project = "Ecommerce (SFRA)" and sprint in openSprints() and "Configuration ?" = oui ("Configuration ?" is a custom field, ID 15002).

I want to report IssueKey, Summary and content in a custom fiel "Quelle config ?" (ID 15004)

The page on confluence will be like

Sprint X (actual)

IssueKey#1234 - Summary - Quelle config ?

IssueKey#1236 - Summary - Quelle config ?

IssueKey#123 - Summary - Quelle config ?

Sprint X-1 (previous sprint)

IssueKey#114 - Summary - Quelle config ?

IssueKey#102 - Summary - Quelle config ?

Sprint X-2 (anterious sprint)

No need configuration (no issue trigger the rules)

Sprint X-3

...

Is it possible ? I'm a newby on dev, I don't mastering REST API (but I can learn). I've scriptrunner on Jira side (but don't think I have it for confluence), and Automation on Jira side (but I can't modify a confluence page with it)

Thanks for your help

cendre · Answer

Hello Katerina

Thank for your answer

For the moment, I'm looking for a free solution (context not help us to buy new solution)

Regards

Katerina Kovriga _Stiltsoft_ · Answer

Hi @cendre ,

We can suggest trying our app - Table Filter and Charts for Confluence. Maybe it has been already installed for your instance.

The plugin and its Table Filter, Pivot Table and Chart from Table macros work with the Jira Issues macro perfectly well and allow you to create Jira reports and visualized dashboards right in Confluence (using a friendly UI, not REST API).

Here you can find several use cases with step-by-step guides how to achieve the result.