Neuer Blogbeitrag: Monatsrückblick - Dezember 2025 🎄

[mickym]

@oli sagte in Benötige Hilfe mit Node-Red in Verbindung mit homee:

@mickym
deswegen frage ich ja nach, weil ich es verstehen will

Gut also Konsolidierungsflow für später aufheben. ;) - Die anderen Nodes kannst importieren - und statt "Ein Gerät" - schließt Du Deinen anderen Flow an, der Dir Updates von Deinen Geräten liefert.

Im Prinzip brauchst Du auch das manuelle Antriggern dann nicht mehr. Das ist nur damit Du sehen kannst, wie Du hinten mit JSONATA verschiedene Informationen aus deinen Node-Objekten holst. (Ich habe ja nur mal den phonetischen_name herausgeholt).

[Oli]

@mickym

so, jetzt habe ich mal mit dem oberen Flow etwas gespielt und mir zusätzliche Daten geholt und schon kommt die nächste Frage.

Wie erstelle ich mir daraus ein Json, was ich in der VIS in einem Tabellen-Widget anzeigen lassen kann?
Folgende Spalten würde ich benötigen:
Name = Gerätename
Gerätetyp = Gerätetyp
Protokoll = Funkprotokoll (ZWave, ZigBee usw)
Gerätestatus = Gerätestatus (verfügbar, .....)

Die Daten werden im Flow alle schon abgefragt.

Spoiler

