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
21
Views
8
Comments
edited Aug 28, 2018 5:54PM in Integration 8 comments

Summary

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

Content

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):

<parent>
    <child_repeat>
        <amount>5.5</amount>
    </child_repeat>
    <child_repeat>
        <amount>6.5</amount>
    </child_repeat>
</parent>

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.

Register

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