Hi Community, hope someone can help me to build this transform: My Input: {
"Orders": [{
"Headers": {
"UniqShipment": "0"
},
"Goods": [{
"GoodsTypeID": 3,
"GoodsTypeName": "ALTRI MOBILI LEGNO",
"GoodsDetails": [{
"Packs": 1
}, {
"Packs": 1
}, {
"Packs": 1
}]
}],
"References": [{
"TypeReference": "DT",
"ValueReference": "006611",
"DateReference": "2023-04-14"
}, {
"TypeReference": "CM",
"ValueReference": "JOHN"
}, {
"TypeReference": "OC",
"ValueReference": "V1250-0010"
}, {
"TypeReference": "RG",
"ValueReference": "TRCA_CATR726240_CA_006611_14_04_2023.json"
}]
}]
} My Desired Output: {
"header": {
"UniqShipment": "0"
},
"rows": {
"GoodsTypeName": ["ALTRI MOBILI LEGNO", "ALTRI MOBILI LEGNO", "ALTRI MOBILI LEGNO"],
"Packs": [1, 1, 1],
"ValueReference": ["V1250-0010", "V1250-0010", "V1250-0010"]
}
} My Transformation so far: [
{
"operation": "shift",
"spec": {
"Orders": {
"*": {
"Headers": "header",
"Goods": {
"*": {
"GoodsDetails": {
"*": {
"@(2,GoodsTypeName)": "rows.GoodsTypeName",
"Packs": "rows.Packs"
}
}
}
}
}
}
}
}
] Which Produce the following result: {
"header" : {
"UniqShipment" : "0"
},
"rows" : {
"GoodsTypeName" : [ "ALTRI MOBILI LEGNO", "ALTRI MOBILI LEGNO", "ALTRI MOBILI LEGNO" ],
"Packs" : [ 1, 1, 1 ]
} Now i need to make the last part: Based on the value of TypeReference which has to be "OC" then add the list of ValueReference per each element of "rows array" like this: {
"header": {
"UniqShipment": "0"
},
"rows": {
"GoodsTypeName": ["ALTRI MOBILI LEGNO", "ALTRI MOBILI LEGNO", "ALTRI MOBILI LEGNO"],
"Packs": [1, 1, 1],
"TypeReference": ["V1250-0010", "V1250-0010", "V1250-0010"]
}
} Many Thanks for your help, appreciate!
... View more
