# Latest

**URL:** https://discourse.nodered.org/latest.md?page=913

[Latest](https://discourse.nodered.org/latest.md) · [Categories](https://discourse.nodered.org/categories.md) · [Tags](https://discourse.nodered.org/tags.md)

**Page:** 914

---

## [Update a MYSQL DB Entry](https://discourse.nodered.org/t/update-a-mysql-db-entry/38972)

<div class="topic-metadata">

**Author:** [@paco1503](https://discourse.nodered.org/u/paco1503)\
**Replies:** 2\
**Last updated:** [11 January 2021 22:20 UTC](https://discourse.nodered.org/t/update-a-mysql-db-entry/38972 "2021-01-11T22:20:29Z")

</div>

Hey, again a noob question ^^ i tried 2 put something into my sql DB and it worked function: var frisch = msg.count; query = INSERT INTO Wasser(Stand) VALUES("+frisch+");; msg.topic = query; return msg; but now i …

---

## [How to get a value of an HTML page](https://discourse.nodered.org/t/how-to-get-a-value-of-an-html-page/37975)

<div class="topic-metadata">

**Author:** [@gschmidt](https://discourse.nodered.org/u/gschmidt)\
**Replies:** 4\
**Last updated:** [11 January 2021 22:10 UTC](https://discourse.nodered.org/t/how-to-get-a-value-of-an-html-page/37975 "2021-01-11T22:10:05Z")

</div>

Hi, I want to get a VALUE of an element of a (local) HTML page The element in the HTML page is \<p id="stbStatus"\> VALUE \</p\> I tried a lot of possiblities but I can't figure out what I need to fill in at the Selec…

---

## [Exec node as root?](https://discourse.nodered.org/t/exec-node-as-root/38921)

<div class="topic-metadata">

**Author:** [@EnricoSx](https://discourse.nodered.org/u/EnricoSx)\
**Replies:** 7\
**Last updated:** [11 January 2021 22:05 UTC](https://discourse.nodered.org/t/exec-node-as-root/38921 "2021-01-11T22:05:13Z")

</div>

Good morning, forgive google translator. What is the correct way to run a command as root via the exec node? I have a Raspberry Pi and I want it to execute "sudo shutdown now" by pressing the physical button, pin valu…

---

## [Light schedule with additional condition](https://discourse.nodered.org/t/light-schedule-with-additional-condition/38372)

<div class="topic-metadata">

**Author:** [@Enrico](https://discourse.nodered.org/u/Enrico)\
**Replies:** 15\
**Last updated:** [11 January 2021 21:33 UTC](https://discourse.nodered.org/t/light-schedule-with-additional-condition/38372 "2021-01-11T21:33:14Z")

</div>

Hey guys I've got the following in mind and I hope someone can point me in the right direction. I want to have a scheduled lighting with starting time according to the sunset. So nothing special so far, there are plen…

---

## [Simple If statement doesn´t work](https://discourse.nodered.org/t/simple-if-statement-doesn-t-work/37937)

<div class="topic-metadata">

**Author:** [@oma](https://discourse.nodered.org/u/oma)\
**Replies:** 14\
**Last updated:** [11 January 2021 20:05 UTC](https://discourse.nodered.org/t/simple-if-statement-doesn-t-work/37937 "2021-01-11T20:05:40Z")

</div>

I am sure it´s an "boy, tt´s so damn easy" question but i can´t see it anyway. I am getting a msg.payload value of 41.1 but my function still returns false: var watt = msg.payload.value; if (watt \> 20) { ms…

---

## [Trigger Question and trigger reset question](https://discourse.nodered.org/t/trigger-question-and-trigger-reset-question/38969)

<div class="topic-metadata">

**Author:** [@vikozo](https://discourse.nodered.org/u/vikozo)\
**Replies:** 7\
**Last updated:** [11 January 2021 19:58 UTC](https://discourse.nodered.org/t/trigger-question-and-trigger-reset-question/38969 "2021-01-11T19:58:43Z")

</div>

Hello first i have a trigger to avoid to get to many telegram so the Trigger 180Min will wait this time, this part work. But is there a way in the node config part to check how long the 180min are going on? Second, th…

---

## [Protection for window cover when window is open](https://discourse.nodered.org/t/protection-for-window-cover-when-window-is-open/38880)

<div class="topic-metadata">

**Author:** [@martinst](https://discourse.nodered.org/u/martinst)\
**Replies:** 4\
**Last updated:** [11 January 2021 18:02 UTC](https://discourse.nodered.org/t/protection-for-window-cover-when-window-is-open/38880 "2021-01-11T18:02:08Z")

</div>

I have several window roller shutters and windows that opens to the outside of the house. So when I control the cover by Home Assistant or it is triggered by some automation, I don't want to let the covers go down when t…

---

## [Dim Shelly Dimmer 2 using Homekit Node](https://discourse.nodered.org/t/dim-shelly-dimmer-2-using-homekit-node/38852)

<div class="topic-metadata">

**Author:** [@mabo01](https://discourse.nodered.org/u/mabo01)\
**Replies:** 24\
**Last updated:** [11 January 2021 17:30 UTC](https://discourse.nodered.org/t/dim-shelly-dimmer-2-using-homekit-node/38852 "2021-01-11T17:30:45Z")

</div>

Hi! I searched the forum for my questions, but could not find anything. I'm a bloody newbie - so please forgive me, in case this is a silly question. I would like to dim my new Shelly Dimmer 2 (Node: node-red-contrib-s…

---

## [BMW Mini Cooper SE full Electric Status in a Dashboard and Apple Homekit Object](https://discourse.nodered.org/t/bmw-mini-cooper-se-full-electric-status-in-a-dashboard-and-apple-homekit-object/38932)

<div class="topic-metadata">

**Author:** [@Donni1966](https://discourse.nodered.org/u/Donni1966)\
**Replies:** 2\
**Last updated:** [11 January 2021 17:19 UTC](https://discourse.nodered.org/t/bmw-mini-cooper-se-full-electric-status-in-a-dashboard-and-apple-homekit-object/38932 "2021-01-11T17:19:44Z")

</div>

Hi together, i getting my electric Mini last year in December. Since the car uses BMW Connect to map its status in an app, I came up with the idea of ​​looking for an interface description and came across the BMW node …

---

## [Unexpected end of JSON input in Json Node](https://discourse.nodered.org/t/unexpected-end-of-json-input-in-json-node/38944)

<div class="topic-metadata">

**Author:** [@bobfield](https://discourse.nodered.org/u/bobfield)\
**Replies:** 13\
**Last updated:** [11 January 2021 17:16 UTC](https://discourse.nodered.org/t/unexpected-end-of-json-input-in-json-node/38944 "2021-01-11T17:16:46Z")

</div>

Dears, I'm appending a Json records sequence in a text file using the 'File Node', and the last line is a newline character. After, I read this file with 'File In Node' and 'Json Node' to convert in Json. It works, but …

---

## [Bug in node-red-contrib-1wire 0.0.1](https://discourse.nodered.org/t/bug-in-node-red-contrib-1wire-0-0-1/38927)

<div class="topic-metadata">

**Author:** [@stefan24](https://discourse.nodered.org/u/stefan24)\
**Replies:** 3\
**Last updated:** [11 January 2021 16:15 UTC](https://discourse.nodered.org/t/bug-in-node-red-contrib-1wire-0-0-1/38927 "2021-01-11T16:15:05Z")

</div>

I am reading several 1wire temparature sensors with a Raspi 3 with this node: I wanted to start a heater when temperatures below 0 °C are reached. But I realized, that the min value is always 0. I don't know, how to …

---

## [Counting Pulses from an RPM Sensor](https://discourse.nodered.org/t/counting-pulses-from-an-rpm-sensor/38918)

<div class="topic-metadata">

**Author:** [@Marty\_B](https://discourse.nodered.org/u/Marty_B)\
**Replies:** 12\
**Last updated:** [11 January 2021 15:56 UTC](https://discourse.nodered.org/t/counting-pulses-from-an-rpm-sensor/38918 "2021-01-11T15:56:43Z")

</div>

Hi All, I am considering connecting a raspberry PI 3B+ to a gate controller's RPM sensor. This sensor outputs a square wave at about 100 Hz at its maximum speed. My question is, how can I count these using node-red?

---

## [Scraping a web page with data embedded in a script tag](https://discourse.nodered.org/t/scraping-a-web-page-with-data-embedded-in-a-script-tag/38949)

<div class="topic-metadata">

**Author:** [@stevenhorner](https://discourse.nodered.org/u/stevenhorner)\
**Replies:** 4\
**Last updated:** [11 January 2021 14:33 UTC](https://discourse.nodered.org/t/scraping-a-web-page-with-data-embedded-in-a-script-tag/38949 "2021-01-11T14:33:58Z")

</div>

Hello, I am testing scraping a webpage to show stock levels of items, rather than constantly checking a website. Example page to scrape: Link I have tried using the examples and looked at other similar questions but th…

---

## [CT value from Domoticz to MQTT](https://discourse.nodered.org/t/ct-value-from-domoticz-to-mqtt/38939)

<div class="topic-metadata">

**Author:** [@dheuts](https://discourse.nodered.org/u/dheuts)\
**Replies:** 8\
**Last updated:** [11 January 2021 13:25 UTC](https://discourse.nodered.org/t/ct-value-from-domoticz-to-mqtt/38939 "2021-01-11T13:25:45Z")

</div>

Good morning, I am trying to get the color, brightness and state from a Domoticz virtual device. Whe brightness and state are working, but can't get the color temp working. In the debug node, I see: domoticz/out : ms…

---

## [Analyzing JSON with dynamic number of nodes and updating external systems](https://discourse.nodered.org/t/analyzing-json-with-dynamic-number-of-nodes-and-updating-external-systems/38903)

<div class="topic-metadata">

**Author:** [@binderth](https://discourse.nodered.org/u/binderth)\
**Replies:** 6\
**Last updated:** [11 January 2021 12:21 UTC](https://discourse.nodered.org/t/analyzing-json-with-dynamic-number-of-nodes-and-updating-external-systems/38903 "2021-01-11T12:21:53Z")

</div>

Sorry, if I'm asking some basic stuff. I'm just starting with Node-Red and here's my use case: I take an JSON, which can have a dynamic number of nodes (\>= 0), and I'd like to analyse the JSON and update external system…

---

## [\[Announce\] Node-RED-Dashboard v2.26.0, 1, 2](https://discourse.nodered.org/t/announce-node-red-dashboard-v2-26-0-1-2/37840)

<div class="topic-metadata">

**Author:** [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Replies:** 4\
**Last updated:** [11 January 2021 12:09 UTC](https://discourse.nodered.org/t/announce-node-red-dashboard-v2-26-0-1-2/37840 "2021-01-11T12:09:47Z")

</div>

Just a few small updates to dashboard to squish a few bugs - hopefully fix the long standing "themestate not found" error - tidy up the overall css a bit - and add Paul's latest weather-icons-lite that includes a wind in…

---

## [Flows lost after power loss](https://discourse.nodered.org/t/flows-lost-after-power-loss/38776)

<div class="topic-metadata">

**Author:** [@lukeyboytas1](https://discourse.nodered.org/u/lukeyboytas1)\
**Replies:** 8\
**Last updated:** [11 January 2021 11:09 UTC](https://discourse.nodered.org/t/flows-lost-after-power-loss/38776 "2021-01-11T11:09:57Z")

</div>

When I build a flow, and I leave the pi turned off for a while (Day or more), I turn it back on and the flow is gone.. any help/advice. New to NodeRED btw luke

---

## [Wasserstandswarnung](https://discourse.nodered.org/t/wasserstandswarnung/38716)

<div class="topic-metadata">

**Author:** [@hansanne](https://discourse.nodered.org/u/hansanne)\
**Replies:** 10\
**Last updated:** [11 January 2021 10:15 UTC](https://discourse.nodered.org/t/wasserstandswarnung/38716 "2021-01-11T10:15:47Z")

</div>

Hallo alle zusammen, hier mal mein Flow: \[{"id":"5009699a.127438","type":"ui\_text","z":"57f19ea.5a2956","group":"ae53f947.6d7ae8","order":3,"width":"1","height":"1","name":"","label":"","format":"{{msg.payload}}","layo…

---

## [Node-red-contrib-smartmeter 0.3.1 - Hardware](https://discourse.nodered.org/t/node-red-contrib-smartmeter-0-3-1-hardware/38829)

<div class="topic-metadata">

**Author:** [@maru2648](https://discourse.nodered.org/u/maru2648)\
**Replies:** 5\
**Last updated:** [11 January 2021 05:51 UTC](https://discourse.nodered.org/t/node-red-contrib-smartmeter-0-3-1-hardware/38829 "2021-01-11T05:51:51Z")

</div>

Hey Guys, I want to build my own smart meter for power consumption from one device. I found the node-red-contrib-smartmeter 0.3.1 and wanted to know with which components this works. Here is the selection I made and wo…

---

## [Message objects](https://discourse.nodered.org/t/message-objects/38934)

<div class="topic-metadata">

**Author:** [@Bigbloke](https://discourse.nodered.org/u/Bigbloke)\
**Replies:** 1\
**Last updated:** [11 January 2021 04:57 UTC](https://discourse.nodered.org/t/message-objects/38934 "2021-01-11T04:57:47Z")

</div>

Hi, I’m new here, have been using your resources here for 2 years, but haven’t wanted to bother anyone over my issues but I am currently stumped. My TPLink HS100s use a Boolean true/false for off and on. Works great on…

---

## [SSE Client with digest auth](https://discourse.nodered.org/t/sse-client-with-digest-auth/38874)

<div class="topic-metadata">

**Author:** [@injector22](https://discourse.nodered.org/u/injector22)\
**Replies:** 4\
**Last updated:** [11 January 2021 01:01 UTC](https://discourse.nodered.org/t/sse-client-with-digest-auth/38874 "2021-01-11T01:01:56Z")

</div>

I'm trying to set up an SSE client to receive data, but the device requires digest auth. I can easily auth using the standard http node but not when using the SSE client node. Does anyone know how I can pass the sessi…

---

## [Unexpected indentifier in simple function](https://discourse.nodered.org/t/unexpected-indentifier-in-simple-function/38922)

<div class="topic-metadata">

**Author:** [@loyaltolex](https://discourse.nodered.org/u/loyaltolex)\
**Replies:** 5\
**Last updated:** [10 January 2021 22:53 UTC](https://discourse.nodered.org/t/unexpected-indentifier-in-simple-function/38922 "2021-01-10T22:53:05Z")

</div>

I am trying to write a simple function to toggle based on receipt of of a specific payload (a button press from a zigbeetomqtt capture of a sonoff button) if (msg.payload=="single"){ if (cur\_state==0){ cur\_state=1…

---

## [Ui\_time\_scheduler question](https://discourse.nodered.org/t/ui-time-scheduler-question/38872)

<div class="topic-metadata">

**Author:** [@gerry](https://discourse.nodered.org/u/gerry)\
**Replies:** 16\
**Last updated:** [10 January 2021 22:03 UTC](https://discourse.nodered.org/t/ui-time-scheduler-question/38872 "2021-01-10T22:03:16Z")

</div>

Installed the ui time scheduler node and was playing around trying various things. One question... is there any way to discern which timer is firing? If there are three schedules I don't see anything in the output that t…

---

## [\[Reference\] Optimising Node-RED](https://discourse.nodered.org/t/reference-optimising-node-red/38321)

<div class="topic-metadata">

**Author:** [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Replies:** 17\
**Last updated:** [10 January 2021 21:47 UTC](https://discourse.nodered.org/t/reference-optimising-node-red/38321 "2021-01-10T21:47:45Z")

</div>

Hi all, a little topic for discussion :smiley: preparing us for a new year of Node-RED fun. How do we optimise the running of Node-RED? This is mainly aimed at people using a Pi but should be generally useful for anyon…

---

## [Can't get functionGlobalContext to work using docker](https://discourse.nodered.org/t/cant-get-functionglobalcontext-to-work-using-docker/38869)

<div class="topic-metadata">

**Author:** [@nemi](https://discourse.nodered.org/u/nemi)\
**Replies:** 1\
**Last updated:** [10 January 2021 21:26 UTC](https://discourse.nodered.org/t/cant-get-functionglobalcontext-to-work-using-docker/38869 "2021-01-10T21:26:49Z")

</div>

Hi people, I am trying to add the npm module strtime so that I can use it inside the function node but I am epically failing. I am also using docker, here is what I am doing : Dockerfile : FROM nodered/node-red:1.2.7 …

---

## [Inject node for Deconz RaspBee II for a lidl bulb](https://discourse.nodered.org/t/inject-node-for-deconz-raspbee-ii-for-a-lidl-bulb/38863)

<div class="topic-metadata">

**Author:** [@vikozo](https://discourse.nodered.org/u/vikozo)\
**Replies:** 6\
**Last updated:** [10 January 2021 21:24 UTC](https://discourse.nodered.org/t/inject-node-for-deconz-raspbee-ii-for-a-lidl-bulb/38863 "2021-01-10T21:24:48Z")

</div>

Hello i have a Deconz RaspBee II which is connected and running! i try to do a inject node to change the bulb. A message output looks like this 9.1.2021, 20:59:35node: b396287a.a52c48 msg.payload : Object object …

---

## [Node-red-node-mysql ER\_SECURE\_TRANSPORT\_REQUIRED](https://discourse.nodered.org/t/node-red-node-mysql-er-secure-transport-required/38926)

<div class="topic-metadata">

**Author:** [@luismiguelbp](https://discourse.nodered.org/u/luismiguelbp)\
**Replies:** 0\
**Last updated:** [10 January 2021 21:02 UTC](https://discourse.nodered.org/t/node-red-node-mysql-er-secure-transport-required/38926 "2021-01-10T21:02:52Z")

</div>

Hi, can anyone help, I'm trying to connect to a MySQL instance that has SSL configured, and receive this error message on the Node node-red-node-mysql. "Error: ER\_SECURE\_TRANSPORT\_REQUIRED: Connections using insecure t…

---

## [Padding zeros in a function](https://discourse.nodered.org/t/padding-zeros-in-a-function/4302)

<div class="topic-metadata">

**Author:** [@Beothuk](https://discourse.nodered.org/u/Beothuk)\
**Replies:** 9\
**Last updated:** [10 January 2021 20:49 UTC](https://discourse.nodered.org/t/padding-zeros-in-a-function/4302 "2021-01-10T20:49:24Z")

</div>

I am using a slider to generate numbers from 0 to 150. I need all numbers to be generated with preceeding zeros if they are less than 3 digits. So 10 would be 010, 8 would be 008,100 remains unchanged. I am sure there is…

---

## [Worldmap feedback doesn't work for me](https://discourse.nodered.org/t/worldmap-feedback-doesnt-work-for-me/38901)

<div class="topic-metadata">

**Author:** [@hoylet](https://discourse.nodered.org/u/hoylet)\
**Replies:** 6\
**Last updated:** [10 January 2021 17:33 UTC](https://discourse.nodered.org/t/worldmap-feedback-doesnt-work-for-me/38901 "2021-01-10T17:33:05Z")

</div>

Hi I'm using worldmap and I have displayed an area with an associated context menu, containing buttons. onclick successfully invokes the delMarker, however for one of the buttons I would like feedback to be invoked, so…

---

## [Node-red-contrib-ccu - Missing devices](https://discourse.nodered.org/t/node-red-contrib-ccu-missing-devices/38913)

<div class="topic-metadata">

**Author:** [@Pinky](https://discourse.nodered.org/u/Pinky)\
**Replies:** 0\
**Last updated:** [10 January 2021 17:25 UTC](https://discourse.nodered.org/t/node-red-contrib-ccu-missing-devices/38913 "2021-01-10T17:25:40Z")

</div>

Hi there, I installed node-red on a vm and added the package node-red-contrib-ccu to connect the node-red instance with my homematic ccu. Worked fine so far. After installing the nodes for the ccu showed up and I was a…

[Previous page](https://discourse.nodered.org/latest.md?page=912)

[Next page](https://discourse.nodered.org/latest.md?page=914)
