Passing values containing < > in XML generator with "Escape special characters" turned ON

[darshthakkar]

Hi,

I’ve some fields containing < > (html tags) that needs to go into XML generator and provide desired output however the fields come in as a raw string and doesn’t do it’s work as “Escape special characters” in XML generator has been turned ON. If this option is turned off, the pipeline doesn’t even run.

Any workaround on how to ingest <> in XML generator with the pipeline running as well?
Thanks!

Best Regards,
DT

[darshthakkar]

That’s exactly what I’ve done but when this URL goes into XML generator, it prints the same ‘<a href’ instead of displaying it as a link [snap below for reference]

[bojanvelevski]

Can you send one chunk of the HTML? Link included

[darshthakkar]

Thank you @bojanvelevski for offering your help.
Attaching a normal .txt file whose contents goes into “Edit XML” under XML generator.

editXMLContent.txt (182 Bytes)

The file fetches some values, which are the columns from previous mapper snap (e.g. htmlBody1, htmlBody2, etc. would be column values and the last htmlBody4 is the URL in the format left angular bracket(<) *a href = https://www.google.com>*Link_1</a right angular bracket(>)

[bojanvelevski]

Try double quoting the url like I mentioned before:

<a href="$URL">Click me</a>

As I can see, you’re referencing the incoming field without quotations, that’s why it is not treated as a proper attribute (href).

[darshthakkar]

I tried opening the final html file in notepad++ while I was testing the solution and what I found was that the tags get converted to predefined snapLogic letters like the one seen in the link below:

Link 1: https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1439280/XML+Generator
Link 2: The XML FAQ: What are the special characters in XML?

Moreover, putting double quotes in

<a href = >

is challenging too as the URL intakes some variables too, so you may consider the URL to be

https://www.google.Name.ID.com