You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ICS: Isolate 1st sibling on XML payload

Accepted answer
edited Aug 28, 2018 5:54PM in Integration 8 comments


Need a way to only reference the 1st node in the XML repeating element


Hi All,

I have an XML payload which I'm able to read. However, I need to isolate the 1st repeating element in my mapping, so that the results aren't duplicated by the number of child-nodes in the XML payload. Allow me to further explain:

Suppose payload looks like this (very simplified for discussion):


I want my mapping to only reference the 1st child_repeat.amount value of 5.5. I proceeded to edit my mapping and add a "Literal" that looked something like this: $ReadFile/nsmpr3:ReadResponse/nsmpr9:parent/nsmpr9:child_repeat/nsmpr9:amount

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!