Combines the key/value pairs into a single object & To get values in to array

 

Use Common Code -1 as Input in jsonata

https://jsonata.blogspot.com/2021/04/common-code-1.html

Query: 

"Phone": [

{

"type": "home",

"number": "0203 544 1234"

},

{

"type": "office",

"number": "01962 001234"

},

{

"type": "office",

"number": "01962 001235"

},

{

"type": "mobile",

"number": "077 7700 1234"

}

],

Query:Phone{type: number} OP:{

"home": "0203 544 1234",

"office": [

"01962 001234",

"01962 001235"

],

"mobile": "077 7700 1234"

} Query:

Phone{type: number[]}

{

"home": [

"0203 544 1234"

],

"office": [

"01962 001234",

"01962 001235"

],

"mobile": [

"077 7700 1234"

]

}