Loop through the array and add two different properties into one array

[venkat352]

Hi, I have been struggling to get the below scenario. Can someone please help me to get the below?

{
"Customer":[
{
"Info1":{
"Field1":"Value1",
"Field2":"Value2",
"Field3":"Value3"
},
"Info2":{
"Field4":"Value4",
"Field5":"Value5",
"Field6":"Value6"
}
},
{
"Info1":{
"Field1":"Value7",
"Field2":"Value8",
"Field3":"Value9"
},
"Info2":{
"Field4":"Value10",
"Field5":"Value11",
"Field6":"Value12"
}
}
]
}

Expected output

{
"GenericCustomer":[
{
"GenericComponent1":"Value1",
"GenericComponent2":"Value2",
"GenericComponent3":"Value3"
},
{
"GenericComponent1":"Value4",
"GenericComponent2":"Value5",
"GenericComponent3":"Value6"
},
{
"GenericComponent1":"Value7",
"GenericComponent2":"Value8",
"GenericComponent3":"Value9"
},
{
"GenericComponent1":"Value10",
"GenericComponent2":"Value11",
"GenericComponent3":"Value12"
}
]
}

[venkat352]

Hi Courela, Can you please help me resolve this? As it is a critical issue. I have tried almost every possible scenario, and none worked for me. I hope you'll be able to find solutions for it. Thanks

[Courela]

I was just checking right now.
Basically you want to remove the 'root' from every element on the array ('Info1', 'Info2', etc.), mantaining the property values only, assigned to another properties...
I'll have to try some solutions, I'm not seeing a straightforward one...

[venkat352]

I want to loop through Customer Array and create a new array combining Info1 and info 2.
I have tried the below, but it only selects the second loop and ignores the first loop.

"GenericCustomer":{
"#loop($.Customer)":{
"GenericComponent1":"#currentvalueatpath($.Info1.Field1)",
"GenericComponent2":"#currentvalueatpath($.Info1.Field2)",
"GenericComponent3":"#currentvalueatpath($.Info1.Field3)"
},
"#loop($.Customer)":{
"GenericComponent1":"#currentvalueatpath($.Info2.Field4)",
"GenericComponent2":"#currentvalueatpath($.Info2.Field5)",
"GenericComponent3":"#currentvalueatpath($.Info2.Field6)"
}
}

[venkat352]

Sorry I updated my first comment with the correct details. Thanks

[Courela]

Every #loop element must have a single root property, having two loops under the same property doesn't work.

"GenericCustomer":{
    "#loop($.Customer)":{
        ...
    },
    "#loop($.Customer)":{
        ...
    }
}

This will:

"GenericCustomer":{
    "#loop($.Customer)":{
        ...
    }
},
"GenericCustomerX":{
    "#loop($.Customer)":{
        ...
    }
}

[venkat352]

Thanks for that, but as I mentioned, I want to combine them into one Array, which is into GenericCustomer

[Courela]

There's this option for that
Array Concatenation

[venkat352]

That shouldn't work for me, as I need to map it to the different property names. Can you please post the transformation JSON for the below?

{
"Customer":[
{
"Info1":{
"Field1":"Value1",
"Field2":"Value2",
"Field3":"Value3"
},
"Info2":{
"Field4":"Value4",
"Field5":"Value5",
"Field6":"Value6"
}
},
{
"Info1":{
"Field1":"Value7",
"Field2":"Value8",
"Field3":"Value9"
},
"Info2":{
"Field4":"Value10",
"Field5":"Value11",
"Field6":"Value12"
}
}
]
}

Output

{
"GenericCustomer":[
{
"GenericComponent1":"Value1",
"GenericComponent2":"Value2",
"GenericComponent3":"Value3"
},
{
"GenericComponent1":"Value4",
"GenericComponent2":"Value5",
"GenericComponent3":"Value6"
},
{
"GenericComponent1":"Value7",
"GenericComponent2":"Value8",
"GenericComponent3":"Value9"
},
{
"GenericComponent1":"Value10",
"GenericComponent2":"Value11",
"GenericComponent3":"Value12"
}
]
}

