Dataweave transformation split JSON linear array.

Question

I want to do the below transformation using mule Dataweave transformation. The input is a array of JSON key value pairs. I need to split the same.

Input

{
   "order":[
      {
         "key":"Status",
         "value":"Completed"
      },
      {
         "key":"Source",
         "value":"internet"
      },
      {
         "key":"name",
         "value":"abc def"
      },
      {
         "key":"domain",
         "value":"insurance"
      }
   ]
}

Output

 {
   "order":[
      {
         "key":"Status",
         "value":"Completed"
      },
      {
         "key":"Source",
         "value":"internet"
      }
   ],
   "Name":[
      {
         "key":"name",
         "value":"abc def"
      },
      {
         "key":"domain",
         "value":"insurance"
      }
   ]
}

Can anyone help?

AnupamBhusari · Accepted Answer · 2017-11-08 14:31:08Z

0

You can do that by filtering input on the basis of keys

%dw 1.0
%output application/json
%var data = ["name","domain"]
---
{
    order : payload.order filter not (data contains $.key),
    Name :  payload.order filter  (data contains $.key)
}

Hope this helps.

answered Nov 8, 2017 at 14:31

AnupamBhusari

2,4152 gold badges17 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

Dataweave transformation split JSON linear array.

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