Skip to main content

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"

}

]

}

3 risposte
  1. 30 nov 2023, 04:31

    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