Input Payload
{
"characteristics": [
{
"name": "notes",
"value": "testing for characteristics",
"valueType": "string"
},
{
"name": "frame1.order",
"value": "123",
"valueType": "string"
},
{
"name": "frame1.bandwidth",
"value": "10",
"valueType": "string"
},
{
"name": "frame1.uom",
"value": "mm",
"valueType": "string"
},
{
"name": "frame1.size.width",
"value": "15",
"valueType": "string"
},
{
"name": "frame1.size.height",
"value": "20",
"valueType": "string"
},
{
"name": "bandwidth",
"value": "1000",
"valueType": "string"
},
{
"name": "frame1.size.length",
"value": "120",
"valueType": "string"
},
{
"name": "frame2.order",
"value": "466",
"valueType": "string"
},
{
"name": "frame2.bandwidth",
"value": "30",
"valueType": "string"
},
{
"name": "frame2.uom",
"value": "mm",
"valueType": "string"
},
{
"name": "frame2.size.width",
"value": "10",
"valueType": "string"
},
{
"name": "frame2.size.height",
"value": "150",
"valueType": "string"
},
{
"name": "frame2.size.length",
"value": "150",
"valueType": "string"
}
]
}
_____________________________________________________________________
Output
{
"characteristics": [
{
"name": "notes",
"value": "testing for characteristics",
"valueType": "string"
},
{
"name": "bandwidth",
"value": "1000",
"valueType": "string"
},
{
"name": "frame1",
"value": {
"frame1.order": "123",
"frame1.bandwidth": "10",
"frame1.uom": "mm",
"name": "frame1.size",
"value": {
"frame1.size.width": "15",
"frame1.size.height": "20",
"frame1.size.length": "120"
},
"valueType": "object"
},
"valueType": "object"
},
{
"name": "frame2",
"value": {
"frame2.order": "466",
"frame2.bandwidth": "30",
"frame2.uom": "mm",
"name": "frame2.size",
"value": {
"frame2.size.width": "10",
"frame2.size.height": "15",
"frame2.size.length": "150"
},
"valueType": "object"
},
"valueType": "object"
}
]
}
you have to mention this in the question description. Please do optimize the solution as per your needs.
%dw 2.0
output application/json
import * from dw::core::Strings
var y = payload.characteristics filter ((item, index) -> !(item.name startsWith "frame"))
---
characteristics: y ++ (payload.characteristics filter ((item, index) -> (item.name startsWith "frame"))
groupBy ((item, index) -> substringBefore(item.name,"." )) mapObject ((value, key, index) ->
do {
var frame = {(value map (($.name) : $.value))}
---
value:{
name: (key),
"value":
frame filterObject ((value, key, index) -> sizeOf((key) find ".")==1 ) ++
{
"name": (namesOf(frame filterObject ((value, key, index) -> sizeOf((key) find ".")==2 ))[0] splitBy ".") [0 to 1] joinBy ".",
"value": frame filterObject ((value, key, index) -> sizeOf((key) find ".")==2 ) ,
"valueType": "object"
},
"valueType": "object"
}
}
)).*value