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||<br>|cell A1|cell A2|cell A3|<br>|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")}}|
{{/}}"