Unanswered

Converting email body to valid json

(0) Share

Report

Posted on by CU23110706-0

Hello,
I would like to send the body content of an e-mail (HTML or txt) as a Json via HTTP request to one of our web servers for further processing. The body of the HTTP request should look like this: {"Data": "Body of the email"}. The problem is that the email body may contain characters that invalidate the Json. The content of the e-mail is always different. There is no fixed pattern. Can anyone give me a tip on the best way to solve this problem?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

VictorIvanidze 13,081 on at

Like (0)

Report
Copy link

Link copied!

Hello,

see https://stackoverflow.com/questions/57431335/how-to-escape-quotes-in-json-within-microsoft-flow

Was this reply helpful? Yes No
CU23110706-0 4 on at

Like (0)

Report
Copy link

Link copied!

@VictorIvanidze
Ok. Thanks for the link. My conclusion from thread in stack overflow is that I have to escape the double quote and backslash character. I hope that only these these two characters breaks the json syntax. This json is accepted:

{
"test": "#$%&'()*+,-./:;<=>?@[]^_`{|}~¡¢£¤¥§¨©ª«¬®¯°±²³´µ¶·¸¹º»¼½¾¿ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõö÷øùúûüýþÿ\"\\"
}

The double quote an backslash at the end are escaped.

Was this reply helpful? Yes No