Forum Discussion

darshthakkar's avatar
darshthakkar
Valued Contributor
4 years ago
Solved

Ingesting dynamic values in XML generator snap

I’ve 10+ columns which needs to go inside an XML generator snap; out of which, there is 1 column which has none to single to multiple values. For each of these records, how can I dynamically pass it ...
  • darshthakkar's avatar
    darshthakkar
    4 years ago

    Thanks @robin, I haven’t had a chance to test the solution you provided but I’m sure it would have worked.
    I went with a different route for my development so the concern I was having has been resolved.

    XML Generator does intake dynamic values if they have been binded properly prior to it (using Aggregate or Group By), the only challenge I found was ingesting native html tags because <a href ="$URL"> wasn’t generating the desired output as the tags gets converted to snapLogic’s predefined symbols like < = &lt;,so on and so forth. Check these links for detailed explanation on tags conversion:

    Link 1
    Link 2

    What I found and worked for me was defining the html format (if you’re trying to generate html files; could be any format you’re interested into) in the mapper itself/file writer and then let the format do its job.

    Thanking @robin for his suggestions, time and help on this. Signing off from this thread.

del's avatar
del
Contributor III
8 years ago
Copy LinkReport

@walkerline117, replace() is case-sensitive, so I’d check the letter casing in your usage since both “UTF-8” and “utf-8” are valid in the XML prolog.

When using the replace() method, I prefer the slash over the single quote so I can add the optional flags. For instance: $xml.replace(/<?xml version="1.0" encoding="UTF-8"?>/i,'') is ignores case and should match either situation. Also $xml.replace(/no data/gi,'') should both ignore case and globally replace throughout the string rather than just replace the first match.

  • darshthakkar's avatar
    darshthakkar
    Valued Contributor
    4 years ago
    Copy Link

    Thanks @robin, I haven’t had a chance to test the solution you provided but I’m sure it would have worked.
    I went with a different route for my development so the concern I was having has been resolved.

    XML Generator does intake dynamic values if they have been binded properly prior to it (using Aggregate or Group By), the only challenge I found was ingesting native html tags because <a href ="$URL"> wasn’t generating the desired output as the tags gets converted to snapLogic’s predefined symbols like < = &lt;,so on and so forth. Check these links for detailed explanation on tags conversion:

    Link 1
    Link 2

    What I found and worked for me was defining the html format (if you’re trying to generate html files; could be any format you’re interested into) in the mapper itself/file writer and then let the format do its job.

    Thanking @robin for his suggestions, time and help on this. Signing off from this thread.