In dataweave converting multi line list of list in XML to single array in json

Question

In dataweave, I want to transform the below complex xml to json output as shown below:

<Message>
    <Shipment>
        <Containers>
            <Container TrackingNo="Abc1" />
         </Containers>
    </Shipment>
    <Shipment>
        <Containers>
            <Container TrackingNo="Abc2" />
            <Container TrackingNo="Abc3" />
        </Containers>
    </Shipment>
    <Shipment>
        <Containers>
            <Container TrackingNo="Abc4" />
            <Container TrackingNo="Abc5" />
            <Container TrackingNo="Abc6" />
        </Containers>
    </Shipment>
</Message>

I want to get the output in below JSON format after transformation in dataweave:

tracking_no:[
    {
        TrackingNo="Abc1"
    },
    {
        TrackingNo="Abc2"
    },
    {
        TrackingNo="Abc3"
    },
    {
        TrackingNo="Abc4"
    },
    {
        TrackingNo="Abc5"
    },
    {
        TrackingNo="Abc6"
    }
]

Shoki · Accepted Answer · 2019-05-17 17:51:31Z

5

You can use the descendant selector and then use the attributes selectors

%dw 2.0
output application/json
---
tracking_no: payload..*Container.@

edited May 17, 2019 at 17:51

Shoki

1,5488 silver badges14 bronze badges

answered May 17, 2019 at 14:08

machaval

5,06916 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

In dataweave converting multi line list of list in XML to single array in json

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related