[resolved] tXMLMap loop through root and child nodes.
Hello, I have a problem regarding loops in tXMLMap. Since TXmlMap doesnt allow to have a loop on both root and child elements, I cant seem to figure out the way to complete my task. I need to send payload to tESBProviderResponse with same schema as a response from a web service. I marked the elements that should be looped through in the image, and also provided with a way my response should look like. LINK TO THE IMAGE: http://postimg.org/image/g7hjsv7gf/full/ Can anyone link me to a tutorial on that would solve this problem, or supply me with a solution? Thank you in advance, Algimantas
Rhall,
I am struck here again.
In tExtractyXMLfiled We can iterate through loops.
But after that I need to filter only those Whose parent's parameters are validated against certain expectations.
I want to get the country where the address type = Physical and valid = yes .
Am using tXMLMap, I have put the Loop at address level and then Filtering the items in expression builder where address type = Physical.But I don't know how to check " valid = yes "
Example:
<Locations>
<location valid="yes">
<contact>
<address>
<type>LL</type>
<country>ES</country>
</address>
<address>
<type>Physical</type>
<country>IT</country>
</address>
</contact>
</location>
<location valid="no">
<contact>
<address>
<type>LL</type>
<country>GB</country>
</address>
<address>
<type>Physical</type>
<country>MI</country>
</address>
</contact>
</location>
</Locations>
