Filter and Map Function in DW 2.0(Mule 4)

Author: Suraj Rohankar

What is Filter?

  • Iterates over an array and applies an expression that returns matching values.

What is Map?

  • Iterates over items in an array and outputs the results into a new array.

Use Case:

A company called ABCD info systems has recorded sales. The company wants to prepare a payload to store the information in a database.

Requirement: 

Payload should only contain the Transaction Date, Product Name, Price – where the price is equal to 1200, Country where sales made from United States, Canada, and Spain and payment method should only be Mastercard.

Input Payload:

[
    {
        “Transaction_date”: “1/2/09 6:17”,
        “Product”: “Product1”,
        “Price”: “1200”,
        “Payment_Type”: “Mastercard”,
        “Name”: “John”,
        “City”: “London”,
        “State”: “England”,
        “Country”: “United Kingdom”,
        “Account_Created”: “1/2/09 6:00”,
        “Last_Login”: “1/2/09 6:08”
    },
    {
        “Transaction_date”: “1/2/09 4:53”,
        “Product”: “Product1”,
        “Price”: “1200”,
        “Payment_Type”: “Mastercard”,
        “Name”: “Betina”,
        “City”: “Parkville                   “,
        “State”: “MO”,
        “Country”: “United Kingdom”,
        “Account_Created”: “1/2/09 4:42”,
        “Last_Login”: “1/2/09 7:49”
    },
    {
        “Transaction_date”: “1/2/09 13:08”,
        “Product”: “Product1”,
        “Price”: “1200”,
        “Payment_Type”: “Mastercard”,
        “Name”: “Federica e Andrea”,
        “City”: “Astoria                     “,
        “State”: “OR”,
        “Country”: “United States”,
        “Account_Created”: “1/1/09 16:21”,
        “Last_Login”: “1/3/09 12:32”
    },
    {
        “Transaction_date”: “1/3/09 14:44”,
        “Product”: “Product1”,
        “Price”: “1200”,
        “Payment_Type”: “Visa”,
        “Name”: “Gouya”,
        “City”: “Echuca”,
        “State”: “Victoria”,
        “Country”: “Australia”,
        “Account_Created”: “9/25/05 21:13”,
        “Last_Login”: “1/3/09 14:22”
    }
]

Dataweave Script:

%dw 2.0
output application/json

payload filter($.Price == “1200” and
              ($.Country == “United Kingdom” or
              $.Country ==”Canada” or
              $.Country == “Spain”)
        and $.Payment_Type == “Mastercard”) map ((payload, index) ->
{
“Transaction_date”: payload.Transaction_date,
“Product”: payload.Product,
“Price”: payload.Price,
“Country”: payload.Country,
“Payment_Type”: payload.Payment_Type
})

Output Payload:

[
{
  “Transaction_date”: “1/2/09 6:17”,
  “Product”: “Product1”,
  “Price”: “1200”,
  “Country”: “United Kingdom”,
  “Payment_Type”: “Mastercard”
},
{
  “Transaction_date”: “1/2/09 4:53”,
  “Product”: “Product1”,
  “Price”: “1200”,
  “Country”: “United Kingdom”,
  “Payment_Type”: “Mastercard”
}
]

Conclusion: 

This article explains how we can filter out and map the data by iterating over an array.

  • For more examples of MuleSoft, checkout my git repository and anypoint exchange.

Username: guestuser1

Password:  Muleuser@1

We use cookies on this site to enhance your user experience. For a complete overview of how we use cookies, please see our privacy policy.