AnsweredAssumed Answered

XML Profile - how to extract multiple child elements with same name

Question asked by KymLe151 on Aug 24, 2017

Hi Everyone!

 

I have an xml profile that can have up to 3 child elements with the same name:

 

 

<Custom_Id>

  <ID>1235</ID>

  <ID_Type_Reference>
    <ID type="Custom_ID_Type_ID">AD_ID</ID>
  </ID_Type_Reference>

</Custom_Id>

<Custom_Id>

  <ID>0000</ID>

  <ID_Type_Reference>
    <ID type="Custom_ID_Type_ID">ADP_ID</ID>
  </ID_Type_Reference>

</Custom_Id>

<Custom_Id>

  <ID>1111</ID>

  <ID_Type_Reference>
    <ID type="Custom_ID_Type_ID">MANAGER_ID</ID>
  </ID_Type_Reference>

</Custom_Id>

 

 

I want to map the 3 different values to a simple xml profile of:

 

<Custom_IDs>

<AD_ID>

<ADP_ID>

<Manager_ID>

</Custom_IDs>

 

 

Can someone <pretty PLEASE> tell me how this can be done?

 

 

Thanks in advance!! 

Outcomes