Example of Data weave Transformations 2.0 (dw 2.0)

-
Reading data from XML and generate JSON

%dw 2.0
output application/json

//Get List of Countries from the XML

var Countries = payload map ((payload01 , indexOfPayload01) -> {
             Name: payload01.country
       }) distinctBy $.Name

// Get list of States from the XML

var States = payload map ((payload01 , indexOfPayload01) -> {
             Name: payload01.state,
             Country: payload01.country
       }) distinctBy $.Name     
---

Form the Payload

The below does the list of things
·       Loop through for each country
·       Loop through for each states matching the country
·       Loop through for each club matching the state
·       Order by club name and state name


{
       Countries: Countries map ((country , indexOfCountry) -> {
             Name: country.Name,
             StateProvinces: States filter ($.Country == country.Name) map ((state, indexOfState) -> {
                    Name: state.Name,
                    Clubs: payload filter ($.state == state.Name) map ((club, indexOfClub) -> {
                          ClubId: club.clubId,
                          Name: club.name,
                          City: club.city,
                          StateProvince: club.state,
                          StateProvinceAbbr: club.stateAbbr,
                          Country: club.country,
                          Level: club.membershipLevel,
                           TimeZone: club.timeZone
                    }) orderBy ($.Name)
             }) orderBy ($.Name)
       })
}


OUTPUT
{
  "Countries": [
    {
      "Name": "USA",
      "StateProvinces": [
        {
          "Name": "North Carolina",
          "Clubs": [
            {
              "ClubId": 28743,
              "Name": "Raleigh",
              "City": "Raleigh",
              "StateProvince": "North Carolina",
              "StateProvinceAbbr": "NC",
              "Country": "USA",
              "Level": "Platinum",
              "TimeZone": "America/New_York"
            }
          ]
        }
      ]
    },
    {
      "Name": "INDIA",
      "StateProvinces": [
        {
          "Name": "Tamil Nadu",
          "Clubs": [
            {
              "ClubId": 372,
              "Name": "Chennai Medavakkam",
              "City": "Chennai",
              "StateProvince": "Tamil Nadu",
              "StateProvinceAbbr": "TN",
              "Country": "INDIA",
              "Level": "Platinum",
              "TimeZone": "India/Chennai"
            }
          ]
        }
      ]
    }
  ]
}

Jayaraman Pancharathinam
20 Nov 2018

Comments

Post a Comment

Popular posts from this blog

How to read xml file and set as mock response for an http web service call in MUnit 2.1.3 in Mule 4?

-
Reading XML file from src/test/resources folder and set as mock response for a http web service call in MUnit 2.1.3 in mule 4 You need to place the XML file under src/test/resources in order read by MUnit tools. And it has to be mentioned as below. < munit-tools:mock-when doc:name = "Mock when" doc:id = "9bc2c6a1-dd68-4d19-a8b0-0ad1b892b015" processor = "wsc:consume" >        < munit-tools:with-attributes >              < munit-tools:with-attribute attributeName = "doc:name" whereValue = "Get Token" />        </ munit-tools:with-attributes >        < munit-tools:then-return >              < munit-tools:payload value = " #[MunitTools::getResourceAsString ( ' getTokenWS_response.xml ' ) ] " mediaType = "application/xml" /> </ munit-tools:then-return > </ munit-tools:mock-when >   In case the file lo...
Read more

How to set headers before calling a sub-flow in MUnit 2.1.3 in Mule 4?

-
Image
Setting Headers and UriParams in MUnit test case in Mule 4 Set Event Processor can be used to pass headers before calling any sub-flow in MUnit test flow.  Uri Parameters also can be set in the same way. Headers < munit:set-event doc:name = "Set Event" doc:id = "70453df1-e368-488b-abcc-f8522185dd4f" >        < munit:payload value = " #[''] " encoding = "UTF-16" />        < munit:attributes value = " #[{headers : {' token ' :' b536b9a9-5e11-4773-93d3-8c973519ad54 ' , ' role ' :' Administrator,User '}}] " encoding = "UTF-16" /> </ munit:set-event >   UriParams < munit:set-event doc:name = "Set Event" doc:id = "70453df1-e368-488b-abcc-f8522185dd4f" >        < munit:payload value = " #[''] " encoding = "UTF-16" />        < munit:attributes...
Read more

How to mock SOAP web service call with a SOAP message in MUnit 2.1.3?

-
Creating a test case with mocking of SOAP web service call using MUnit 2.1.3 in Mulesoft Transform processor will not work if you are just providing the original response of SOAP service as mock response. So you need to you tweak little in order to make it work with Transform message processor. Look at the following example.  The is the complete SOAP message taken from the original response. <? xml version = '1.0' encoding = 'windows-1252' ?> < body > < env:Envelope xmlns:env = " http://schemas.xmlsoap.org/soap/envelope/ " >    < env:Header />    < env:Body >       < m:getTokenWSResponse xmlns:m = " http://example.net/example-services " >          < m:SessionResponse >             < com:RequestStatus xmlns:com = " http://example.net/security/common " > 0 </ com:R...
Read more