AnsweredAssumed Answered

Getting data from repeating segments of an XML file

Question asked by mrelzer on Sep 6, 2017
Latest reply on Sep 6, 2017 by mrelzer

I have XML which is being provided that looks something like :

 

<XML>

  <HEADER>

    <JOBNO>1234556789</JOBNO>

  </HEADER>

  <E1ADRM1 SEGMENT="1">
    <PARTNER_Q>AG</PARTNER_Q>
    <PARTNER_ID>0001001640</PARTNER_ID>
  </E1ADRM1>
  <E1ADRM1 SEGMENT="1">
    <PARTNER_Q>WE</PARTNER_Q>
    <PARTNER_ID>0009999999</PARTNER_ID>
  </E1ADRM1>
</XML>

 

I need to map PARTNER_ID to two different fields depending on the PARTNER_Q value.

 

I was attempting to use document caching (because I found a video that described how it would work) and the beginning of my process looks like this :

 

 

However the PARTNER_Q = WE section is never hit. It appears because Boomi is only evaluating the FIRST E1ADRM1 and not the subsequent ones.

 

I end up with :

 

JOBNO, AG_PARTNER_ID, EMPTY (should be WE_PARTNER_ID).

 

Seems that I need to somehow explain to Boomi that each of these E1ADRM1 needs to checked (or looped through).

 

Any suggestions?

Outcomes