Answered

Passing HTML content as a variable to build a JSON

(0) Share

Report

Posted on by in2217

143

Dear community, I'm trying to pass a rich text content, effectively HTML text, between flows. First flow gets the content as a formatted text, puts it into a variable and then uses this variable to build a JSON that is then POSTed to another flow via HTTP call. The pseudo code would look like this: set varMyRichText = links > set varMyJSON = { "RichTextVar" : "variables('varMyRichText')"} Now when I look at the content of the varMyJSON it gets all confused because it messes up the quotes found inside original rich text like those that are part of hyperlinks, with the quotes that come around "value" in the JSON. I could probably map all the special chars to their ascii codes in an set of extra steps, but is there any better way to just pass the "rich text" content around? Thank you,

I have the same question (0)

All responses (4)

Answers (1)

v-litu-msft on at

Like (0)

Report

Re: Passing HTML content as a variable to build a JSON

Hi @in2217,

You can store these HTML text stored as an HTML file in a SharePoint folder, then store the link into the JSON object.

There is a document about the portable text, I hope it can help you:

https://github.com/portabletext/portabletext

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
in2217 143 on at

Like (0)

Report

Re: Passing HTML content as a variable to build a JSON

Hi @v-litu-msft,
thank you for the idea. Unfortunately I do not think this will work for me: speed is important and having extra write and read of a file would add to the run time too much.
I already experience delay creating and reading SharePoint list records. Having to make a disk operation where there should a be a simple memory operation is not practical.

The portable text is an interesting idea, would be good to see it implemented.

I'll open another thread to clarify the most efficient way to organize a mass char translation to convert the special html chars into their ascii codes and maybe back.

Thank you

Was this reply helpful? Yes No
Verified answer

in2217 143 on at

Like (4)

Report

Re: Passing HTML content as a variable to build a JSON

Hi,
update with solution here.

Looking closer at what causes the problem, I found that it was only double quote sign ( " ) that ruined JSON as it would collide with the quotes in the syntax of the JSON:
{
"key" : "$value"
}

So I've run the value through "replace" function before adding it to the JSON. Like this:

replace(variables('value'), '"', '"')

(ASCII code for double quote is ")

This was it.
No need to translate it back on receiving end.

I'll remember to translate the double quotes in the rich text / html texts whenever I'll need to pass it over to another flow or otherwise use it inside a JSON.

Was this reply helpful? Yes No
ricoc137 6 on at

Like (0)

Report

Re: Passing HTML content as a variable to build a JSON

@in2217 Hey I was stuck on this problem for days and your replace function method helped me get past that problem although the email body in html that I am converting to JSON for the http post request to work is not being formatted correctly once displayed in Outlook. Wondering if you ran into similar issue and had found any solution?

Thanks,

Was this reply helpful? Yes No