I wrote up a quick Chain spec you can use in a JoltTransformJSON processor, that way you can skip the Split/Merge pattern and work on the entire JSON object at once: [
{
"operation": "shift",
"spec": {
"Objects": {
"*": {
"Item": {
"Inventory": {
"Elements": {
"Element": {
"*": {
"Height": "[&1].Height",
"Weight": "[&1].Weight",
"Features": {
"Feature": {
"*": "[&3].&"
}
}
}
}
}
},
"Status": {
"ElementsStatus": {
"ElementStatus": {
"*": {
"@(3,Id)": "[&1].Id",
"Status": "[&1].Status"
}
}
}
}
}
}
}
}
}
] Note that this assumes the Element and ElementStatus arrays are parallel, meaning the first object in the Element array corresponds to the first object in the ElementStatus array (i.e. their FeatureId fields match). If that is not true, you'd either need a more complicated JOLT spec or perhaps a scripted solution using ExecuteScript.
... View more
