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 to XML generator snap?

These values can be considered as web links that needs to be wrapped as a hyperlink and a title needs to be given (probably in XML generator as it’s dynamic); title is based on the weblink as the weblink has been formed with the concatenation of certain fields that will be used as a title.

For example, weblink is https://www.google.100snapLogic.com, title would be 100.snapLogic
Just for everyone’s convenience, weblinks are different for each record and you guessed it right, title would be different too.

100 and snapLogic used in the weblink are values of different cols and we do have access to those column values.

expression_language
pipeline
transform

5 Replies

  • robin's avatar
    robin
    Former Employee
    4 years ago

    @darshthakkar you can use the Apace Velocity support that is available within the Generator Snaps, for example

    for the following input JSON (e.g. JSON Generator) that:

    • includes two fields (msg1, msg2) that are intended to be combined into one output XML element
    • a vary field that could be either null, contain a single String value, or a list of string values
    [
    {
        "msg1" : "Hello", "msg2":"World", "num" : 1, "vary": null
    },
    {
        "msg1" : "Hi", "msg2":"World", "num" : 2, "vary": "b"
    },
    {
        "msg1" : "Hey", "msg2":"World", "num" : 3, "vary": ["b", "c"]
    }
]

    An XML Generator configuration like:

    “Use default value for substitution” is enabled if you wish to replace any null values with an empty String equivalent (see “Default value for substitution”)

    The “Edit XML” contains:

    #set( $msg = $msg1 + " " + $msg2 )

<root>
    <msg>$msg</msg>
    <num>$num</num>
    #if ($vary.getClass().getName() == "java.util.ArrayList")
    #foreach( $v in $vary )
    <vary>$v</vary>
    #end
    #elseif ($vary.getClass().getName() == "java.lang.String")
    <vary>$vary</vary>
    #end
</root>

    This will result in the following output:

      • darshthakkar's avatar
        darshthakkar
        Valued Contributor
        4 years ago

        @robin, would it be safe to assume that this will work for generating html files from XML generator snap?