[
   {
       "id": "b8ad42061a6d5f2e",
       "type": "tab",
       "label": "Flow 2",
       "disabled": false,
       "info": "",
       "env": []
   },
   {
       "id": "bc383b50669e8145",
       "type": "junction",
       "z": "b8ad42061a6d5f2e",
       "x": 1120,
       "y": 380,
       "wires": [
           [
               "43f88f1028d1af0a",
               "99528e0bbb0f2491",
               "139fe3d8efb20402",
               "afc0236a6dc34b6c",
               "3baf2b45228f3514",
               "61efee2e1293f2f8",
               "18ed2cb5de54b4e1"
           ]
       ]
   },
   {
       "id": "1a49f3e7a72eeb98",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "inaktive Geräte",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1620,
       "y": 320,
       "wires": []
   },
   {
       "id": "6f4c16eed7166074",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "decodeUrlComponents",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload ~> |$.nodes|{\"name\":$decodeUrlComponent(name),\t\"note\":$decodeUrlComponent(note),\t\"phonetic_name\":$decodeUrlComponent(phonetic_name)},\"attributes\"|",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 540,
       "y": 380,
       "wires": [
           [
               "5c62dbd7992ee76d"
           ]
       ]
   },
   {
       "id": "5c62dbd7992ee76d",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Alle Geräte",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload.nodes",
               "tot": "msg"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 750,
       "y": 380,
       "wires": [
           [
               "9ed44d883152b608"
           ]
       ]
   },
   {
       "id": "99528e0bbb0f2491",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Alle inaktiven Geräte",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload[state = 2]",
               "tot": "jsonata"
           },
           {
               "t": "set",
               "p": "homee.inactive",
               "pt": "flow",
               "to": "payload",
               "tot": "msg"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1300,
       "y": 380,
       "wires": [
           [
               "1a49f3e7a72eeb98",
               "79c90e3a205144c8",
               "852a4580fa93381d"
           ]
       ]
   },
   {
       "id": "139fe3d8efb20402",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Alle aktiven Geräte",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload[state = 1]",
               "tot": "jsonata"
           },
           {
               "t": "set",
               "p": "homee.active",
               "pt": "flow",
               "to": "payload",
               "tot": "msg"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1290,
       "y": 180,
       "wires": [
           [
               "f8402a89bc3c1103",
               "b1946c337b7d80ef",
               "d95e18df200eadee"
           ]
       ]
   },
   {
       "id": "f8402a89bc3c1103",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "aktive Geräte",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1610,
       "y": 120,
       "wires": []
   },
   {
       "id": "43f88f1028d1af0a",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Geräte, die aktualisiert werden",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload[state = 12] ",
               "tot": "jsonata"
           },
           {
               "t": "set",
               "p": "homee.updating",
               "pt": "flow",
               "to": "payload",
               "tot": "msg"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1330,
       "y": 580,
       "wires": [
           [
               "ceb8932892417bf3",
               "4e3680fd1ba7cc1e",
               "21b0ae03da03035d"
           ]
       ]
   },
   {
       "id": "ceb8932892417bf3",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Geräte die aktualisiert werden",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1670,
       "y": 520,
       "wires": []
   },
   {
       "id": "4e3680fd1ba7cc1e",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Anzahl",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload ? $count(payload) : \"Keine Geräte im Aktualisierungsstatus\"",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1590,
       "y": 580,
       "wires": [
           [
               "d629bd7188fa7121"
           ]
       ]
   },
   {
       "id": "d629bd7188fa7121",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Anzahl Geräte im Aktualisierungsstatus",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1840,
       "y": 580,
       "wires": []
   },
   {
       "id": "79c90e3a205144c8",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Anzahl",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload ? $count(payload) : \"Keine Geräte im Aktualisierungsstatus\"",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1590,
       "y": 380,
       "wires": [
           [
               "6636132bd627fd5a"
           ]
       ]
   },
   {
       "id": "6636132bd627fd5a",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Anzahl inaktive Geräte",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1880,
       "y": 380,
       "wires": []
   },
   {
       "id": "b1946c337b7d80ef",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Anzahl",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload ? $count(payload) : \"Keine Geräte im Aktualisierungsstatus\"",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1590,
       "y": 180,
       "wires": [
           [
               "1871f120aa223a8d"
           ]
       ]
   },
   {
       "id": "1871f120aa223a8d",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Anzahl aktiver Geräte",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1800,
       "y": 180,
       "wires": []
   },
   {
       "id": "d95e18df200eadee",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Namen",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload.name",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1600,
       "y": 240,
       "wires": [
           [
               "ae2e5ba148bb399a"
           ]
       ]
   },
   {
       "id": "ae2e5ba148bb399a",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Namen aktiver Geräte",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1800,
       "y": 240,
       "wires": []
   },
   {
       "id": "852a4580fa93381d",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Namen",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload.name",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1600,
       "y": 440,
       "wires": [
           [
               "43f62f9f3bc5bc3d"
           ]
       ]
   },
   {
       "id": "43f62f9f3bc5bc3d",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Namen inaktiver Geräte",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1810,
       "y": 440,
       "wires": []
   },
   {
       "id": "21b0ae03da03035d",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Namen",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload.name",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1600,
       "y": 640,
       "wires": [
           [
               "02eb40a627f4e90d"
           ]
       ]
   },
   {
       "id": "02eb40a627f4e90d",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Namen aktualisierende Geräte",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1850,
       "y": 640,
       "wires": []
   },
   {
       "id": "9ed44d883152b608",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Geräte ausschliessen",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload ~> $filter(function($value){$value.id in [-1] != true})",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 960,
       "y": 380,
       "wires": [
           [
               "bc383b50669e8145"
           ]
       ]
   },
   {
       "id": "4bb866d9e36a197e",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "hole alle Geräte",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "{}",
               "tot": "json"
           },
           {
               "t": "set",
               "p": "payload.nodes",
               "pt": "msg",
               "to": "homee.nodes",
               "tot": "global"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 300,
       "y": 380,
       "wires": [
           [
               "6f4c16eed7166074"
           ]
       ]
   },
   {
       "id": "a48d4a225b9f0daa",
       "type": "inject",
       "z": "b8ad42061a6d5f2e",
       "name": "trigger",
       "props": [
           {
               "p": "payload"
           }
       ],
       "repeat": "",
       "crontab": "",
       "once": false,
       "onceDelay": 0.1,
       "topic": "",
       "payload": "true",
       "payloadType": "bool",
       "x": 130,
       "y": 380,
       "wires": [
           [
               "4bb866d9e36a197e"
           ]
       ]
   },
   {
       "id": "afc0236a6dc34b6c",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Alle ZWave Geräte",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload[protocol = 1]",
               "tot": "jsonata"
           },
           {
               "t": "set",
               "p": "payload.nodes",
               "pt": "flow",
               "to": "payload",
               "tot": "msg"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1290,
       "y": 780,
       "wires": [
           [
               "3f5d54fa1161d7c3",
               "fb541319f5065b26",
               "08ef2be1a63734c5",
               "94e00d809404b4a6"
           ]
       ]
   },
   {
       "id": "3f5d54fa1161d7c3",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Geräte mit ZWave",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1630,
       "y": 720,
       "wires": []
   },
   {
       "id": "fb541319f5065b26",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Anzahl",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload ? $count(payload) : 0",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1590,
       "y": 780,
       "wires": [
           [
               "8b5f07919d5020d8",
               "27bd5b6a0a11f64b"
           ]
       ]
   },
   {
       "id": "8b5f07919d5020d8",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Anzahl Geräte ZWave",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1900,
       "y": 720,
       "wires": []
   },
   {
       "id": "08ef2be1a63734c5",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Namen",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload.name",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1600,
       "y": 840,
       "wires": [
           [
               "3a0ad671056f0682"
           ]
       ]
   },
   {
       "id": "3a0ad671056f0682",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Namen ZWave Geräte",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1820,
       "y": 840,
       "wires": []
   },
   {
       "id": "27bd5b6a0a11f64b",
       "type": "ioBroker out",
       "z": "b8ad42061a6d5f2e",
       "name": "Anzahl ZWave Geräte",
       "topic": "0_userdata.0.System.homee.NichtVerfügbar",
       "ack": "true",
       "autoCreate": "true",
       "stateName": "0_userdata.0.System.homee.ZWave",
       "role": "",
       "payloadType": "number",
       "readonly": "false",
       "stateUnit": "",
       "stateMin": "",
       "stateMax": "",
       "x": 1840,
       "y": 780,
       "wires": []
   },
   {
       "id": "3baf2b45228f3514",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Alle ZigBee Geräte",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload[protocol = 2]",
               "tot": "jsonata"
           },
           {
               "t": "set",
               "p": "payload.nodes",
               "pt": "flow",
               "to": "payload",
               "tot": "msg"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1290,
       "y": 1040,
       "wires": [
           [
               "b0d34d08416e6c10",
               "adb5799593bc282a",
               "251973e2ae0fef12",
               "82e4d47fe4eafc92"
           ]
       ]
   },
   {
       "id": "b0d34d08416e6c10",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Geräte mit ZigBee",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1630,
       "y": 980,
       "wires": []
   },
   {
       "id": "adb5799593bc282a",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Anzahl",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload ? $count(payload) : 0",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1590,
       "y": 1040,
       "wires": [
           [
               "b553c35fe84e7ff1",
               "a722c9c32ead9437"
           ]
       ]
   },
   {
       "id": "b553c35fe84e7ff1",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Anzahl Geräte ZigBee",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1900,
       "y": 980,
       "wires": []
   },
   {
       "id": "251973e2ae0fef12",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Namen",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload.name",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1600,
       "y": 1100,
       "wires": [
           [
               "382b28ab778199d6"
           ]
       ]
   },
   {
       "id": "382b28ab778199d6",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Namen ZigBee Geräte",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1820,
       "y": 1100,
       "wires": []
   },
   {
       "id": "a722c9c32ead9437",
       "type": "ioBroker out",
       "z": "b8ad42061a6d5f2e",
       "name": "Anzahl ZigBee Geräte",
       "topic": "0_userdata.0.System.homee.ZigBee",
       "ack": "true",
       "autoCreate": "true",
       "stateName": "0_userdata.0.System.homee.ZigBee",
       "role": "",
       "payloadType": "number",
       "readonly": "false",
       "stateUnit": "",
       "stateMin": "",
       "stateMax": "",
       "x": 1840,
       "y": 1040,
       "wires": []
   },
   {
       "id": "306e283de06793a5",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "",
       "rules": [
           {
               "t": "move",
               "p": "payload",
               "pt": "msg",
               "to": "device",
               "tot": "msg"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 500,
       "y": 520,
       "wires": [
           [
               "3fcd14dd3eda98a3"
           ]
       ]
   },
   {
       "id": "3fcd14dd3eda98a3",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "hole alle Geräte",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "{}",
               "tot": "json"
           },
           {
               "t": "set",
               "p": "payload.nodes",
               "pt": "msg",
               "to": "homee.nodes",
               "tot": "global"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 720,
       "y": 520,
       "wires": [
           [
               "3981f0834f60fe3d"
           ]
       ]
   },
   {
       "id": "3981f0834f60fe3d",
       "type": "switch",
       "z": "b8ad42061a6d5f2e",
       "name": "Nur wenn Gerätestatus geändert",
       "property": "payload.nodes[id=$$.device.node.id].state = device.node.state",
       "propertyType": "jsonata",
       "rules": [
           {
               "t": "false"
           }
       ],
       "checkall": "true",
       "repair": false,
       "outputs": 1,
       "x": 970,
       "y": 520,
       "wires": [
           [
               "6f4c16eed7166074"
           ]
       ]
   },
   {
       "id": "e565ecbc06eb639f",
       "type": "switch",
       "z": "b8ad42061a6d5f2e",
       "name": "verify device",
       "property": "payload.node",
       "propertyType": "msg",
       "rules": [
           {
               "t": "nnull"
           }
       ],
       "checkall": "true",
       "repair": false,
       "outputs": 1,
       "x": 290,
       "y": 520,
       "wires": [
           [
               "306e283de06793a5"
           ]
       ]
   },
   {
       "id": "94e00d809404b4a6",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Gerätetyp",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload.note",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1600,
       "y": 900,
       "wires": [
           [
               "0582b181c8bac51c"
           ]
       ]
   },
   {
       "id": "0582b181c8bac51c",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Gerätebezeichnung",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1810,
       "y": 900,
       "wires": []
   },
   {
       "id": "82e4d47fe4eafc92",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Gerätetyp",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload.note",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1600,
       "y": 1160,
       "wires": [
           [
               "f575dd92416739a5"
           ]
       ]
   },
   {
       "id": "f575dd92416739a5",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Gerätebezeichnung",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1840,
       "y": 1160,
       "wires": []
   },
   {
       "id": "61efee2e1293f2f8",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Alle EnOcean Geräte",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload[protocol = 3]",
               "tot": "jsonata"
           },
           {
               "t": "set",
               "p": "payload.nodes",
               "pt": "flow",
               "to": "payload",
               "tot": "msg"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1300,
       "y": 1300,
       "wires": [
           [
               "6174c1fb73ccadf7",
               "6bf0970636cc1e4a",
               "d1def4dc22f8abba",
               "8e7cb4b3ad9ad7e4"
           ]
       ]
   },
   {
       "id": "6174c1fb73ccadf7",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Geräte mit EnOcean",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1640,
       "y": 1240,
       "wires": []
   },
   {
       "id": "6bf0970636cc1e4a",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Anzahl",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload ? $count(payload) : 0",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1590,
       "y": 1300,
       "wires": [
           [
               "ec17a4f04cc1f205",
               "39049bb60e657627"
           ]
       ]
   },
   {
       "id": "ec17a4f04cc1f205",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Anzahl Geräte EnOcean",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1920,
       "y": 1240,
       "wires": []
   },
   {
       "id": "d1def4dc22f8abba",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Namen",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload.name",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1600,
       "y": 1360,
       "wires": [
           [
               "6b83b8e1410bdb8b"
           ]
       ]
   },
   {
       "id": "6b83b8e1410bdb8b",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Namen EnOcean Geräte",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1900,
       "y": 1360,
       "wires": []
   },
   {
       "id": "39049bb60e657627",
       "type": "ioBroker out",
       "z": "b8ad42061a6d5f2e",
       "name": "Anzahl EnOcean Geräte",
       "topic": "0_userdata.0.System.homee.EnOcean",
       "ack": "true",
       "autoCreate": "true",
       "stateName": "0_userdata.0.System.homee.EnOcean",
       "role": "",
       "payloadType": "number",
       "readonly": "false",
       "stateUnit": "",
       "stateMin": "",
       "stateMax": "",
       "x": 1860,
       "y": 1300,
       "wires": []
   },
   {
       "id": "8e7cb4b3ad9ad7e4",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Gerätetyp",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload.note",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1600,
       "y": 1420,
       "wires": [
           [
               "682221e81d05e1fb"
           ]
       ]
   },
   {
       "id": "682221e81d05e1fb",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Gerätebezeichnung",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1840,
       "y": 1420,
       "wires": []
   },
   {
       "id": "18ed2cb5de54b4e1",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Alle WLan Geräte",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload[protocol = 9]",
               "tot": "jsonata"
           },
           {
               "t": "set",
               "p": "payload.nodes",
               "pt": "flow",
               "to": "payload",
               "tot": "msg"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1290,
       "y": 1560,
       "wires": [
           [
               "73232d6356145c91",
               "1f89021c7a98c311",
               "4d4781ea193feb05",
               "f86809f6445fcbc5"
           ]
       ]
   },
   {
       "id": "73232d6356145c91",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Geräte mit WLan",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1630,
       "y": 1500,
       "wires": []
   },
   {
       "id": "1f89021c7a98c311",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Anzahl",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload ? $count(payload) : 0",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1590,
       "y": 1560,
       "wires": [
           [
               "1294df0c49809c46",
               "ab79ca8d13f7e817"
           ]
       ]
   },
   {
       "id": "1294df0c49809c46",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Anzahl Geräte WLan",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1910,
       "y": 1500,
       "wires": []
   },
   {
       "id": "4d4781ea193feb05",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Namen",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload.name",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1600,
       "y": 1620,
       "wires": [
           [
               "b4ba55ad0865333b"
           ]
       ]
   },
   {
       "id": "b4ba55ad0865333b",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Namen WLan Geräte",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1890,
       "y": 1620,
       "wires": []
   },
   {
       "id": "ab79ca8d13f7e817",
       "type": "ioBroker out",
       "z": "b8ad42061a6d5f2e",
       "name": "Anzahl WLan Geräte",
       "topic": "0_userdata.0.System.homee.WLan",
       "ack": "true",
       "autoCreate": "true",
       "stateName": "0_userdata.0.System.homee.WLan",
       "role": "",
       "payloadType": "number",
       "readonly": "false",
       "stateUnit": "",
       "stateMin": "",
       "stateMax": "",
       "x": 1850,
       "y": 1560,
       "wires": []
   },
   {
       "id": "f86809f6445fcbc5",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Gerätetyp",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload.note",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1600,
       "y": 1680,
       "wires": [
           [
               "0d7f447681a383e1"
           ]
       ]
   },
   {
       "id": "0d7f447681a383e1",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Gerätebezeichnung",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1840,
       "y": 1680,
       "wires": []
   },
   {
       "id": "d8d565711fe0dd22",
       "type": "link in",
       "z": "b8ad42061a6d5f2e",
       "name": "",
       "links": [
           "d87f2174cf715cf2"
       ],
       "x": 75,
       "y": 520,
       "wires": [
           [
               "e565ecbc06eb639f"
           ]
       ]
   }
]

[mickym]

Na nachdem ich nicht so fit bin was VIS betrifft, wollt ich zurückfragen:

Es geht also darum ein JSON aufzu bauen, wie hier:
https://www.smarthome-tricks.de/software-iobroker/iobroker-vis-json-table-widget-teil-1-basics/

Dann lass uns nochmal sicher gehen:

{
   "name": name,
  "type": type,
   "protocol": protocol,
   "state" : state
}

Die Überschriften bzw. das Mapping macht das Widget ja selbst.

Kannst Du mir vielleicht noch sagen, welche Eigenschaft dem type entspricht? (cube_type ??)
Gibts irgendwie ein lookup, welche Protokolle es gibt oder sind die 4 Protokolle bereits vollständig?

=========================================================================================

Entspricht type - den Services - und möchtest Du die übersetzt haben?

Ansonsten müsstest Du ggf. die Eigenschaften, der Protokolle halt ergänzen:

{"1":"ZWave","2":"Zigbee","3":"EnOcean","9":"WLan"}

bei den Typen entsprechend.

============================================================================

So nachdem Du Dich gerade nicht meldest - hier die Tabelle mit den Eigenschaften wie oben:

die musst halt einfach dahinter hängen - wo alle Geräte noch beisammen sind:

Spoiler

[
   {
       "id": "ef09455158bdbd20",
       "type": "change",
       "z": "9c280ddf049b2b4d",
       "name": "VIS Tabelle",
       "rules": [
           {
               "t": "set",
               "p": "protocols",
               "pt": "msg",
               "to": "{\"1\":\"ZWave\",\"2\":\"Zigbee\",\"3\":\"EnOcean\",\"9\":\"WLan\"}",
               "tot": "json"
           },
           {
               "t": "set",
               "p": "states",
               "pt": "msg",
               "to": "{\"1\":\"aktiv\",\"2\":\"inaktiv\",\"12\":\"wird aktualisiert\"}",
               "tot": "json"
           },
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload.{\t   \"name\" :name,\t   \"type\" : cube_type,\t   \"protocol\" :protocol ? $lookup($$.protocols,$string(protocol)) : protocol,\t   \"state\" : $lookup($$.states,$string(state)) \t}",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1210,
       "y": 3380,
       "wires": [
           [
               "1b3e55fcd8eadc58"
           ]
       ]
   },
   {
       "id": "1b3e55fcd8eadc58",
       "type": "debug",
       "z": "9c280ddf049b2b4d",
       "name": "VIS Tabelle",
       "active": true,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1410,
       "y": 3380,
       "wires": []
   }
]

[Oli]

@mickym

ich verwende für die VIS den Materialdesign Adapter und erstelle mir per Skript schon ein paar Tabellen, vielleicht hilft dir die Json Ausgabe dabei

[{"id":"FloodDetector-23","sensor":"Küche Wassersensor EG","betrieb":"Batterie","zustand":" <font color=\"lightgreen\"> 95 %","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_100.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"FourButtonRemote-64","sensor":"Schlafzimmer Schalter Nachtlicht DG","betrieb":"Batterie","zustand":" <font color=\"#8f8f8f\">  N/A","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_0.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"MeteringPlug-20","sensor":"Küche Kühlschrank EG","betrieb":"Strom","zustand":" <font color=\"green\"> 100 %","image":"/vis.0/main/img/Meine Icons/Batterie/Strom.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"MeteringPlug-33","sensor":"Schlafzimmer Klimaanlage DG","betrieb":"Strom","zustand":" <font color=\"green\"> 100 %","image":"/vis.0/main/img/Meine Icons/Batterie/Strom.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"MeteringPlug-34","sensor":"Flur Tablet EG","betrieb":"Strom","zustand":" <font color=\"green\"> 100 %","image":"/vis.0/main/img/Meine Icons/Batterie/Strom.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"MeteringPlug-42","sensor":"Wohnzimmer Weinkühlschrank EG","betrieb":"Strom","zustand":" <font color=\"green\"> 100 %","image":"/vis.0/main/img/Meine Icons/Batterie/Strom.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"MeteringPlug-56","sensor":"Büro Computer EG","betrieb":"Strom","zustand":" <font color=\"green\"> 100 %","image":"/vis.0/main/img/Meine Icons/Batterie/Strom.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"MeteringPlug-57","sensor":"Küche Geschirrspüler EG","betrieb":"Strom","zustand":" <font color=\"green\"> 100 %","image":"/vis.0/main/img/Meine Icons/Batterie/Strom.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"MeteringPlug-58","sensor":"Wohnzimmer Multimedia EG","betrieb":"Strom","zustand":" <font color=\"green\"> 100 %","image":"/vis.0/main/img/Meine Icons/Batterie/Strom.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"MeteringPlug-59","sensor":"Keller Waschmaschine UG","betrieb":"Strom","zustand":" <font color=\"green\"> 100 %","image":"/vis.0/main/img/Meine Icons/Batterie/Strom.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"MeteringPlug-6","sensor":"Flur Vitrine Licht DG","betrieb":"Strom","zustand":" <font color=\"green\"> 100 %","image":"/vis.0/main/img/Meine Icons/Batterie/Strom.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"OnOffPlug-35","sensor":"Wohnzimmer Stehlampe EG","betrieb":"Strom","zustand":" <font color=\"green\"> 100 %","image":"/vis.0/main/img/Meine Icons/Batterie/Strom.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"OnOffPlug-36","sensor":"Wohnzimmer Bar EG","betrieb":"Strom","zustand":" <font color=\"green\"> 100 %","image":"/vis.0/main/img/Meine Icons/Batterie/Strom.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"OnOffPlug-38","sensor":"Wohnzimmer Vitrine EG","betrieb":"Strom","zustand":" <font color=\"green\"> 100 %","image":"/vis.0/main/img/Meine Icons/Batterie/Strom.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"OnOffPlug-39","sensor":"Wohnzimmer TV-Schrank EG","betrieb":"Strom","zustand":" <font color=\"green\"> 100 %","image":"/vis.0/main/img/Meine Icons/Batterie/Strom.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"OnOffPlug-63","sensor":"Schlafzimmer Nachtlicht Oliver DG","betrieb":"Strom","zustand":" <font color=\"green\"> 100 %","image":"/vis.0/main/img/Meine Icons/Batterie/Strom.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"OnOffPlug-65","sensor":"Schlafzimmer Nachtlicht Kirsten DG","betrieb":"Strom","zustand":" <font color=\"green\"> 100 %","image":"/vis.0/main/img/Meine Icons/Batterie/Strom.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"OnOffPlug-66","sensor":"Schlafzimmer Nachtlicht TV DG","betrieb":"Strom","zustand":" <font color=\"green\"> 100 %","image":"/vis.0/main/img/Meine Icons/Batterie/Strom.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"OnOffPlug-68","sensor":"Schlafzimmer Luftreiniger DG","betrieb":"Strom","zustand":" <font color=\"green\"> 100 %","image":"/vis.0/main/img/Meine Icons/Batterie/Strom.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"OpenCloseSensor-10","sensor":"WC Fenster EG","betrieb":"Batterie","zustand":" <font color=\"lightgreen\"> 100 %","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_100.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"OpenCloseSensor-11","sensor":"Wohnzimmer Balkontüre EG","betrieb":"Batterie","zustand":" <font color=\"lightgreen\"> 90 %","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_90.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"OpenCloseSensor-12","sensor":"Esszimmer Balkontüre EG","betrieb":"Batterie","zustand":" <font color=\"lightgreen\"> 100 %","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_100.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"OpenCloseSensor-13","sensor":"Bad Fenster DG","betrieb":"Batterie","zustand":" <font color=\"lightgreen\"> 86 %","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_90.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"OpenCloseSensor-8","sensor":"Büro Fenster Links EG","betrieb":"Batterie","zustand":" <font color=\"lightgreen\"> 100 %","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_100.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"OpenCloseSensor-9","sensor":"Büro Fenster Rechts EG","betrieb":"Batterie","zustand":" <font color=\"lightgreen\"> 90 %","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_90.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"PresenceDetectorWithTemperatureAndBrightnessSensor-70","sensor":"Schlafzimmer Bewegungsmelder Oliver DG","betrieb":"Batterie","zustand":" <font color=\"#8f8f8f\">  N/A","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_0.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"PresenceDetectorWithTemperatureAndBrightnessSensor-71","sensor":"Schlafzimmer Bewegungsmelder DG","betrieb":"Batterie","zustand":" <font color=\"#8f8f8f\">  N/A","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_0.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"RadiatorThermostat-1","sensor":"Büro Heizung EG","betrieb":"Batterie","zustand":" <font color=\"lightgreen\"> 55 %","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_60.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"RadiatorThermostat-2","sensor":"Wohnzimmer Heizung Links EG","betrieb":"Batterie","zustand":" <font color=\"lightgreen\"> 85 %","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_90.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"RadiatorThermostat-26","sensor":"Bad Heizung DG","betrieb":"Batterie","zustand":" <font color=\"lightgreen\"> 85 %","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_90.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"RadiatorThermostat-4","sensor":"Esszimmer Heizung EG","betrieb":"Batterie","zustand":" <font color=\"lightgreen\"> 95 %","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_100.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"RadiatorThermostat-5","sensor":"WC Heizung EG","betrieb":"Batterie","zustand":" <font color=\"lightgreen\"> 55 %","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_60.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"RadiatorThermostat-62","sensor":"Wohnzimmer Heizung Balkon EG","betrieb":"Batterie","zustand":" <font color=\"lightgreen\"> 55 %","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_60.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"RoomThermostat-19","sensor":"Wohnzimmer Raumthermostat EG","betrieb":"Batterie","zustand":" <font color=\"lightgreen\"> 77 %","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_80.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"SmokeDetector-14","sensor":"Flur Rauchmelder UG","betrieb":"Batterie","zustand":" <font color=\"lightgreen\"> 76 %","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_80.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"SmokeDetector-15","sensor":"Flur Rauchmelder EG","betrieb":"Batterie","zustand":" <font color=\"lightgreen\"> 100 %","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_100.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"SmokeDetector-16","sensor":"Flur Rauchmelder DG","betrieb":"Batterie","zustand":" <font color=\"lightgreen\"> 98 %","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_100.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"SmokeDetector-18","sensor":"Schlafzimmer Rauchmelder UG","betrieb":"Batterie","zustand":" <font color=\"lightgreen\"> 88 %","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_90.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"SmokeDetector-45","sensor":"Schlafzimmer Rauchmelder DG","betrieb":"Batterie","zustand":" <font color=\"red\"> 12 %","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_20.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"TemperatureAndHumiditySensor-43","sensor":"Wohnzimmer Temperatur Weinkühlschrank EG","betrieb":"Batterie","zustand":" <font color=\"#8f8f8f\">  N/A","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_0.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"TemperatureAndHumiditySensor-44","sensor":"Wohnzimmer Temperatur Weinkühlschrank EG","betrieb":"Batterie","zustand":" <font color=\"#8f8f8f\">  N/A","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_0.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/homeek.png","adapter":"homee"},{"id":"02-00-00-6b-4f-a0","sensor":"Aussenraum","betrieb":"Batterie","zustand":" <font color=\"yellow\"> 27 %","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_30.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/netatmok.png","adapter":"homee"},{"id":"03-00-00-09-89-18","sensor":"Netatmo Schlafzimmer","betrieb":"Batterie","zustand":" <font color=\"lightgreen\"> 76 %","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_80.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/netatmok.png","adapter":"homee"},{"id":"03-00-00-0a-2b-4e","sensor":"Netatmo Büro","betrieb":"Batterie","zustand":" <font color=\"lightgreen\"> 49 %","image":"/vis.0/main/img/Meine Icons/Batterie/Batterie_50.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/netatmok.png","adapter":"homee"},{"id":"70-ee-50-6b-5f-4e","sensor":"Mein Haus (Netatmo Wohnzimmer)","betrieb":"Strom","zustand":" <font color=\"green\"> 100 %","image":"/vis.0/main/img/Meine Icons/Batterie/Strom.png","logo":"/vis.0/main/img/Meine Icons/Tabellen/netatmok.png","adapter":"homee"}]

Den Status und und das Protokoll müsste man wahrscheinlich übersetzten
Status: 1 = Verfügbar, 2 = nicht verfügbar, 3 = wird aktualisiert
Protokoll: 1 = ZWave, 2 = ZigBee, 3 = EnOcean, 9 = WLan

Widget-Einstellungen

Die Tabelle sieht dann so aus:

[mickym]

@oli Das habe ich doch schon alles gemacht, schaus Dir halt an. Es geht doch nur noch um den Typ. Aktualisert ist 12 und nicht 3.

[{"name":"DG / Schlafzimmer / Bewegungsmelder / Kirsten","type":2,"protocol":"Zigbee","state":"aktiv"},{"name":"DG / Schlafzimmer / Bewegungsmelder Oliver","type":2,"protocol":"Zigbee","state":"aktiv"},{"name":"DG / Schlafzimmer / Luftreiniger","type":2,"protocol":"Zigbee","state":"aktiv"},{"name":"DG / Schlafzimmer / Nachtlicht TV","type":2,"protocol":"Zigbee","state":"aktiv"},{"name":"DG / Schlafzimmer / Nachtlicht Kirsten","type":2,"protocol":"Zigbee","state":"aktiv"},{"name":"DG / Schlafzimmer / Schalter Nachtlicht","type":2,"protocol":"Zigbee","state":"aktiv"},{"name":"DG / Schlafzimmer / Nachtlicht Oliver","type":2,"protocol":"Zigbee","state":"aktiv"},{"name":"EG / Wohnzimmer / Heizung Balkon","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"UG / Keller / Waschmaschine","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"EG / Wohnzimmer / Multimedia","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"DG / Flur / Rauchmelder","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"EG / Flur / Rauchmelder","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"UG / Flur / Rauchmelder","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"DG / Bad / Fenster","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"EG / Esszimmer / Balkontüre","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"EG / Wohnzimmer / Balkontüre","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"EG / WC / Fenster","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"EG / Büro / Fenster Rechts","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"EG / Büro / Fenster Links","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"DG / Schlafzimmer / Rauchmelder","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"UG / Schlafzimmer / Rauchmelder","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"EG / Büro / Heizung","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"EG / Wohnzimmer / Vitrine","type":2,"protocol":"Zigbee","state":"aktiv"},{"name":"DG / Flur / Vitrine Licht","type":1,"protocol":"ZWave","state":"inaktiv"},{"name":"EG / Wohnzimmer / Temperatur Weinkühlschrank","type":2,"protocol":"Zigbee","state":"aktiv"},{"name":"EG / Wohnzimmer / Heizung Links","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"EG / Wohnzimmer / TV-Schrank","type":2,"protocol":"Zigbee","state":"aktiv"},{"name":"EG / Esszimmer / Heizung","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"EG / WC / Heizung","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"EG / Wohnzimmer / Weinkühlschrank","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"EG / Wohnzimmer / Raumthermostat","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"EG / Büro / Computer","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"EG / Küche / Kühlschrank","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"EG / Küche / Geschirrspüler","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"EG / Küche / Wassersensor","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"DG / Bad / Heizung","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"EG / Wohnzimmer / Netatmo","type":8,"protocol":"WLan","state":"aktiv"},{"name":"Netatmo Aussenraum","type":8,"protocol":"WLan","state":"aktiv"},{"name":"EG / Büro / Netatmo","type":8,"protocol":"WLan","state":"aktiv"},{"name":"DG / Schlafzimmer / Netatmo","type":8,"protocol":"WLan","state":"aktiv"},{"name":"DG / Schlafzimmer / Klimaanlage","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"EG / Flur / Tablet","type":1,"protocol":"ZWave","state":"aktiv"},{"name":"EG / Wohnzimmer / Stehlampe","type":2,"protocol":"Zigbee","state":"aktiv"},{"name":"EG / Wohnzimmer / Bar","type":2,"protocol":"Zigbee","state":"aktiv"},{"name":"EG / Küche / Temperatur Kühlschrank","type":2,"protocol":"Zigbee","state":"aktiv"}]

Na egal - Du siehst wie einfach man solche JSONS erstellen kann - das kannst ja dann selbst umsetzen. ;)

[Oli]

@mickym
sorry, hat sich überschnitten, du bist zu schnell für mich, bin gerade am testen ;-)

[mickym]

Ok - hat bissi gedauert - weil ich den Filter nur mit den Klammern machen wollte - aber hier noch eine in meinen Augen elegantere Möglichkeit, weil man damit auch noch weitere Eigenschaften von Protokollen oder Status mappen kann.

Man macht also nicht einfach ein Objekt mit dem status als key (Eigenschaft), sondern erstellt komplette Arrays, die man dann mit der $single Funktion filtert.

Das sieht dann so aus:

Die Daten die man also bekommt sind Objekte aus Arrays. Hier zum Beispiel die Protokolle:

[
    {
        "id": 1,
        "name": "ZWave"
    },
    {
        "id": 2,
        "name": "Zigbee"
    },
    {
        "id": 3,
        "name": "EnOcean"
    },
    {
        "id": 9,
        "name": "WLan"
    }
]

Der JSONATA Code schaut dann eigentlich easy aus (aber musste selbst wieder bissi rumtüfteln)

payload.{"name" :name,
"type" : cube_type,
"protocol" : $single($$.protocols, function($v){$v.id = protocol}).name,
"state" : $single($$.states, function($v){$v.id = state}).name
}

Hier wieder zum Ausprobieren:

Spoiler

[
   {
       "id": "0c51f133a4fe4fe4",
       "type": "change",
       "z": "9c280ddf049b2b4d",
       "name": "VIS Tabelle 2",
       "rules": [
           {
               "t": "set",
               "p": "protocols",
               "pt": "msg",
               "to": "[{\"id\":1,\"name\":\"ZWave\"},{\"id\":2,\"name\":\"Zigbee\"},{\"id\":3,\"name\":\"EnOcean\"},{\"id\":9,\"name\":\"WLan\"}]",
               "tot": "json"
           },
           {
               "t": "set",
               "p": "states",
               "pt": "msg",
               "to": "[{\"id\":1,\"name\":\"aktiv\"},{\"id\":2,\"name\":\"inaktiv\"},{\"id\":12,\"name\":\"wird aktualisiert\"}]",
               "tot": "json"
           },
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload.{\"name\" :name,\t\"type\" : cube_type,\t\"protocol\" : $single($$.protocols, function($v){$v.id = protocol}).name,\t\"state\" : $single($$.states, function($v){$v.id = state}).name\t}",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1210,
       "y": 3440,
       "wires": [
           [
               "ebf3d21498467dc6"
           ]
       ]
   },
   {
       "id": "ebf3d21498467dc6",
       "type": "debug",
       "z": "9c280ddf049b2b4d",
       "name": "VIS Tabelle",
       "active": true,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1410,
       "y": 3440,
       "wires": []
   }
]

Jedenfalls sieht man mit wie wenig Code - man mit JSONATA solche Objekte erzeugt ohne wie mit Javascript oder Blocklies sich mit Schleifen rumzuschlagen. ;)

Es ist zwar am Anfang etwas undurchsichtig, aber es lohnt sich probiert so was einfach mit dem try aus. Ihr könnt so was abspeichern.

Hier mal meine Test mit Deinen Geräten. ;)

https://try.jsonata.org/LdlRlT3hR

Wenn man dann an dem Code etwas verändert, sieht man sofort das Ergebnis und kann es dann wenn man zufrieden ist, einfach in die Change Node kopieren.

Je mehr ich damit beschäftige, desto genialer finde ich es - und erspart Spaghetti-Code. ;)

Warum das so praktisch ist wenn man arrays mit Objekten macht - habe ich hier mal kurz demonstriert:

Man sieht man kann damit ganz schnell auch mehrsprachig arbeiten und ändert nur einen Parameter in seinem JSONATA-Code.

[Oli]

@mickym

funktioniert alles super, wenn du mir jetzt noch verrätst, wie ich den Status mit verschiedenen Schriftfarben belegen kann?
Verfügbar = #8f8f8f
nicht verfügbar = rot
wird aktualisiert = orange

Danach bin ich mit dem ersten Flow durch und kann ihn dir mal posten

[mickym]

@oli sagte in Benötige Hilfe mit Node-Red in Verbindung mit homee:

Ja das sind die beiden Nodes? Für die Version mit den Arrays zum Lookup - und gibts damit ein Problem?

[Oli]

@mickym

sorry falsche Taste erwischt, habe ein Edit gemacht oben gemacht

[mickym]

@oli sagte in Benötige Hilfe mit Node-Red in Verbindung mit homee:

@mickym

funktioniert alles super, wenn du mir jetzt noch verrätst, wie ich den Status mit verschiedenen Schriftfarben belegen kann?
Verfügbar = #8f8f8f
nicht verfügbar = rot
wird aktualisiert = orange

Danach bin ich mit dem ersten Flow durch und kann ihn dir mal posten

Du meinst

"state": " <font color=\"#8f8f8f\"> aktiv"
"state": " <font color=\"rot\"> inaktiv"
"state": " <font color=\"orange\"> wird aktualisiert"

[Oli]

@mickym
ja, und wo trage ich das ein?

Sorry, eine Frage habe ich trotzdem noch, kannst du mir sagen, warum der Eintrag der Tabelle im Exporer im Klartext kommt und wenn ich den Datenpunkt öffne nur Objekt darin steht?

[mickym]

@oli Wenn Du den Wert in einen Datenpunkt schreiben willst, musst Du das Objekt als JSON String abspeichern. Also vorher noch eine JSON Node vor die iobroker_out Node machen.

[Oli]

@mickym
super, hat funktioniert

[mickym]

@oli So ab jetzt kannst aber selber rumprobieren. Nun zeigt sich gleich der Vorteil der 2. Variante.

Du kannst jetzt ein weiteres Attribute in deine lookup Objekte aufnehmen. Habe also nun color mit aufgenommen:
Also das states - Array enthält einfach eine neue Eigenschaft:

[
    {
        "id": 1,
        "name": "aktiv",
        "color": "#8f8f8f"
    },
    {
        "id": 2,
        "name": "inaktiv",
        "color": "rot"
    },
    {
        "id": 12,
        "name": "wird aktualisiert",
        "color": "orange"
    }
]

Das doofe sind nur diese Zeichen für den HTML-Code.
Aber finally here is the JSONATA Code:

payload.{"name" :name,
"type" : cube_type,
"protocol" : $single($$.protocols, function($v){$v.id = protocol}).name,
"state" : ' <font color=\\"' & $single($$.states, function($v){$v.id = state}).color & '\\"> ' & $single($$.states, function($v){$v.id = state}).name
}

Spoiler

[
   {
       "id": "0c51f133a4fe4fe4",
       "type": "change",
       "z": "9c280ddf049b2b4d",
       "name": "VIS Tabelle 3",
       "rules": [
           {
               "t": "set",
               "p": "protocols",
               "pt": "msg",
               "to": "[{\"id\":1,\"name\":\"ZWave\"},{\"id\":2,\"name\":\"Zigbee\"},{\"id\":3,\"name\":\"EnOcean\"},{\"id\":9,\"name\":\"WLan\"}]",
               "tot": "json"
           },
           {
               "t": "set",
               "p": "states",
               "pt": "msg",
               "to": "[{\"id\":1,\"name\":\"aktiv\",\"color\":\"#8f8f8f\"},{\"id\":2,\"name\":\"inaktiv\",\"color\":\"rot\"},{\"id\":12,\"name\":\"wird aktualisiert\",\"color\":\"orange\"}]",
               "tot": "json"
           },
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload.{\"name\" :name,\t\"type\" : cube_type,\t\"protocol\" : $single($$.protocols, function($v){$v.id = protocol}).name,\t\"state\" : ' <font color=\\\\\"' & $single($$.states, function($v){$v.id = state}).color & '\\\\\"> ' & $single($$.states, function($v){$v.id = state}).name\t}",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1210,
       "y": 3440,
       "wires": [
           [
               "ebf3d21498467dc6"
           ]
       ]
   },
   {
       "id": "ebf3d21498467dc6",
       "type": "debug",
       "z": "9c280ddf049b2b4d",
       "name": "VIS Tabelle",
       "active": true,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1410,
       "y": 3440,
       "wires": []
   }
]

Nun solltest Du aber übertragen und selbst die Zusammenhänge begriffen haben. ;)

Wenn Du also die Farbe ändern willst, dann musst Du nur noch die Farbe in den Objektes des states Array ändern.

[Oli]

@mickym
sorry, ich bin wahrscheinlich echt zu doof für das Programm

Einstellungen Tabelle 3

Einstellungen JSON

Ausgabe Debug

{"name":"DG / Schlafzimmer / Bewegungsmelder / Kirsten","type":"# Philips Hue Bewegungsmelder","protocol":"Zigbee","state":" <font color=\\\"green\\\"> verfügbar"}

Ausgabe Datenpunkt

{
    "name": "DG / Schlafzimmer / Bewegungsmelder / Kirsten",
    "type": "# Philips Hue Bewegungsmelder",
    "protocol": "Zigbee",
    "state": " <font color=\\\"green\\\"> verfügbar"
  },

Was mach ich bitte falsch? :disappointed_relieved:

[mickym]

@oli

Was stimmt denn daran nicht?

{"name":"DG / Schlafzimmer / Bewegungsmelder / Kirsten","type":2,"protocol":"Zigbee","state":" <font color=\\\"#8f8f8f\\\"> aktiv"}

=============================================================================

Ansonsten wenn das mit dem Maskieren doppelt gemoppelt ist, dann machst einfach den Schrägstrich weg:

Spoiler

[
   {
       "id": "d8f367359c6ee390",
       "type": "change",
       "z": "9c280ddf049b2b4d",
       "name": "VIS Tabelle 4",
       "rules": [
           {
               "t": "set",
               "p": "protocols",
               "pt": "msg",
               "to": "[{\"id\":1,\"name\":\"ZWave\"},{\"id\":2,\"name\":\"Zigbee\"},{\"id\":3,\"name\":\"EnOcean\"},{\"id\":9,\"name\":\"WLan\"}]",
               "tot": "json"
           },
           {
               "t": "set",
               "p": "states",
               "pt": "msg",
               "to": "[{\"id\":1,\"name\":\"aktiv\",\"color\":\"#8f8f8f\"},{\"id\":2,\"name\":\"inaktiv\",\"color\":\"rot\"},{\"id\":12,\"name\":\"wird aktualisiert\",\"color\":\"orange\"}]",
               "tot": "json"
           },
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload.{\"name\" :name,\t\"type\" : cube_type,\t\"protocol\" : $single($$.protocols, function($v){$v.id = protocol}).name,\t\"state\" : ' <font color=\\\"' & $single($$.states, function($v){$v.id = state}).color & '\\\"> ' & $single($$.states, function($v){$v.id = state}).name\t}",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1210,
       "y": 3500,
       "wires": [
           [
               "1c63a19aebb970df"
           ]
       ]
   },
   {
       "id": "1c63a19aebb970df",
       "type": "debug",
       "z": "9c280ddf049b2b4d",
       "name": "VIS Tabelle",
       "active": true,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1410,
       "y": 3500,
       "wires": []
   }
]

dann wird das automatisch gemacht:

{"name":"DG / Schlafzimmer / Bewegungsmelder / Kirsten","type":2,"protocol":"Zigbee","state":" <font color=\"#8f8f8f\"> aktiv"}

das Debug-Fenster stellt das Anführungszeichen eh korrekt dar und muss nicht demaskiert werden:

Ist halt immer eine Rumprobiererei mit den blöden Codes.

[Oli]

@mickym
kaum weiß man wo es steht, schon klappt es :-)

[mickym]

@oli sagte in Benötige Hilfe mit Node-Red in Verbindung mit homee:

@mickym
kaum weiß man wo es steht, schon klappt es :-)

Wollte gerade sagen:

schaut bei mir gut aus. ;)

[Oli]

@mickym
hallo, ich bin es schon wieder mal. Ich wollte mir die Anzahl der Batteriebetriebenen Geräte auslesen, dazu habe ich bereits folgendes versucht:

Filter der Attribute entfernt

payload ~> |$.nodes|{"name":$decodeUrlComponent(name),
"note":$decodeUrlComponent(note),
"phonetic_name":$decodeUrlComponent(phonetic_name)},""|

Folgende Abfrage versucht, klappt aber leider nicht

Spoiler

[
   {
       "id": "1eb34c24d42ff21e",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Alle Batterie Geräte",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload[attribute.type = 8] ? $count(payload) : 0",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1130,
       "y": 1080,
       "wires": [
           [
               "72e1f9d71bdd2dce",
               "212533ec0cee1dab"
           ]
       ]
   },
   {
       "id": "72e1f9d71bdd2dce",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Geräte mit Batterie",
       "active": true,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1370,
       "y": 1020,
       "wires": []
   },
   {
       "id": "212533ec0cee1dab",
       "type": "change",
       "z": "b8ad42061a6d5f2e",
       "name": "Anzahl",
       "rules": [
           {
               "t": "set",
               "p": "payload",
               "pt": "msg",
               "to": "payload ? $count(payload) : 0",
               "tot": "jsonata"
           }
       ],
       "action": "",
       "property": "",
       "from": "",
       "to": "",
       "reg": false,
       "x": 1330,
       "y": 1080,
       "wires": [
           [
               "5be85f72e357b53d"
           ]
       ]
   },
   {
       "id": "5be85f72e357b53d",
       "type": "debug",
       "z": "b8ad42061a6d5f2e",
       "name": "Anzahl Geräte Batterie",
       "active": false,
       "tosidebar": true,
       "console": false,
       "tostatus": false,
       "complete": "payload",
       "targetType": "msg",
       "statusVal": "",
       "statusType": "auto",
       "x": 1620,
       "y": 1080,
       "wires": []
   }
]

hier mal eine Geräteabfrage

Spoiler

{"node":{"id":26,"name":"DG%20%2F%20Bad%20%2F%20Heizung","profile":3006,"image":"default","favorite":0,"order":1,"protocol":1,"routing":0,"state":1,"state_changed":1678611603,"added":1601110067,"history":0,"cube_type":1,"note":"%23%20EUROtronic%20Spirit%20Z-Wave%20Plus","services":7,"phonetic_name":"Heizung%20Bad","owner":1,"security":0,"attributes":[{"id":225,"node_id":26,"instance":0,"minimum":0,"maximum":0,"current_value":0,"target_value":0,"last_value":0,"unit":"text","step_value":1,"editable":0,"type":44,"state":1,"last_changed":0,"changed_by":1,"changed_by_id":0,"based_on":1,"data":"4.61","name":""},{"id":226,"node_id":26,"instance":0,"minimum":0,"maximum":0,"current_value":0,"target_value":0,"last_value":0,"unit":"text","step_value":1,"editable":0,"type":45,"state":1,"last_changed":0,"changed_by":1,"changed_by_id":0,"based_on":1,"data":"0.15","name":""},{"id":227,"node_id":26,"instance":0,"minimum":0,"maximum":1,"current_value":0,"target_value":0,"last_value":0,"unit":"","step_value":1,"editable":1,"type":91,"state":1,"last_changed":1678428479,"changed_by":1,"changed_by_id":0,"based_on":1,"data":"","name":""},{"id":228,"node_id":26,"instance":0,"minimum":0,"maximum":100,"current_value":31,"target_value":31,"last_value":13,"unit":"%25","step_value":1,"editable":0,"type":18,"state":1,"last_changed":1678617181,"changed_by":1,"changed_by_id":0,"based_on":1,"data":"","name":"","options":{"automations":["step"]}},{"id":229,"node_id":26,"instance":0,"minimum":0,"maximum":100,"current_value":85,"target_value":85,"last_value":85,"unit":"%25","step_value":1,"editable":0,"type":8,"state":1,"last_changed":1678585502,"changed_by":1,"changed_by_id":0,"based_on":1,"data":"","name":"","options":{"history":{"day":182,"week":26,"month":6}}},{"id":230,"node_id":26,"instance":0,"minimum":0,"maximum":4,"current_value":1,"target_value":1,"last_value":1,"unit":"","step_value":1,"editable":1,"type":258,"state":1,"last_changed":1678428480,"changed_by":1,"changed_by_id":0,"based_on":1,"data":"","name":""},{"id":231,"node_id":26,"instance":0,"minimum":0,"maximum":180,"current_value":0,"target_value":0,"last_value":0,"unit":"%C2%B0","step_value":180,"editable":1,"type":90,"state":1,"last_changed":1601110068,"changed_by":1,"changed_by_id":0,"based_on":1,"data":"","name":""},{"id":232,"node_id":26,"instance":0,"minimum":0,"maximum":30,"current_value":0,"target_value":0,"last_value":5,"unit":"s","step_value":5,"editable":1,"type":259,"state":1,"last_changed":1635442644,"changed_by":1,"changed_by_id":0,"based_on":1,"data":"","name":""},{"id":233,"node_id":26,"instance":0,"minimum":0,"maximum":1,"current_value":1,"target_value":1,"last_value":0,"unit":"","step_value":1,"editable":1,"type":260,"state":1,"last_changed":1601110068,"changed_by":1,"changed_by_id":0,"based_on":1,"data":"","name":""},{"id":234,"node_id":26,"instance":0,"minimum":0,"maximum":3,"current_value":2,"target_value":2,"last_value":0,"unit":"","step_value":1,"editable":1,"type":261,"state":1,"last_changed":1601110068,"changed_by":1,"changed_by_id":0,"based_on":1,"data":"","name":""},{"id":235,"node_id":26,"instance":0,"minimum":-5,"maximum":5,"current_value":0,"target_value":0,"last_value":0,"unit":"%C2%B0C","step_value":0.1,"editable":1,"type":64,"state":1,"last_changed":1601110068,"changed_by":1,"changed_by_id":0,"based_on":1,"data":"","name":""},{"id":236,"node_id":26,"instance":0,"minimum":-50,"maximum":125,"current_value":16.73,"target_value":16.73,"last_value":16.64,"unit":"%C2%B0C","step_value":1,"editable":0,"type":5,"state":1,"last_changed":1678619101,"changed_by":1,"changed_by_id":0,"based_on":1,"data":"","name":"","options":{"can_observe":[5],"history":{"day":1,"week":26,"month":6}}},{"id":237,"node_id":26,"instance":0,"minimum":8,"maximum":28,"current_value":18,"target_value":18,"last_value":24,"unit":"%C2%B0C","step_value":0.5,"editable":1,"type":6,"state":1,"last_changed":1678611601,"changed_by":1,"changed_by_id":0,"based_on":1,"data":"","name":"","options":{"can_observe":[6],"automations":["step"],"history":{"day":35,"week":5,"month":1,"stepped":true}}},{"id":238,"node_id":26,"instance":0,"minimum":0,"maximum":1,"current_value":0,"target_value":0,"last_value":0,"unit":"","step_value":1,"editable":0,"type":69,"state":1,"last_changed":1674031595,"changed_by":1,"changed_by_id":0,"based_on":1,"data":"","name":"","options":{"history":{"day":182,"week":26,"month":6,"stepped":true}}},{"id":474,"node_id":26,"instance":0,"minimum":0,"maximum":1,"current_value":1,"target_value":1,"last_value":0,"unit":"","step_value":1,"editable":1,"type":385,"state":1,"last_changed":0,"changed_by":0,"changed_by_id":0,"based_on":0,"data":"","name":""}]}}

Der Wert befindet sich irgendwo in den Attributen unter den Punkt "Typ" mit dem Wert "8" und ist nur vorhanden, wenn das Gerät mit Batterie betrieben wird, also bei keiner Steckdose oder der gleichen.

Zusätzlich würde ich gerne den Punkt "current_value", der sich in den selben Attribut befindet, wie der Punkt "Typ" mit dem Wert "8" mit in meine Tabelle aufnehmen.

Aber leider stelle ich mich wieder zu doof an