How to design automation body

[Thibault d_Arexy]

Hi everybody

I'm trying to automate my published version released note on a confluence space with automation of Atlasian

I sucess to create the page with the list of ticket jeys but it's not really friendly

I can't mix smart values and html text to show datas on a html datatable

How should i parameter it ?

Thanks a lot !

The body and the parameter :

{{#lookupIssues}} {{key}} {{customfield_10081}} {{customfield_10082}} | {{/}}

[Marc - Devoteam]

Hi @Thibault d_Arexy 

Welcome to the community.

Check this previous post: https://community.atlassian.com/forums/Confluence-questions/How-can-i-create-a-new-page-from-a-users-template-using-rest-api/qaq-p/1059884

Also, can you provide:

1. images that show your complete rule.

2. images showing the details of any relevant actions/conditions/branches.

3. images showing the Audit Log details for the rule execution.

4. Explain where the issue is.

These questions are not for not willing to help, but to have community members understand on how automation works.

Or even check this free marketplace app; Free:(AI powered) Automated Release Notes & Reports for Jira

[Thibault d_Arexy]

Hi Marc,

here are my screen

The result was

there is not error logged, but if i tried to combine HTML and Smart values i get this one

for this kind of body set:

I expect a confluence page, with a table of the list of keys in lookupissues

[Marc - Devoteam]

Hi @Thibault d_Arexy 

This can only be done by using the Confluence API and web request action in the automation.

Here's a breakdown of the process:

1. Set up the Jira Automation Rule
2. Add the "Send web request" action
   
   Select the "Send web request" action.
   Web request URL: Construct the Confluence REST API endpoint for creating pages.
   
   The URL will be similar to this:
   https://your-confluence-instance.com/rest/api/content.
   
   Headers:
   Add a "Content-Type" header with the value application/json.
   Add an "Authorization" header with the appropriate authentication (e.g., using a personal access token or username/password).
   Body: This is where you'll define the JSON payload to create the page and table.
   
   
3. Construct the JSON Payload:
   
   The JSON payload will include the page title, space key, and the page content in Confluence Storage Format (which supports tables).
   
   Here's a basic example (adapt this to your specific needs):
   
   Code
   
   {
       "space": {
           "key": "YOUR_SPACE_KEY"
   },
   "title": "{{issue.key}}: {{issue.summary}}",
   "type": "page",
   "body": {
      "storage": {
           "value": "<ac:layout><ac:layout-section ac:type=\"two-equal\">.                         <ac:layout-cell>\n<h1>{{issue.key}}: {{issue.summary}}</h1>\n\n<p>
            This page was created automatically from Jira.</p>\n\n
            <table class=\"wrapped\">\n <tbody>\n <tr>\n <th>Field</th>\n
            <th>Value</th>\n </tr>\n <tr>\n <td>Priority</td>\n <td>
           {{issue.priority}}. </td>\n </tr>\n <tr>\n <td>Status</td>\n <td>. 
          {{issue.status}}</td>\n </tr>\n <tr>\n <td>Assignee</td>\n <td>. 
          {{issue.assignee}}</td>\n </tr>\n </tbody>\n</table>\n</ac:layout-cell>. 
          <ac:layout-cell>\n<p>Additional information can go here.
          </p>\n</ac:layout-cell></ac:layout-section></ac:layout>",
       "representation": "storage"
       }
     }
   }
   
   This JSON creates a page with:
   
   A title using Jira issue key and summary.
   A two-column layout with a table.
   The table includes the issue's priority, status, and assignee.
   The {{issue.key}}, {{issue.summary}}, etc., are smart values that will be replaced with actual issue data.
   The table is created using Confluence Storage Format.
   
   You can customize the table structure and content by modifying the <ac:layout> and <table> tags.
4. Save and test:

[Sujeet Pathak]

Hi @Marc - Devoteam , thanks for the mention of our app - Free:(AI powered) Automated Release Notes & Reports for Jira

@Thibault d_Arexy , do let me know if you want to explore this app and want a quick demo. Our app contains a very strong and deep integration with Confluence which helps you to create release notes and reports using different layouts of your choice such as table, free layout, that too directly within the confluence page. The powerful rule engine lets you automate to create new confluence pages, append/prepend content to existing page, generate release notes summary using AI and much more. 

Best,
Sujeet