AnsweredAssumed Answered

How To: XML Document splitting ?

Question asked by allan.ford577519 on Apr 4, 2017
Latest reply on Jul 9, 2017 by sandeep.potlapally047307

Dear Forum !  

 

Am sure this question has been asked before but I couldn't spot details so am asking again ..

Am still relatively new to Boomi (~1 month mark of learning ..)

 

If I have an xml like this, how do I split it so that each row is processed as a document ?

 

Another consideration is : Is this a well formed XML or not suitable ?

i.e. looking at Data Processshape: Split or combine XML or JSON files  it seems to suggest a different approach to the XML input examples regarding how the XML is formed ..  

Perhaps I need to change the XML, and re-import as a new XML Profile item ..?

 

<?xml version="1.0" standalone="yes"?>
<DATAPACKET Version="2.0">
<METADATA>
<FIELDS>
<FIELD attrname="WEL_UID" fieldtype="i4"/>
<FIELD attrname="WELL" fieldtype="string" WIDTH="31"/>
<FIELD attrname="WELL_NAME" fieldtype="string" WIDTH="20"/>
<FIELD attrname="WELL_NUMBER" fieldtype="string" WIDTH="10"/>
</FIELDS>
<PARAMS/>
</METADATA>
<ROWDATA>
<ROW WEL_UID="71010066" WELL="FORAL GUMP 1" WELL_NAME="FORAL GUMP" WELL_NUMBER="1"/>
<ROW WEL_UID="71010065" WELL="BOOMI TEST WELL 1" WELL_NAME="BOOMI TEST WELL" WELL_NUMBER="1"/>
</ROWDATA>
</DATAPACKET>

 

 

many thanks, 

Allan

Outcomes