Sending HTML in the body for custom data from Send Web Request in automation

Ste404
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 5, 2022

Hi there,

I am trying to send some lookupobject results to a confluence page via the Send web request in JSM automation but can't get past a 500 error.

As part of the custom data I have this

"body":{"storage":{"value":
"{{#lookupObjects}}
{{Key}}
{{Name}}
{{Created.format("dd/MM/yyyy")}}
{{Updated.format("dd/MM/yyyy")}}
{{/}}","representation":"storage"}}

 tied in with the rest of the process I end up with a page with that in the body but it is just a massive block of text.
I am not sure how to display this in a table format when sent over to confluence.

 

1 answer

0 votes
Darryl Lee
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 5, 2022

Hi @Ste404 - I think you'll actually need to convert it into Confluence Wiki Markup format which looks like this:

||heading 1||heading 2||heading 3||
|cell A1|cell A2|cell A3|
|cell B1|cell B2|cell B3|

So in your case, something like this might do the trick:

"||Key||Name||Created||Updated||
{{#lookupObjects}}
|{{Key}}|{{Name}}|{{Created.format("dd/MM/yyyy")}}|{{Updated.format("dd/MM/yyyy")}}|
{{/}}"
Ste404
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 5, 2022

Hey @Darryl Lee  I was actually trying that out as I saw something on another site about that.

I don't get the line breaks though, when I tried that out.



"body":{"storage":{"value":
"||Key||Name||Created||Updated||{{#lookupObjects}}|{{Key}}|{{Name}}|{{Created.format("dd/MM/yyyy")}}|{{Updated.format("dd/MM/yyyy")}}|{{/}}","representation":"storage"}}

had me with a mass of text

||Key||Name||Created||Updated|||IEA-1104|LAP-01-APP-2939|05/12/2022|05/12/2022||IEA-1103|LAP-07-APP-4219|05/12/2022|05/12/2022||IEA-1101|LAP-19-APP-0093|05/12/2022|05/12/2022||IEA-1102|LAP-20-APP-1245|05/12/2022|05/12/2022||IEA-1105|LAP-21-TP-2918|05/12/2022|05/12/2022||IEA-1096|LAP-22-APP-2344|05/12/2022|05/12/2022||IEA-1106|LAP-283-APP-2948|05/12/2022|05/12/2022||IEA-1094|LAP-322-APP-4433|05/12/2022|05/12/2022||IEA-1098|LAP-362-APP-3311|05/12/2022|05/12/2022||IEA-1093|LAP-42-APP-3922|05/12/2022|05/12/2022||IEA-1099|LAP-5562-APP-3399|05/12/2022|05/12/2022||IEA-1097|LAP-721-APP-3234|05/12/2022|05/12/2022||IEA-1095|LAP-762-APP-3334|05/12/2022|05/12/2022||IEA-1109|MON-01-E112-1213|05/12/2022|05/12/2022||IEA-1108|MON-01-E229-2775|05/12/2022|05/12/2022||IEA-1107|MON-01-E273-1322|05/12/2022|05/12/2022||IEA-1100|Mon-7712-OO1|05/12/2022|05/12/2022|

Ste404
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 5, 2022

oh..   /n

gives me the breaks I need, but now I just need to wrap it all up in a nice evenly spaced table :)

Muhammet Ayal
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
July 22, 2023

Hey Team, 

I am trying to create a page like this but when I added other info on a page - failed. 

Do you have any idea about the {{#lookupIssues}} table view on wiki page?

 

{
"spaceId": "12345",
"status": "current",
"title": "{{issue.key}} - {{issue.summary}}",
"parentId": "{{webResponse.body.id}}",
"body": {
"representation": "storage",
"value": "<ac:layout><ac:layout-section ac:type=\"fixed-width\" ac:breakout-mode=\"default\"><ac:layout-cell><h2><span style=\"color: rgb(76,154,255);\"> {{issue.summary}} PROJESİ - {{issue.status.name}}</span></h2><p /></ac:layout-cell></ac:layout-section><ac:layout-section ac:type=\"three_equal\" ac:breakout-mode=\"full-width\"><ac:layout-cell><ac:structured-macro ac:name=\"info\" ac:schema-version=\"1\" ac:macro-id=\"f85629f7-c299-4461-ae5c-61beac8367fb\"><ac:rich-text-body><h3>PROJE AMACI</h3><p>{{issue.customfield_10323}}</p></ac:rich-text-body></ac:structured-macro><ac:structured-macro ac:name=\"panel\" ac:schema-version=\"1\" ac:macro-id=\"cf18cdaf-fa3b-430e-aded-ed81cdf20a59\"><ac:parameter ac:name=\"panelIcon\">:note:</ac:parameter><ac:parameter ac:name=\"panelIconId\">atlassian-note</ac:parameter><ac:parameter ac:name=\"bgColor\">#FFFAE6</ac:parameter><ac:rich-text-body><h3>KAZANIM</h3><p>{{issue.customfield_10325}}</p></ac:rich-text-body></ac:structured-macro></ac:layout-cell><ac:layout-cell><p><ac:emoticon ac:name=\"blue-star\" ac:emoji-shortname=\":roller_coaster:\" ac:emoji-id=\"1f3a2\" ac:emoji-fallback=\"🎢\" /> <strong>Tamamlanma Oranı:</strong> {{issue.customfield_10352}}</p><p><strong>SPI:</strong> {{issue.customfield_10357}}</p><h6>SPI= EV/PV &lt; 1 ise kazanılan değer, planladığımız değerin altında kalmış demektir.</h6><hr /><p><ac:emoticon ac:name=\"blue-star\" ac:emoji-shortname=\":heavy_dollar_sign:\" ac:emoji-id=\"1f4b2\" ac:emoji-fallback=\"💲\" /> <strong>Proje B&uuml;t&ccedil;esi:</strong> {{issue.customfield_10336}}</p><p><strong>CPI:</strong> {{issue.customfield_10358}}</p><h6>CPI= EV/AC &lt; 1 ise kazanılanın &uuml;st&uuml;nde bir harcama yaptık demektir.</h6></ac:layout-cell><ac:layout-cell><p><ac:emoticon ac:name=\"blue-star\" ac:emoji-shortname=\":date:\" ac:emoji-id=\"1f4c5\" ac:emoji-fallback=\"📅\" /> <strong>Hedef Başlangı&ccedil; - Bitiş Tarihi: </strong>{{issue.customfield_10035.jiraDate}} - {{issue.Due date.jiraDate}}</p><p /><p><ac:emoticon ac:name=\"blue-star\" ac:emoji-shortname=\":busts_in_silhouette:\" ac:emoji-id=\"1f465\" ac:emoji-fallback=\"👥\" /> <strong>Proje Y&ouml;neticisi: </strong>{{issue.customfield_10332.displayName}}</p><p /><p><ac:emoticon ac:name=\"blue-star\" ac:emoji-shortname=\":gear:\" ac:emoji-id=\"2699\" ac:emoji-fallback=\"⚙️\" /> <strong>İş Modeli: </strong>{{issue.customfield_10333}}</p></ac:layout-cell></ac:layout-section><ac:layout-section ac:type=\"fixed-width\" ac:breakout-mode=\"default\"><ac:layout-cell><h2><span style=\"color: rgb(76,154,255);\">AKSİYONLAR</span></h2><p /><p>||Konu||Statü||Sorumlu||Tarih||
{{#lookupIssues}}
|{{summary}}| {{status.name}} | {{assignee.displayName}} | {{duedate}} |
{{/}} </p><p /></ac:layout-cell></ac:layout-section></ac:layout>"
}
}

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events