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

[Ste404]

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.

[Darryl Lee]

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]

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]

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 _Involit_]

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>"
}
}