Combining the elements of array and reformatting the output

Question

I am having an input JSON which I would like to transform using Mule's dataweave 2.0.

Below is the input JSON.

[
   {
     "data1": {
                "role": "analyst",
                "name": "ABC"
     },
     "data2": {
                "role": "analyst",
                "name": "DEF"
     }
  },
  {
     "data1": {
                "role": "RM",
                "name": "PQRS"
     },
     "data2": {
                "role": "analyst",
                "name": "QWE"
     }
  }
]

We would like the output as below :

[
  {
     "role": "analyst",
     "name": "ABC"
  },
  {
     "role": "analyst",
     "name": "DEF"
  },
  {
     "role": "RM",
     "name": "PQRS"
  },
  {
     "role": "analyst",
     "name": "QWE"
  }
]

I have tried different options using map, pluck and flatten, but could not get the solution. Please help me with the transform function for this.

Shoki · Accepted Answer · 2019-05-09 17:15:17Z

2

If you want to keep the order you can:

1) Go through the elements with reduce and for each object in the array, accumulate data1 and data2

%dw 2.0
output application/json
---
payload reduce (item, acc = []) -> (acc << item.data1 << item.data2)

2) Using map, for each element in the array create an intermediate array containing data1 and data2 and then flatten that.

%dw 2.0
output application/json
---
flatten (payload map (item) -> [item.data1, item.data2])

answered May 9, 2019 at 17:15

Shoki

1,5488 silver badges14 bronze badges

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

Comments

vikram92 · Accepted Answer · 2019-05-09 11:31:13Z

0

If the order of the objects in response is important:

%dw 2.0
output application/json
---
flatten (payload map (flatten $))

If the order is not important:

%dw 2.0
output application/json
---
payload.data1 ++ payload.data2

answered May 9, 2019 at 11:31

vikram92

941 silver badge9 bronze badges

Collectives™ on Stack Overflow

Combining the elements of array and reformatting the output

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related