hi am new to node red and not conversant with Js. please i just need to display the following value on the debug node and dashboard.
TEMP
HUMI
EXTPWR
the below is the msg.payload i receive
</>
[{"flag":"DI0","switcher":0},
{"flag":"DI1","switcher":0},
{"flag":"DO0","switcher":0},
{"flag":"DO1","switcher":0},
{"flag":"TEMP","value":30.30},
{"flag":"HUMI","value":94.10},
{"flag":"EXTPWR","value":12.22}],
"time":"946952295"}
Welcome to the forum @AYo
You showed in the message first the fact that you are getting an array in msg.payload (or possibly a json string representing an array), but in the debug output you show there seems to be some extra text before the {"sensorDatas": [...
Can you clarify exactly what you are receiving?
If you do only have the string with the array int it then you should be able to first feed that into a JSON node to convert it to a javascript object, after that it is easy to do what you want.
Thanks Greatly for your reactivity ! @Colin
I connect to an Mqtt server and I use the debug Node to view all the data instead of serial monitor.
The debug Node display all the data i previously share. And I looking for away to only show just the TEMP, HUMI and EXTPWR only using function to put all other to nothing. Is that possible ?
Thanks again
Do you mean the one in the screenshot? Instead of posting a screenshot please copy the contents and paste it here. Use the Copy Value button (not Copy Path) as describe in this canned reply I am pasting below to get the value and then paste it here using the </> button at the top of the forum entry window when pasting it in. Canned reply follows:
Thereās a great page in the docs that will explain how to use the debug panel to find the right path to any data item.
Pay particular attention to the part about the buttons that appear under your mouse pointer when you over hover a debug message property in the sidebar.
https://nodered.org/docs/user-guide/messages
[Edit] Where is the MQTT data coming from, it seems odd with that strange text at the start?
The incoming string is a malformed json everything before and including the "#" needs to be removed.
It would be best if the device creating the string was corrected to send a properly formed json.
If that is not possible you will need to remove everything before the #, then pass it through a json node.
e.g.
[{"id":"4b63b34b.5458bc","type":"inject","z":"b779de97.b1b46","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":110,"y":20,"wires":[["4e5d636a.3a3dcc"]]},{"id":"4e5d636a.3a3dcc","type":"template","z":"b779de97.b1b46","name":"simulate payload","field":"payload","fieldType":"msg","format":"handlebars","syntax":"plain","template":"gprs tx 255: 2$koolboks#{\"sensorDatas\":[{\"flag\":\"DI0\",\"switcher\":0},\n{\"flag\":\"DI1\",\"switcher\":0},\n{\"flag\":\"DO0\",\"switcher\":0},\n{\"flag\":\"DO1\",\"switcher\":0},\n{\"flag\":\"TEMP\",\"value\":30.30},\n{\"flag\":\"HUMI\",\"value\":94.10},\n{\"flag\":\"EXTPWR\",\"value\":12.22}],\n\"time\":\"946952295\"}\n","output":"str","x":320,"y":20,"wires":[["751b92e2.76b93c"]]},{"id":"751b92e2.76b93c","type":"change","z":"b779de97.b1b46","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"$substringAfter($$.payload, \"#\")","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":400,"y":60,"wires":[["54ed2cb4.5bdb54"]]},{"id":"54ed2cb4.5bdb54","type":"json","z":"b779de97.b1b46","name":"","property":"payload","action":"","pretty":false,"x":570,"y":60,"wires":[["17147e63.c7b362"]]},{"id":"17147e63.c7b362","type":"change","z":"b779de97.b1b46","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"$$.payload.sensorDatas.${$.flag:$.value }","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":430,"y":120,"wires":[["f068a596.996288"]]},{"id":"f068a596.996288","type":"debug","z":"b779de97.b1b46","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":750,"y":160,"wires":[]}]
You may well be correct, but I am not absolutely certain about that, it may be some unusual chars confusing the debug display. That is why I have asked the OP to use the Copy Value and paste it here.
gprs connectting: mqtt.dtuip.com:1883...
gprs rx 4:
MQTT send report...
gprs tx 263: 2ļæ½
gprs tx 263: 2ļæ½
i use Serial node to Debug the datas, because the broker i use on the node -red automatically reconnect and connect so i am currently using Serial node debuger prior to purchasing a broker server. just want to be sure i will be able view th TEMP, HUMI, and the EXTPWR value.
beside, the copy vale does not show the values in gprs tx 262:2
but i have pasted it below
2BK4F717WM3UF1ABU{"sensorDatas":[{"flag":"DI0","switcher":0},{"flag":"DI1","switcher":0},{"flag":"DO0","switcher":0},{"flag":"DO1","switcher":0},{"flag":"TEMP","value":32.60},{"flag":"HUMI","value":87.60},{"flag":"EXTPWR","value":12.22}],"time":"946965544"}āµ"
thanks greatly ! @E1cid
ATM it is impossible to change from the device itself.
how do you think i can remove everything before #
Is it always #? as the data you posted does not have one.
If it is not then you can use the first "{"
Fix that first, it usually means that two clients are using the same client id. In node red it is usually best to leave the client id blank so node-red will create a unique id for you.
{"TEMP":30.3,"HUMI":94.1,"EXTPWR":12.22}
woow ! @E1cid i did import your code and it works.
let me play around it a bit i will revert !!!!
thanks again
although i will need to feed these in three dashboard for the TEMP, HUMI and EXTPWR
@E1cid
please can you help me complete this function for TEMP, HUMI and EXTERNAL PWR
[
{
"id": "07a299801b1eb818",
"type": "tab",
"label": "Flow 4",
"disabled": false,
"info": "",
"env": []
},
{
"id": "7b0fc5cf2105c5e4",
"type": "template",
"z": "07a299801b1eb818",
"name": "simulate payload",
"field": "payload",
"fieldType": "msg",
"format": "handlebars",
"syntax": "plain",
"template": "gprs tx 255: 2$koolboks#{\"sensorDatas\":[{\"flag\":\"DI0\",\"switcher\":0},\n{\"flag\":\"DI1\",\"switcher\":0},\n{\"flag\":\"DO0\",\"switcher\":0},\n{\"flag\":\"DO1\",\"switcher\":0},\n{\"flag\":\"TEMP\",\"value\":30.30},\n{\"flag\":\"HUMI\",\"value\":94.10},\n{\"flag\":\"EXTPWR\",\"value\":12.22}],\n\"time\":\"946952295\"}\n",
"output": "str",
"x": 190,
"y": 80,
"wires": [
[
"becd8a7546e97aa9"
]
]
},
{
"id": "becd8a7546e97aa9",
"type": "change",
"z": "07a299801b1eb818",
"name": "",
"rules": [
{
"t": "set",
"p": "payload",
"pt": "msg",
"to": "$substringAfter($$.payload, \"#\")",
"tot": "jsonata"
}
],
"action": "",
"property": "",
"from": "",
"to": "",
"reg": false,
"x": 240,
"y": 140,
"wires": [
[
"f9886b40b0f6934f"
]
]
},
{
"id": "f9886b40b0f6934f",
"type": "json",
"z": "07a299801b1eb818",
"name": "",
"property": "payload",
"action": "",
"pretty": false,
"x": 250,
"y": 200,
"wires": [
[
"db5a9775a1f3f72a"
]
]
},
{
"id": "db5a9775a1f3f72a",
"type": "change",
"z": "07a299801b1eb818",
"name": "",
"rules": [
{
"t": "set",
"p": "payload",
"pt": "msg",
"to": "$$.payload.sensorDatas.${$.flag:$.value }",
"tot": "jsonata"
}
],
"action": "",
"property": "",
"from": "",
"to": "",
"reg": false,
"x": 240,
"y": 280,
"wires": [
[
"69d373c68f2dee3c",
"02b75c075070443a",
"acbb20d805f4c80f",
"e61f6dbb1542372c"
]
]
},
{
"id": "69d373c68f2dee3c",
"type": "debug",
"z": "07a299801b1eb818",
"name": "",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "false",
"statusVal": "",
"statusType": "auto",
"x": 250,
"y": 360,
"wires": []
},
{
"id": "6e7e35f567e854da",
"type": "serial in",
"z": "07a299801b1eb818",
"name": "s270",
"serial": "3f3490110108b9e5",
"x": 70,
"y": 180,
"wires": [
[
"7b0fc5cf2105c5e4"
]
]
},
{
"id": "b372356b8a29fc40",
"type": "ui_gauge",
"z": "07a299801b1eb818",
"name": "",
"group": "d5da3e9b.46abf",
"order": 5,
"width": 0,
"height": 0,
"gtype": "gage",
"title": "TEMP",
"label": " C",
"format": "{{value}}",
"min": 0,
"max": 10,
"colors": [
"#00b500",
"#e6e600",
"#ca3838"
],
"seg1": "",
"seg2": "",
"className": "",
"x": 670,
"y": 60,
"wires": []
},
{
"id": "48248f4c374787b8",
"type": "ui_gauge",
"z": "07a299801b1eb818",
"name": "",
"group": "d5da3e9b.46abf",
"order": 4,
"width": 0,
"height": 0,
"gtype": "gage",
"title": "EXTERNAL PWR",
"label": "V",
"format": "{{value}}",
"min": 0,
"max": "14",
"colors": [
"#00b500",
"#e6e600",
"#ca3838"
],
"seg1": "",
"seg2": "",
"className": "",
"x": 730,
"y": 300,
"wires": []
},
{
"id": "4b9bec53a4b8694c",
"type": "ui_gauge",
"z": "07a299801b1eb818",
"name": "",
"group": "d5da3e9b.46abf",
"order": 6,
"width": 0,
"height": 0,
"gtype": "gage",
"title": "HUMI",
"label": "RH %",
"format": "{{value}}",
"min": 0,
"max": "100",
"colors": [
"#00b500",
"#e6e600",
"#ca3838"
],
"seg1": "",
"seg2": "",
"className": "",
"x": 670,
"y": 180,
"wires": []
},
{
"id": "02b75c075070443a",
"type": "function",
"z": "07a299801b1eb818",
"name": "Incomplete [TEMP]",
"func": "\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 490,
"y": 60,
"wires": [
[
"b372356b8a29fc40"
]
]
},
{
"id": "acbb20d805f4c80f",
"type": "function",
"z": "07a299801b1eb818",
"name": "incomplete [HUMI]",
"func": "\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 510,
"y": 160,
"wires": [
[
"4b9bec53a4b8694c"
]
]
},
{
"id": "e61f6dbb1542372c",
"type": "function",
"z": "07a299801b1eb818",
"name": "Incomplete [EXTPWR]",
"func": "\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 500,
"y": 260,
"wires": [
[
"48248f4c374787b8"
]
]
},
{
"id": "3f3490110108b9e5",
"type": "serial-port",
"serialport": "COM4",
"serialbaud": "115200",
"databits": "8",
"parity": "none",
"stopbits": "1",
"waitfor": "",
"dtr": "none",
"rts": "none",
"cts": "none",
"dsr": "none",
"newline": "\\n",
"bin": "false",
"out": "char",
"addchar": "",
"responsetimeout": "10000"
},
{
"id": "d5da3e9b.46abf",
"type": "ui_group",
"name": "DHT11",
"tab": "784aac14.5c2404",
"order": 2,
"disp": true,
"width": "6",
"collapse": false,
"className": ""
},
{
"id": "784aac14.5c2404",
"type": "ui_tab",
"name": "S270",
"icon": "dashboard",
"order": 1,
"disabled": false,
"hidden": false
}
]
Thanks greatly !!!!!! 
Thanks again for this !
oh i see thanks greatly !
please do you have any free port example?
i have use HiveMQ Cloud credentials but it seems the port is secure and the hardware could connect, i asked the OEM and they told me the device does not support secure, and the free port i found connects successfully but when i tried again, no connection.
please you can suggest any unencrypted open port for test.
thanks greatly
hi @Colin
i can receive data now from the MQTT broker. see the below.
[
{
"id": "07a299801b1eb818",
"type": "tab",
"label": "Flow 4",
"disabled": false,
"info": "",
"env": []
},
{
"id": "7b0fc5cf2105c5e4",
"type": "template",
"z": "07a299801b1eb818",
"name": "simulate payload",
"field": "payload",
"fieldType": "msg",
"format": "handlebars",
"syntax": "plain",
"template": "gprs tx 255: 2$koolboks#{\"sensorDatas\":[{\"flag\":\"DI0\",\"switcher\":0},\n{\"flag\":\"DI1\",\"switcher\":0},\n{\"flag\":\"DO0\",\"switcher\":0},\n{\"flag\":\"DO1\",\"switcher\":0},\n{\"flag\":\"TEMP\",\"value\":30.30},\n{\"flag\":\"HUMI\",\"value\":94.10},\n{\"flag\":\"EXTPWR\",\"value\":12.22}],\n\"time\":\"946952295\"}\n",
"output": "str",
"x": 310,
"y": 100,
"wires": [
[
"becd8a7546e97aa9"
]
]
},
{
"id": "becd8a7546e97aa9",
"type": "change",
"z": "07a299801b1eb818",
"name": "",
"rules": [
{
"t": "set",
"p": "payload",
"pt": "msg",
"to": "$substringAfter($$.payload, \"#\")",
"tot": "jsonata"
}
],
"action": "",
"property": "",
"from": "",
"to": "",
"reg": false,
"x": 360,
"y": 160,
"wires": [
[
"f9886b40b0f6934f"
]
]
},
{
"id": "f9886b40b0f6934f",
"type": "json",
"z": "07a299801b1eb818",
"name": "",
"property": "payload",
"action": "",
"pretty": false,
"x": 370,
"y": 220,
"wires": [
[
"db5a9775a1f3f72a"
]
]
},
{
"id": "db5a9775a1f3f72a",
"type": "change",
"z": "07a299801b1eb818",
"name": "",
"rules": [
{
"t": "set",
"p": "payload",
"pt": "msg",
"to": "$$.payload.sensorDatas.${$.flag:$.value }",
"tot": "jsonata"
}
],
"action": "",
"property": "",
"from": "",
"to": "",
"reg": false,
"x": 360,
"y": 300,
"wires": [
[
"02b75c075070443a",
"acbb20d805f4c80f",
"e61f6dbb1542372c",
"04f2a781f97bb5ef"
]
]
},
{
"id": "b372356b8a29fc40",
"type": "ui_gauge",
"z": "07a299801b1eb818",
"name": "",
"group": "d5da3e9b.46abf",
"order": 5,
"width": 0,
"height": 0,
"gtype": "gage",
"title": "TEMP",
"label": " C",
"format": "{{value}}",
"min": 0,
"max": 10,
"colors": [
"#00b500",
"#e6e600",
"#ca3838"
],
"seg1": "",
"seg2": "",
"className": "",
"x": 790,
"y": 80,
"wires": []
},
{
"id": "48248f4c374787b8",
"type": "ui_gauge",
"z": "07a299801b1eb818",
"name": "",
"group": "d5da3e9b.46abf",
"order": 4,
"width": 0,
"height": 0,
"gtype": "gage",
"title": "EXTERNAL PWR",
"label": "V",
"format": "{{value}}",
"min": 0,
"max": "14",
"colors": [
"#00b500",
"#e6e600",
"#ca3838"
],
"seg1": "",
"seg2": "",
"className": "",
"x": 850,
"y": 320,
"wires": []
},
{
"id": "4b9bec53a4b8694c",
"type": "ui_gauge",
"z": "07a299801b1eb818",
"name": "",
"group": "d5da3e9b.46abf",
"order": 6,
"width": 0,
"height": 0,
"gtype": "gage",
"title": "HUMI",
"label": "RH %",
"format": "{{value}}",
"min": 0,
"max": "100",
"colors": [
"#00b500",
"#e6e600",
"#ca3838"
],
"seg1": "",
"seg2": "",
"className": "",
"x": 790,
"y": 200,
"wires": []
},
{
"id": "02b75c075070443a",
"type": "function",
"z": "07a299801b1eb818",
"name": "Incomplete [TEMP]",
"func": "\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 610,
"y": 80,
"wires": [
[
"b372356b8a29fc40"
]
]
},
{
"id": "acbb20d805f4c80f",
"type": "function",
"z": "07a299801b1eb818",
"name": "incomplete [HUMI]",
"func": "\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 630,
"y": 180,
"wires": [
[
"4b9bec53a4b8694c"
]
]
},
{
"id": "e61f6dbb1542372c",
"type": "function",
"z": "07a299801b1eb818",
"name": "Incomplete [EXTPWR]",
"func": "\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 620,
"y": 280,
"wires": [
[
"48248f4c374787b8"
]
]
},
{
"id": "55e81b83941a07da",
"type": "mqtt in",
"z": "07a299801b1eb818",
"name": "",
"topic": "2BK4F717WM3UF1AB",
"qos": "0",
"datatype": "auto",
"broker": "22c8989a884d7202",
"nl": false,
"rap": true,
"rh": 0,
"inputs": 0,
"x": 120,
"y": 200,
"wires": [
[
"7b0fc5cf2105c5e4"
]
]
},
{
"id": "04f2a781f97bb5ef",
"type": "debug",
"z": "07a299801b1eb818",
"name": "",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "false",
"statusVal": "",
"statusType": "auto",
"x": 580,
"y": 400,
"wires": []
},
{
"id": "d5da3e9b.46abf",
"type": "ui_group",
"name": "DHT11",
"tab": "784aac14.5c2404",
"order": 2,
"disp": true,
"width": "6",
"collapse": false,
"className": ""
},
{
"id": "22c8989a884d7202",
"type": "mqtt-broker",
"name": "S-270",
"broker": "mqtt.dtuip.com",
"port": "1883",
"tls": "",
"clientid": "2BK4F717WM3UF1AB",
"autoConnect": true,
"usetls": false,
"protocolVersion": "4",
"keepalive": "60",
"cleansession": true,
"birthTopic": "",
"birthQos": "0",
"birthPayload": "",
"birthMsg": {},
"closeTopic": "",
"closeQos": "0",
"closePayload": "",
"closeMsg": {},
"willTopic": "",
"willQos": "0",
"willPayload": "",
"willMsg": {},
"sessionExpiry": ""
},
{
"id": "784aac14.5c2404",
"type": "ui_tab",
"name": "S270",
"icon": "dashboard",
"order": 1,
"disabled": false,
"hidden": false
}
]
but i will need to push it to the dashboard, please help add the complete function code to display in each of the container, TEMP HUMI and EXTPWR, i ave tried all my best but not work
Thank you very much !
how to show on gauge example
[{"id":"4b63b34b.5458bc","type":"inject","z":"b779de97.b1b46","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":110,"y":20,"wires":[["4e5d636a.3a3dcc"]]},{"id":"4e5d636a.3a3dcc","type":"template","z":"b779de97.b1b46","name":"simulate payload","field":"payload","fieldType":"msg","format":"handlebars","syntax":"plain","template":"gprs tx 255: 2$koolboks#{\"sensorDatas\":[{\"flag\":\"DI0\",\"switcher\":0},\n{\"flag\":\"DI1\",\"switcher\":0},\n{\"flag\":\"DO0\",\"switcher\":0},\n{\"flag\":\"DO1\",\"switcher\":0},\n{\"flag\":\"TEMP\",\"value\":30.30},\n{\"flag\":\"HUMI\",\"value\":94.10},\n{\"flag\":\"EXTPWR\",\"value\":12.22}],\n\"time\":\"946952295\"}\n","output":"str","x":320,"y":20,"wires":[["751b92e2.76b93c"]]},{"id":"751b92e2.76b93c","type":"change","z":"b779de97.b1b46","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"\"{\" & $substringAfter($$.payload, \"{\")","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":400,"y":60,"wires":[["54ed2cb4.5bdb54"]]},{"id":"54ed2cb4.5bdb54","type":"json","z":"b779de97.b1b46","name":"","property":"payload","action":"","pretty":false,"x":570,"y":60,"wires":[["17147e63.c7b362"]]},{"id":"17147e63.c7b362","type":"change","z":"b779de97.b1b46","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"$$.payload.sensorDatas.${$.flag:$.value }","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":430,"y":120,"wires":[["f068a596.996288","5d6bc7f1.8c5dc","a36da4b2.5d85d8"]]},{"id":"f068a596.996288","type":"debug","z":"b779de97.b1b46","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":750,"y":160,"wires":[]},{"id":"5d6bc7f1.8c5dc","type":"ui_gauge","z":"b779de97.b1b46","name":"","group":"8b5cde76.edd58","order":9,"width":0,"height":0,"gtype":"gage","title":"gauge","label":"units","format":"{{msg.payload.TEMP}}","min":0,"max":10,"colors":["#00b500","#e6e600","#ca3838"],"seg1":"","seg2":"","x":350,"y":160,"wires":[]},{"id":"a36da4b2.5d85d8","type":"ui_gauge","z":"b779de97.b1b46","name":"","group":"8b5cde76.edd58","order":10,"width":0,"height":0,"gtype":"gage","title":"gauge","label":"units","format":"{{msg.payload.HUMI}}","min":0,"max":10,"colors":["#00b500","#e6e600","#ca3838"],"seg1":"","seg2":"","x":350,"y":200,"wires":[]},{"id":"8b5cde76.edd58","type":"ui_group","name":"","tab":"8f03e639.85956","order":1,"disp":true,"width":"12","collapse":false},{"id":"8f03e639.85956","type":"ui_tab","name":"Home","icon":"dashboard","disabled":false,"hidden":false}]
wow !!! 
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.
Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarksā¢ or registeredĀ® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.
The OpenJS Foundation | Terms of Use | Privacy Policy | OpenJS Foundation Bylaws | Trademark Policy | Trademark List | Cookie Policy