โ04-19-2022 06:00 AM
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
Solved! Go to Solution.
โ04-21-2022 06:39 AM
Values inside tags like < >, etc
can not be ingested into XML Generator without any customization. By default, those values will be converted to snapLogicโs predefined symbols which can be found in the below 2 links:
Link 1
Link 2
I went with a different route for my development so the concern I was having has been resolved. Instead of passing those values inside < >
(native html tags) inside an XML generator, I defined the html format in mapper/file writer itself so the format took care of the required output. Remember, the file name should be .html (if the use case is to generate html files; the format could be different as per the use case) to see these changes happening.
The suggestions/solution given above on this thread may work, I havenโt tried it and there is another thread discussing the same: Similar Thread_1
Signing off from this thread!
โ04-20-2022 06:27 AM
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]
โ04-20-2022 06:41 AM
Can you send one chunk of the HTML? Link included
โ04-20-2022 07:50 AM
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(>)
โ04-20-2022 07:58 AM
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).
โ04-20-2022 08:33 AM
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