How to convert a JSON array to a JSON object

[fengdu126]

I used the sqlserver node to query multiple records, and the output is a JSON array, how to wrap this array into a JSON object and then output?

I found a lot of nodes but couldn’t achieve it!

Please help,thanks!

[Olek]

Try the Aggregate node.

Also do you actually need the array wrapped in curly braces in the data property? It also would be an invalid JSON/object notation without assigning an array to a property of any kind inside the curly braces. Besides array per se is a valid JSON (and surprisingly also an object).

[fengdu126]

@Olek

Try the Aggregate

thanks ,i try the aggregate node achieve it!

[Olek]

Great. Please mark my post above as a Solution.