Expression Language - Array

[GBekkanti]

Hi Team,

I have below xml file.

---

<Users>
<User Id='N101'>
    <ContactList>
          <Contact>
                <Name>Jhon</Name>
                <City>New York</City>
                <PhoneNumber>123456</PhoneNumber>
          </Contact>
          <Contact>
                 <Name>Miller</Name>
                 <City>Cape Town</City>
                 <PhoneNumber>789456</PhoneNumber>
          </Contact>
    <ContactList/>
</User>
<User Id='N102'>
    <ContactList>
          <Contact>
                <Name>Sachin</Name>
                <City>Delhi</City>
                <PhoneNumber>56478</PhoneNumber>
          </Contact>
          <Contact>
                 <Name>Dhoni</Name>
                 <City>Jharkhand</City>
                 <PhoneNumber>145678</PhoneNumber>
          </Contact>
    <ContactList/>
</User>
</Users>

---

Now, I have a requirement to update the phone numbers.

from one branch I have split with (JSON Splitter) at User So, I will get two records from the one branch.

from another branch I am getting the PhoneNumbers as four individual records… for example 99999,88888,77777,66666 in the same order for the above file (Jhon, Miller, Sachin, Dhoni)

how can I upadate the phone numbers respectively. Can you please help on this?

Thanks in Advance!

Thanks and Regards,
Gopi Bekkanti.