Field content post into a report in Confluence [Jira Automation]

Question

Hello, everybody;

I would like to get your input/suggestions; if maybe you know an easier/better way with the built-in features.

In our instance we have a custom field and some automation rules to populate it counting Overdue days.

Now, we are trying to sum up all the overdue days values (within a variable with this smartvalue: {{lookupIssues.customfield_Overdue Days.sum}} ) to then post it in a Confluence existing page, through a Jira Automation rule.

However, I am not very experienced with Confluence Cloud's API and since it seems it is moving to V2 I am unsure on the request syntax, and other details.

This is what I have so far; it's a little messed up because no matter what I try, it always fails with different HTTP error messages.

The GET was to try to get the rule to fetch the page version number and update it automatically before the PUT but I couln't find how to.

Lukas Nicolai_Seibert · Answer

Hey @Christian Isaza if using a third-party app is an option, I recommend AutoPage. It allows you to automatically create Confluence pages from Jira issues based on predefined triggers (e.g., issue status changes).

These Confluence pages are automatically populated with relevant data from Jira issues that you want to display.

https://marketplace.atlassian.com/apps/1218503?tab=overview&hosting=cloud

Hope that helps!

Christian Isaza · Answer

Hello, Bill. Thank you so much for your input.

Bill Sheboy · Answer

Hi @Christian Isaza

Updating Confluence pages from rules can be challenging to get the format correct.

I recommend first hardcoding your numbers / values in the JSON to confirm you have the format correct.  Then update to use your dynamic fields.

For example...

* Your rule uses the smart value {{newVersion}} and that is not defined by the rule.  This would try to put null in the the "version", and so fail.
* The HTML you are sending needs to be JSON encoded for the call data.  I recommend saving the expression you have in the body's "value" in a created variable, perhaps named varBodyValue.  Then in the JSON, use this: {{varBodyValue.jsonEncode}}

Kind regards,
Bill