How to split two arrays into object using Dataweave

Question

I am fetching data from database and trying to assigning using dataweave. However, I see if there are multiple values fetch for a query then it is combining all the values of column into single array.

Currently with the my dataweave logic it is return me this output

Current Output:

"orders": [
        {
          "orderID": "[10355, 10383, 10453]",
          "employeeID": "[6, 8, 1]"
        }
      ]

Expected Output:

"orders": [
            {
              "orderID": "103553",
              "employeeID": "6"
            },
            {
              "orderID": "10383",
              "employeeID": "8"
            },
            {
              "orderID": "10453",
              "employeeID": "1"
            }
          ]

Thanks in advance

What is the input and your current script?

aled
– aled

2020-05-22 17:15:48 +00:00
Commented May 22, 2020 at 17:15 — aled
– aled, Commented May 22, 2020 at 17:15

Alex · Accepted Answer · 2020-05-22 18:17:18Z

1

You can change String to JSON on the fly and then use it https://simpleflatservice.com/mule4/ChangeStringToJsonOnTheFly.html

%dw 2.0
var x={"orders": [
        {
          "orderID": "[10355, 10383, 10453]",
          "employeeID": "[6, 8, 1]"
        }
      ]    
}
output application/json
---
{
    orders: read(x.orders[0].orderID,'application/json') map (item,index) ->
    {
        orderID:item, 
        "employeeID": read(x.orders[0].employeeID,'application/json')[index]
    }
}

output

{
  "orders": [
    {
      "orderID": 10355,
      "employeeID": 6
    },
    {
      "orderID": 10383,
      "employeeID": 8
    },
    {
      "orderID": 10453,
      "employeeID": 1
    }
  ]
}

answered May 22, 2020 at 18:17

Alex

4,4832 gold badges24 silver badges61 bronze badges

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

Collectives™ on Stack Overflow

How to split two arrays into object using Dataweave

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