• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Login
  • Automation Institute
  • Documentation
  • Community Forums
New Topic
Discussions Recipe Building Formula Mode Questions
S

Saul Macht

started a topic almost 5 years ago
Answered

Decode HTML encoded string

We have the need to be able to decode html encoded responses.  Are there any options within the SDK (library) or option within the Recipe Pills to do decoding of content?


Best Answer
A
Amanda Wong said almost 5 years ago

Hi Saul, 


While we do not have a direct formula to decode HTML encoded strings, you may use .gsub to achieve the same result.


Example:


[Data pill] contains:


Using formula: 


Data output:


You can take a look at this recipe example here: https://www.workato.com/recipes/694839-html-decoding?st=2739f4#recipe


The recipe example includes the following characters:


CharacterEntity nameDescription
""quotation mark

'apostrophe
&&ampersand
<&lt;less-than
>&gt;greater-than

&nbsp;non-breaking space
¡&iexcl;inverted exclamation mark
¢&cent;cent
£&pound;pound
¤&curren;currency
¥&yen;yen
¦&brvbar;broken vertical bar
§&sect;section
¨&uml;spacing diaeresis
©&copy;copyright
ª&ordf;feminine ordinal indicator
«&laquo;angle quotation mark (left)
¬&not;negation

&shy;soft hyphen
®&reg;registered trademark
¯&macr;spacing macron
°&deg;degree
±&plusmn;plus-or-minus
²&sup2;superscript 2
³&sup3;superscript 3
´&acute;spacing acute
µ&micro;micro
¶&para;paragraph
·&middot;middle dot
¸&cedil;spacing cedilla
¹&sup1;superscript 1
º&ordm;masculine ordinal indicator
»&raquo;angle quotation mark (right)
¼&frac14;fraction 1/4
½&frac12;fraction 1/2
¾&frac34;fraction 3/4
¿&iquest;inverted question mark
×&times;multiplication
÷&divide;division


Answer

Amanda Wong

said almost 5 years ago

Hi Saul, 


While we do not have a direct formula to decode HTML encoded strings, you may use .gsub to achieve the same result.


Example:


[Data pill] contains:


Using formula: 


Data output:


You can take a look at this recipe example here: https://www.workato.com/recipes/694839-html-decoding?st=2739f4#recipe


The recipe example includes the following characters:


CharacterEntity nameDescription
"&quot;quotation mark

&apos;apostrophe
&&amp;ampersand
<&lt;less-than
>&gt;greater-than

&nbsp;non-breaking space
¡&iexcl;inverted exclamation mark
¢&cent;cent
£&pound;pound
¤&curren;currency
¥&yen;yen
¦&brvbar;broken vertical bar
§&sect;section
¨&uml;spacing diaeresis
©&copy;copyright
ª&ordf;feminine ordinal indicator
«&laquo;angle quotation mark (left)
¬&not;negation

&shy;soft hyphen
®&reg;registered trademark
¯&macr;spacing macron
°&deg;degree
±&plusmn;plus-or-minus
²&sup2;superscript 2
³&sup3;superscript 3
´&acute;spacing acute
µ&micro;micro
¶&para;paragraph
·&middot;middle dot
¸&cedil;spacing cedilla
¹&sup1;superscript 1
º&ordm;masculine ordinal indicator
»&raquo;angle quotation mark (right)
¼&frac14;fraction 1/4
½&frac12;fraction 1/2
¾&frac34;fraction 3/4
¿&iquest;inverted question mark
×&times;multiplication
÷&divide;division


Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2022   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato
Topic views count