How to split the objects in an array to generate as individual Objects in Mule4

Question

I have a array request like below.It could have multiple shipping Objects as seen below. In the request, 2nd objects "shipping" having two Header and two Details.

Here 1st Header need to join with 1st Details to create separate Shipping objects and 2nd Header need to join with 2nd Details to create separate Shipping Objects and Vise versa as it having chances to have more headers and details.

Note: If header present there always be matching details will be present in the same fashion.

Request and Expected response are below. Mule Runtime 4.2.2

Any idea how it can be reorganized, any thoughts for the solution will be much appreciated. Thanks.

Request:

[
  {
    "Shipping": {
      "Header": {
        "Identifier": "100",
        "SerialNo": "61",
        "ShippingDate": "10/08/1988",
        "Address1": ""
      },
      "Details": {
        "SerialNo": "61",
        "LineNo": "1",
        "Description": "Shipping Details"
      }
    }
  },
  {
    "Shipping": {
      "Header": {
        "Identifier": "100",
        "SerialNo": "62",
        "ShippingDate": "21/08/2021",
        "Address": "Test1Address"
      },
      "Header": {
        "Identifier": "100",
        "SerialNo": "62",
        "ShippingDate": "22/05/1977",
        "Address1": "Test2Address"
      },
      "Details": {
        "SerialNo": "62",
        "LineNo": "1",
        "Description": "Test1"
      },
      "Details": {
        "SerialNo": "62",
        "LineNo": "1",
        "Description": "Test2"
      }
    }
  }]

Expected Response

[
  {
    "Shipping": {
      "Header": {
        "Identifier": "100",
        "SerialNo": "61",
        "ShippingDate": "10/08/1988",
        "Address1": ""
      },
      "Details": {
        "SerialNo": "61",
        "LineNo": "1",
        "Description": "Shipping Details"
      }
    }
  },
  {
    "Shipping": {
      "Header": {
        "Identifier": "100",
        "SerialNo": "62",
        "ShippingDate": "21/08/2021",
        "Address": "Test1Address"
      },
      "Details": {
        "SerialNo": "62",
        "LineNo": "1",
        "Description": "Test1"
      }
      
    }
  },
  {
    "Shipping": {
      "Header": {
        "Identifier": "100",
        "SerialNo": "62",
        "ShippingDate": "22/05/1977",
        "Address1": "Test2Address"
      },
      "Details": {
        "SerialNo": "62",
        "LineNo": "1",
        "Description": "Test2"
      }
    }
  }]

Hope my question clears. Let me know if requires more clarification.

Jorge Garcia · Accepted Answer · 2020-09-15 13:18:58Z

2

In this script, I tried to evict re-mapping field by field reusing the original objects.

payload reduce ((shipping, acc=[]) -> 
    acc ++ (
        shipping.Shipping.*Details map ((detail, index) -> 
            {
                Shipping: { 
                    Header: shipping.Shipping.*Header[index],
                    Details:  shipping.Shipping.*Details[index] 
                }
            }
        )
    )
)

You can map using *Details or *Header which should produce the same output

EDITED: Header logic was missing and Shipping has no other content than Header and Details

edited Sep 15, 2020 at 13:18

answered Sep 15, 2020 at 12:42

Jorge Garcia

1,3839 silver badges15 bronze badges

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

1 Comment

Star Over a year ago

Awesome. Working fine as expected. Thanks for the fast reply

Collectives™ on Stack Overflow

How to split the objects in an array to generate as individual Objects in Mule4

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related