[Courela]

This is the closest I can get, the items on the array are not ordered (supposedly arrays are not ordered in JSON):

{
  "GenericCustomer": "#applyover({'GenericCustomer1':{'#loop($.Customer)':{'GenericComponent1':'#currentvalueatpath($.Info1.Field1)'/,'GenericComponent2':'#currentvalueatpath($.Info1.Field2)'/,'GenericComponent3':'#currentvalueatpath($.Info1.Field3)'}}/,'GenericCustomer2':{'#loop($.Customer)':{'GenericComponent1':'#currentvalueatpath($.Info2.Field4)'/,'GenericComponent2':'#currentvalueatpath($.Info2.Field5)'/,'GenericComponent3':'#currentvalueatpath($.Info2.Field6)'}}}, '#concat(#valueof($.GenericCustomer1), #valueof($.GenericCustomer2))')"
}

Explanation: 'two' transformations (hence the use of #applyover)

• first create two arrays, 'GenericCustormer1' and 'GenericCustomer2', one from 'Info1' property and another from 'Info2' (commas inside the first argument of #applyover are escaped and double quotes were replaced with single quotes, but that's a transformation itself)
• second concatenate both arrays and join then in wanted property 'GenericCustomer'

[venkat352]

Hi Courela,

Thanks for sharing the transformation JSON. I can use it for simple JSON objects, but I need help with it for Complex JSON objects like the one below. Please help me to provide a transformation JSON for the below.

Input JSON:

{
"Movement":{
"Plannedtrip":{
"Stops":[
{
"Sequence":"0",
"PlannedArrival":"2023-02-28T00:17:00+02:00",
"PlannedDeparture":"2023-02-28T01:17:00+02:00",
"Site":{
"SiteId":"46544",
"Name":"Site Name_1",
"SiteType":"1",
"SiteTypeName":"MD",
"ServiceProvider":"ServiceProvider",
"Organization":"Organization",
"Enterprise":"Enterprise",
"ValueChain":"54564",
"SiteLocations":{
"SiteLocationPoints":{
"Sequence":"0",
"Latitude":"-12.464646",
"Longitude":"12.446644"
},
"Name":"Name-1",
"MainSite":"true",
"LocationTypeId":"1",
"RadiusInner":"200",
"RadiusOuter":"100"
},
"SiteContacts":null
},
"MovementNumber":"M-10000001",
"MovementType":null,
"Shipments":{
"ShipmentNumber":"4646464_1",
"ShipmentLines":{
"ShipmentLineNumber":"46464-260",
"ItemName":"ItemName",
"OrderedQuantity":"72",
"ShippedQuantity":"72"
}
},
"Action":"None",
"StopType":"StopType_1"
},
{
"Sequence":"1",
"PlannedArrival":"2023-02-27T23:25:00+02:00",
"PlannedDeparture":"2023-02-28T03:32:00+02:00",
"Site":{
"SiteId":"46546",
"Name":"Site Name_2",
"SiteType":"1",
"SiteTypeName":"MD",
"ServiceProvider":"ServiceProvider1",
"Organization":"Organization1",
"Enterprise":"Enterprise1",
"ValueChain":"9495",
"SiteLocations":{
"SiteLocationPoints":{
"Sequence":"0",
"Latitude":"-14.654655",
"Longitude":"14.465465"
},
"Name":"Name-2",
"MainSite":"true",
"LocationTypeId":"1",
"RadiusInner":"300",
"RadiusOuter":"400"
},
"SiteContacts":null
},
"MovementNumber":"M-10000001",
"MovementType":null,
"Shipments":{
"ShipmentNumber":"4646464_1",
"ShipmentLines":{
"ShipmentLineNumber":"46464-260",
"ItemName":"ItemName",
"OrderedQuantity":"72",
"ShippedQuantity":"72"
}
},
"Action":"None",
"StopType":"StopType_2"
}
]
}
}
}

Output JSON:

{
"_comments":"Mapping it to",
"GenericObjects":[
{
"_comments":"Movement=>Plannedtrip=>Stops=>Site",
"TenantId":"dev",
"Category":"Site",
"Type":"Site",
"ExternalId":"46544",
"PrimaryObjectType":"GenericObject",
"SecondaryObjectType":"Site",
"SecondaryReferences":{
"ExternalId":{
"value":"46544"
}
},
"Hierarchy":{
"nodes":{
"Id":{
"value":"cons3041",
"groupIndices":[

              ]
           }
        }
     },
     "Properties":{
        "Code":{
           "value":"46544"
        },
        "Name":{
           "value":"Site Name_1"
        },
        "Description":{
           "value":"Site Name_1"
        },
        "Latitude":{
           "value":"-12.464646"
        },
        "Longitude":{
           "value":"12.446644"
        },
        "RadiusInner":{
           "value":"200"
        },
        "RadiusOuter":{
           "value":"100"
        }
     }
  },
  {
     "_comments":"Movement=>Plannedtrip=>Stops=>Site",
     "TenantId":"dev",
     "Category":"Site",
     "Type":"Site",
     "ExternalId":"46546",
     "PrimaryObjectType":"GenericObject",
     "SecondaryObjectType":"Site",
     "SecondaryReferences":{
        "ExternalId":{
           "value":"46546"
        }
     },
     "Hierarchy":{
        "nodes":{
           "Id":{
              "value":"cons3041",
              "groupIndices":[
                 
              ]
           }
        }
     },
     "Properties":{
        "Code":{
           "value":"46546"
        },
        "Name":{
           "value":"Site Name_2"
        },
        "Description":{
           "value":"Site Name_2"
        },
        "Latitude":{
           "value":"-14.654655"
        },
        "Longitude":{
           "value":"14.465465"
        },
        "RadiusInner":{
           "value":"300"
        },
        "RadiusOuter":{
           "value":"400"
        }
     }
  },
  {
     "_comments":"Movement=>Plannedtrip=>Stops=>Shipments",
     "TenantId":"dev",
     "Category":"Order",
     "Type":"Order",
     "ExternalId":"4646464_1",
     "PrimaryObjectType":"GenericObject",
     "SecondaryObjectType":"Order",
     "SecondaryReferences":{
        "ExternalId":{
           "value":"4646464_1"
        }
     },
     "Hierarchy":{
        "nodes":{
           "Id":{
              "value":"cons3041",
              "groupIndices":[
                 
              ]
           }
        }
     },
     "Properties":{
        "Code":{
           "value":"4646464_1"
        },
        "Description":{
           "value":"4646464_1"
        },
        "OrderNumber":{
           "value":"4646464_1"
        },
        "PONumber":{
           "value":"4646464_1"
        }
     }
  },
  {
     "_comments":"Movement=>Plannedtrip=>Stops=>Shipments",
     "TenantId":"dev",
     "Category":"Order",
     "Type":"Order",
     "ExternalId":"4646464_1",
     "PrimaryObjectType":"GenericObject",
     "SecondaryObjectType":"Order",
     "SecondaryReferences":{
        "ExternalId":{
           "value":"4646464_1"
        }
     },
     "Hierarchy":{
        "nodes":{
           "Id":{
              "value":"cons3041",
              "groupIndices":[
                 
              ]
           }
        }
     },
     "Properties":{
        "Code":{
           "value":"4646464_1"
        },
        "Description":{
           "value":"4646464_1"
        },
        "OrderNumber":{
           "value":"4646464_1"
        },
        "PONumber":{
           "value":"4646464_1"
        }
     }
  }

]
}

[Courela]

Have you got any transformation to start from? I won't do a complete transformation for you.

[venkat352]

Please take a look at the below transformation. I have been trying to make it work for the above scenario.

{
"GenericObjects":{
"#loop($.Movement.Plannedtrip.Stops)":{
"#ifgroup(#ifcondition(#currentvalueatpath($.StopType),Deadhead,False,True))":{
"TenantId":"dev",
"Category":"Order",
"Type":"Order",
"ExternalId":"#currentvalueatpath($.Shipments.ShipmentNumber)",
"PrimaryObjectType":"GenericObject",
"SecondaryObjectType":"Order",
"SecondaryReferences":{
"ExternalId":{
"value":"#currentvalueatpath($.Shipments.ShipmentNumber)"
}
},
"Hierarchy":{
"nodes":{
"Id":{
"value":"cons3041",
"groupIndices":[

                 ]
              }
           }
        },
        "Properties":{
           "Code":{
              "value":"#currentvalueatpath($.Shipments.ShipmentNumber)"
           },
           "Description":{
              "value":"#currentvalueatpath($.Shipments.ShipmentNumber)"
           },
           "OrderNumber":{
              "value":"#currentvalueatpath($.Shipments.ShipmentNumber)"
           },
           "PONumber":{
              "value":"#currentvalueatpath($.Shipments.ShipmentNumber)"
           }
        }
     }
  },
  "#loop($.Movement.Plannedtrip.Stops)":{
     "#ifgroup(#ifcondition(#currentvalueatpath($.StopType),Deadhead,False,True))":{
        "TenantId":"dev",
        "Category":"Site",
        "Type":"Site",
        "ExternalId":"#currentvalueatpath($.Site.SiteId)",
        "PrimaryObjectType":"GenericObject",
        "SecondaryObjectType":"Site",
        "SecondaryReferences":{
           "ExternalId":{
              "value":"#currentvalueatpath($.Site.SiteId)"
           }
        },
        "Hierarchy":{
           "nodes":{
              "Id":{
                 "value":"cons3041",
                 "groupIndices":[
                    
                 ]
              }
           }
        },
        "Properties":{
           "Code":{
              "value":"#currentvalueatpath($.Site.SiteId)"
           },
           "Name":{
              "value":"#currentvalueatpath($.Site.Name)"
           },
           "Description":{
              "value":"#currentvalueatpath($.Site.Name)"
           },
           "Latitude":{
              "value":"#currentvalueatpath($.Site.SiteLocations.SiteLocationPoints.Latitude)"
           },
           "Longitude":{
              "value":"#currentvalueatpath($.Site.SiteLocations.SiteLocationPoints.Longitude)"
           },
           "RadiusInner":{
              "value":"#currentvalueatpath($.Site.SiteLocations.RadiusInner)"
           },
           "RadiusOuter":{
              "value":"#currentvalueatpath($.Site.SiteLocations.RadiusOuter)"
           }
        }
     }
  }

}
}

[venkat352]

Hi Courela,

What can I do to get the output that I want?

[Courela]

As I said...

Every #loop element must have a single root property, having two loops under the same property doesn't work.

"GenericCustomer":{
    "#loop($.Customer)":{
        ...
    },
    "#loop($.Customer)":{
        ...
    }
}

This will:

"GenericCustomer":{
    "#loop($.Customer)":{
        ...
    }
},
"GenericCustomerX":{
    "#loop($.Customer)":{
        ...
    }
}

[venkat352]

I am happy with the scenario, but now what I need is

"GenericObjectsX":{
"#loop($.Movement.Plannedtrip.Stops)":{
...
}
},
"GenericObjectsY":{
"#loop($.Movement.Plannedtrip.Stops)":{
...
}
}

I then Need to Combine as I need the output only GenericObjects, not the GenericObjectsX and GenericObjectsY.
I have tried your previous approach of #applyover, but with the typical structure, I failed to do it.

"GenericObjects":{
"GenericObjectsX",
"GenericObjectsY"
}