Create json array using dataweave

Question

If I have xml like so....

<Root>
  <Authority>Water</Authority>
  <Sanctions>
    <Sanction>
      <SanctionCode>11</SanctionCode>
      <SanctionDesc>First Sanction</SanctionDesc>
    </Sanction>
    <Sanction>
      <SanctionCode>11</SanctionCode>
      <SanctionDesc>Second Sanction</SanctionDesc>
    </Sanction>          
  </Sanctions>
</Root>

Using DataWeave how can I create a json array of Santions using only the SanctionDesc?

I've tried this but it's not right...

%dw 1.0
%output application/json
---
records: payload.Root map {
   Authority: $.Authority,
   sanctions: $.Sanctions.Sanction map [$.SanctionDesc]
}

I want my output to look like this...

{
    "records": [{
        "Authority": "Water",
        "sanctions": ["First Sanction", "Second Sanction"]
    }]
}

AnupamBhusari · Accepted Answer · 2017-05-18 14:53:38Z

3

Try this

%dw 1.0
%output application/json
---
records: {
   Authority: payload.Root.Authority,
   sanctions: payload.Root.Sanctions..SanctionDesc
}

Or

%dw 1.0
%output application/json
---
records: {
   Authority: payload.Root.Authority,
   sanctions: payload.Root.Sanctions.*Sanction map $.SanctionDesc
}

Hope this helps.

answered May 18, 2017 at 14:53

AnupamBhusari

2,4152 gold badges17 silver badges22 bronze badges

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

2 Comments

Richie Over a year ago

Thanks. Can I ask you what the * in front of Sanction means? Does it just mean each one? I've been trying to find a definition somewhere but have not been able to find a good one.

AnupamBhusari Over a year ago

* is used in one of the selector of dataweave. Refer Multi Value selector for more details.

Srinivas · Accepted Answer · 2018-02-22 06:32:31Z

0

Understading the map operator is the key when picking and choosing elements from input payload. Map operator goes through all the array elements on the left hand side and we can pick the values from on right hand side, Giving example from Mulesoft portal

%dw 1.0

%output application/json

users: ["john", "peter", "matt"] map ((firstName, position) -> position ++ ":" ++ upper firstName)

Output: { "users": [ "0:JOHN", "1:PETER", "2:MATT" ] }

See link below: https://docs.mulesoft.com/mule-user-guide/v/3.8/dataweave-operators#map

answered Feb 22, 2018 at 6:32

Srinivas

923 bronze badges

Collectives™ on Stack Overflow

Create json array using dataweave

2 Answers 2

2 Comments

%output application/json

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

%output application/json

Comments

Your Answer

Sign up or log in

Post as a guest

Related