Search code examples
xsltmulesplitter

How do you split XMLs in mule? splitter?


Im a bit new to splitting XMLs, Can you help me create multiple XMLs from one input? do I need to use splitters? XSLT? also, can i plud in the message id in the xml as well?

Input

<?xml version="1.0"?>
<StockMovementDataRequest xmlns:p1="urn:ams.com.au:dynamo:3pl:am:SAP_AM_I_005:StockMovement" xmlns:a="http://www.edi.com.au/EnterpriseService">
    <Header>
        <From>Warehouse</From>
        <To>Location</To>
        <Unique_ID>idm1468201212</Unique_ID>
        <DateTimeStamp>2016-04-13T11:55:30.263+10:00</DateTimeStamp>
    </Header>
    <StockMovementData>
        <Serialised_Material>YES</Serialised_Material>
        <DateTime>2016-04-13T11:55:30.263+10:00</DateTime>
        <From_Location>30-80</From_Location>
        <To_Location>client</To_Location>
        <Material>7CAGL3G00</Material>
        <Serial>700030011</Serial>
        <Quantity>100</Quantity>
    </StockMovementData>
    <StockMovementData>
        <Serialised_Material>YES</Serialised_Material>
        <DateTime>2016-04-13T11:55:30.263+10:00</DateTime>
        <From_Location>30-80</From_Location>
        <To_Location>client</To_Location>
        <Material>7CAGL3G00</Material>
        <Serial>700029911</Serial>
        <Quantity>100</Quantity>
    </StockMovementData>
</StockMovementDataRequest>

output

<?xml version="1.0"?>
<StockMovementDataRequest xmlns:p1="urn:ams.com.au:dynamo:3pl:am:SAP_AM_I_005:StockMovement"
    xmlns:a="http://www.edi.com.au/EnterpriseService/">
    <Header>
        <From>warehouse</From>
        <To>client</To>
        <Unique_ID>idm1467386212</Unique_ID>
        <DateTimeStamp>2016-04-13T11:55:30.263+10:00</DateTimeStamp>
    </Header>
    <StockMovementData>
        <Serialised_Material>YES</Serialised_Material>
        <DateTime>2016-04-13T11:55:30.263+10:00</DateTime>
        <From_Location>30-80</From_Location>
        <To_Location>client</To_Location>
        <Material>7CAGL3G00</Material>
        <Serial>700030011</Serial>
        <Quantity>100</Quantity>
    </StockMovementData>
</StockMovementDataRequest>

and

<?xml version="1.0"?>
<StockMovementDataRequest xmlns:p1="urn:ams.com.au:dynamo:3pl:am:SAP_AM_I_005:StockMovement"
    xmlns:a="http://www.edi.com.au/EnterpriseService/">
    <Header>
        <From>warehouse</From>
        <To>client</To>
        <Unique_ID>idm1467386212</Unique_ID>
        <DateTimeStamp>2016-04-13T11:55:30.263+10:00</DateTimeStamp>
    </Header>
    <StockMovementData>
        <Serialised_Material>YES</Serialised_Material>
        <DateTime>2016-04-13T11:55:30.263+10:00</DateTime>
        <From_Location>30-80</From_Location>
        <To_Location>client</To_Location>
        <Material>7CAGL3G00</Material>
        <Serial>700029911</Serial>
        <Quantity>100</Quantity>
    </StockMovementData>
</StockMovementDataRequest>

Any thoughts?


Solution

  • Use Mule Splitter to split xml

        <splitter expression="#[xpath3('//StockMovementDataRequest/StockMovementData',payload,'NODESET')]" doc:name="Splitter"/>        
        <mulexml:dom-to-xml-transformer doc:name="DOM to XML"/>
    

    To aggregate the payload after splitter, use aggregator

    <collection-aggregator doc:name="Collection Aggregator"/>
    

    See more documentation here https://docs.mulesoft.com/mule-user-guide/v/3.7/splitter-flow-control-reference