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 ...
expression_language
pipeline
transform
  • 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.

robin's avatar
robin
Former Employee
4 years ago

Yes, though I would consider it “XHTML” (an old term)

darshthakkar's avatar
darshthakkar
Valued Contributor
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.