How to design automation body

Question

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}} | {{/}}

Sujeet Pathak - Amoeboids · Answer

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

Marc -Devoteam- · Answer

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: * Set up the Jira Automation Rule * 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. * 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": "

.

{{issue.key}}: {{issue.summary}}

This page was created automatically from Jira.

Field	Value
Priority	{{issue.priority}}.
Status	. {{issue.status}}
Assignee	. {{issue.assignee}}

.

Additional information can go here.

", "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 and tags. * Save and test:

Thibault d'Arexy · Answer

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