How to filter an array of JSON in Mule DataWeave

Question

I am having a JSON like this :

{
  "dcsId": "1184001100000000517",
  "marketCode": "US",
  "languageCode": "en-US",
  "profile": {
  "base": {
     "username": "arunima27",
     "activeInd": "R",
     "phone": [
       {
          "activeInd": "Y",
          "type": "mobile",
          "primaryInd": "Y",
          "number": "2234566788"
       },
       {
         "activeInd": "N",
         "type": "mobile",
         "primaryInd": "N",
         "number": ""
       }
      ]
    }
  }
 }

From this input JSON we need to extract the payload.profile.base.phone.number where the payload.profile.base.phone.type == "mobile" and payload.profile.base.phone.activeInd == "Y". Actually we need to loop through the JSON array (payload.profile.base.*phone) and get only the phone numbers which are active and having the category / type as mobile.

We need the output like below :

{
  "dcsId": "1184001100000000517",
  "marketCode": "US",
  "languageCode": "en-US",
  "username" :  "arunima27", 
  "phoneNumber" : "2234566788"
}

We are facing problem in doing this transformation for the "phoneNumber" output variable.

Yevgeniy · Accepted Answer · 2017-04-19 06:56:28Z

9

from your expected result it looks like you only want the first matching number. here is the dataweave doing exactly this:

%dw 1.0
%output application/json
---
{
    dcsid: payload.dcsId,
    markCode: payload.marketCode,
    languageCode: payload.languageCode,
    username: payload.profile.base.username,
    phoneNumber: (payload.profile.base.phone filter ($.activeInd == 'Y' and $.type == 'mobile'))[0].number
}

if you want all matching phone numbers, just leave the [0] out and the value of phoneNumber in the result will be a array (not just the first matching phone number).

answered Apr 19, 2017 at 6:56

Yevgeniy

2,6941 gold badge20 silver badges27 bronze badges

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

Comments

Mohit Mehrotra · Accepted Answer · 2017-04-19 06:48:06Z

4

This has solved the problem.

{(payload.profile.base.phone filter ($.activeInd == "Y" and $.primaryInd== "Y"))}.number default ""

answered Apr 19, 2017 at 6:48

Mohit Mehrotra

3011 gold badge6 silver badges12 bronze badges

Comments

Abhay · Accepted Answer · 2017-04-19 11:00:46Z

1

Use filter and map on phone to achieve the desired result.

phoneNumber: {
    (payload.profile.base.phone filter ($.activeInd == "Y" and $.type == "mobile") map {
        number: $.number
    }
)}

Output

"phoneNumber": {
    "number": "2234566788",
 }

edited Apr 19, 2017 at 11:00

answered Apr 19, 2017 at 9:46

Abhay

3241 gold badge3 silver badges14 bronze badges

1 Comment

Yevgeniy Over a year ago

nope, phoneNumber won't be a array. In case of multiple matching phone numbers your dataweave will produce invalid JSON. phoneNumber will be a object containing to attributes with key number

jitender singh · Accepted Answer · 2021-05-21 09:57:43Z

-2

 %dw 2.0
 output application/json
 ---
 payload.profile.base.phone filter ((obj, index) -> (obj.activeInd == 'Y' and obj.type  ~= 'mobile'   ))

edited May 21, 2021 at 9:57

answered May 20, 2021 at 13:03

jitender singh

12 bronze badges

1 Comment

andriy-baran Over a year ago

Please use code formating for the snippet

Collectives™ on Stack Overflow

How to filter an array of JSON in Mule DataWeave

4 Answers 4

Comments

Comments

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related