Handle json object

General
1

hello,

I am pretty new to node-red, now I am working on one project which has mqtt json object as shown below:

image
image362×380 5.59 KB

This object structure comes from 3rd party device, I can't change it, but I would like to change to my json object or javascript object, then I can easily build dashboard,

Please notify "data" is one array with different monitoring variables, I need extract them into different object or json object for easy operation.

Anybody knows how to do it?

2

Well, we could help more if you were to describe more about what data structures you want to end up with.

I'm noting that the data properties are actually string representations of arrays. You can use a json node to convert those specific property values or you could use msg.payload = JSON.parse(msg.payload.mqtt_data[0].data), etc. in a function node.

3

It isn't JSON, it is already a javascript object, though as @TotallyInformation points out, the data property is a JSON representation of an array, which can be converted to a js array in the way he describes.