# Latest

**URL:** https://discourse.nodered.org/latest.md?no_subcategories=false&page=347

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

**Page:** 348

---

## [Mysql data logging](https://discourse.nodered.org/t/mysql-data-logging/78366)

<div class="topic-metadata">

**Author:** [@PRABHAKAR82](https://discourse.nodered.org/u/PRABHAKAR82)\
**Replies:** 3\
**Last updated:** [11 May 2023 18:40 UTC](https://discourse.nodered.org/t/mysql-data-logging/78366 "2023-05-11T18:40:53Z")

</div>

I have to log 5 data together in different column, I write this query but it give "ER\_PARSE\_ERROR" please help. var co = { payload: msg.payload\[0\]}; var ox = { payload: msg.payload\[1\]}; var lux = { payload: msg.paylo…

---

## [Replacement for package "request-promise"?](https://discourse.nodered.org/t/replacement-for-package-request-promise/78347)

<div class="topic-metadata">

**Author:** [@cameo69](https://discourse.nodered.org/u/cameo69)\
**Replies:** 3\
**Last updated:** [11 May 2023 18:29 UTC](https://discourse.nodered.org/t/replacement-for-package-request-promise/78347 "2023-05-11T18:29:09Z")

</div>

I am looking for a replacement of the request-promise package that is deprecated. I tried axios and it generally works, but I am not 100% happy with it, especially because I am getting a strange error that is open on the…

---

## [Authentication with OAuth2 and generating custom JWT Token](https://discourse.nodered.org/t/authentication-with-oauth2-and-generating-custom-jwt-token/78365)

<div class="topic-metadata">

**Author:** [@a\_grunt](https://discourse.nodered.org/u/a_grunt)\
**Replies:** 0\
**Last updated:** [11 May 2023 18:03 UTC](https://discourse.nodered.org/t/authentication-with-oauth2-and-generating-custom-jwt-token/78365 "2023-05-11T18:03:42Z")

</div>

Hi everyone! Is it possible to generate custom authentication token when authenticating via OAuth protocol? I tried to implement custom settings.adminAuth.authenticate() function, as suggested in this topic , but it do…

---

## [BigTimer alternative for sunrise \> sunset](https://discourse.nodered.org/t/bigtimer-alternative-for-sunrise-sunset/78360)

<div class="topic-metadata">

**Author:** [@877](https://discourse.nodered.org/u/877)\
**Replies:** 6\
**Last updated:** [11 May 2023 16:31 UTC](https://discourse.nodered.org/t/bigtimer-alternative-for-sunrise-sunset/78360 "2023-05-11T16:31:45Z")

</div>

I've used BigTimer for many years and it it very good, except I find that the sunrise / sunset times are a bit off (yes I have inputted location coordinates). I find I'm always having to adjust offsets. Are there any ot…

---

## [Parse files and process them based on creation date](https://discourse.nodered.org/t/parse-files-and-process-them-based-on-creation-date/78359)

<div class="topic-metadata">

**Author:** [@Alexandre1987](https://discourse.nodered.org/u/Alexandre1987)\
**Replies:** 1\
**Last updated:** [11 May 2023 15:31 UTC](https://discourse.nodered.org/t/parse-files-and-process-them-based-on-creation-date/78359 "2023-05-11T15:31:15Z")

</div>

Hello everybody, I have a nodered flow that allows me to grab files from an 'orders\_json' folder, convert them to csv and drop them into an 'order\_csv' folder. For technical questions I cannot empty the files deposited…

---

## [Just squares in "chart-image" .png](https://discourse.nodered.org/t/just-squares-in-chart-image-png/78337)

<div class="topic-metadata">

**Author:** [@Miguel](https://discourse.nodered.org/u/Miguel)\
**Replies:** 5\
**Last updated:** [11 May 2023 15:28 UTC](https://discourse.nodered.org/t/just-squares-in-chart-image-png/78337 "2023-05-11T15:28:05Z")

</div>

Hi all I've been struggling with a strange problem generating a chart .png with chart-image node for a while now. All text labels on all axes, values and the header are displayed as squares instead of readable text. L…

---

## [OPCUA Browser doesn't return some nodes](https://discourse.nodered.org/t/opcua-browser-doesnt-return-some-nodes/78358)

<div class="topic-metadata">

**Author:** [@pollivier](https://discourse.nodered.org/u/pollivier)\
**Replies:** 0\
**Last updated:** [11 May 2023 14:24 UTC](https://discourse.nodered.org/t/opcua-browser-doesnt-return-some-nodes/78358 "2023-05-11T14:24:02Z")

</div>

Hello, I'm using the OPCUA -Browser node from node-red-contrib-opcua and it doesn't return some nodes when I use it and I think it's because there are "" in the node id. For exemple ns=3;s="OPCUA". Do you think there …

---

## [Node version used in latest release](https://discourse.nodered.org/t/node-version-used-in-latest-release/78353)

<div class="topic-metadata">

**Author:** [@suraj\_k](https://discourse.nodered.org/u/suraj_k)\
**Replies:** 2\
**Last updated:** [11 May 2023 13:38 UTC](https://discourse.nodered.org/t/node-version-used-in-latest-release/78353 "2023-05-11T13:38:13Z")

</div>

Hi there. I'm facing one issue while trying to install opcua node, it keeps telling me its not compatible on my node version as you can see in following attachment: I wanna know which version of node is used

---

## [Cannot display image using html in ui-template](https://discourse.nodered.org/t/cannot-display-image-using-html-in-ui-template/78314)

<div class="topic-metadata">

**Author:** [@henrychanflag](https://discourse.nodered.org/u/henrychanflag)\
**Replies:** 4\
**Last updated:** [11 May 2023 12:31 UTC](https://discourse.nodered.org/t/cannot-display-image-using-html-in-ui-template/78314 "2023-05-11T12:31:53Z")

</div>

Hi! I try to display my image "water\_sensor.jpg" stored in d drive (d:) using ui-template but failed: \<img src="d:\\water\_sensor.jpg" alt="error" width="500" height="500"\> "error" is shown and the image cannot be displ…

---

## [Trigger a flow if an action is repeated multiple times with in a set period of time](https://discourse.nodered.org/t/trigger-a-flow-if-an-action-is-repeated-multiple-times-with-in-a-set-period-of-time/78341)

<div class="topic-metadata">

**Author:** [@dbs179](https://discourse.nodered.org/u/dbs179)\
**Replies:** 2\
**Last updated:** [11 May 2023 12:20 UTC](https://discourse.nodered.org/t/trigger-a-flow-if-an-action-is-repeated-multiple-times-with-in-a-set-period-of-time/78341 "2023-05-11T12:20:39Z")

</div>

Hi all, I'm using Node Red with my Home Assistant and have a question I haven't been able to figure out. I want to change the profile of my Blue Iris NVR when motion is detected on a camera or cameras multiple times wi…

---

## [NodeRED not finding certificates](https://discourse.nodered.org/t/nodered-not-finding-certificates/78349)

<div class="topic-metadata">

**Author:** [@Justricity](https://discourse.nodered.org/u/Justricity)\
**Replies:** 3\
**Last updated:** [11 May 2023 12:10 UTC](https://discourse.nodered.org/t/nodered-not-finding-certificates/78349 "2023-05-11T12:10:50Z")

</div>

Hey everyone reading this. I am currently trying to crate a subdomain for my NodeRED Webinterface. Since I am using cloudflare i wanted/ need to secure my Webinterface through HTTPS Therefore i commented out the first…

---

## [MQTT connection breaks when deploying, re-established when deploying again](https://discourse.nodered.org/t/mqtt-connection-breaks-when-deploying-re-established-when-deploying-again/78350)

<div class="topic-metadata">

**Author:** [@dieterbk](https://discourse.nodered.org/u/dieterbk)\
**Replies:** 1\
**Last updated:** [11 May 2023 10:39 UTC](https://discourse.nodered.org/t/mqtt-connection-breaks-when-deploying-re-established-when-deploying-again/78350 "2023-05-11T10:39:46Z")

</div>

I have a simple MQTT-IN, with a function behind it. So far everything works as well. But when I change the function and deploy everything, the MQTT connection breaks and does not come back. If I now change the function…

---

## [I want to have a task list](https://discourse.nodered.org/t/i-want-to-have-a-task-list/78343)

<div class="topic-metadata">

**Author:** [@czweb](https://discourse.nodered.org/u/czweb)\
**Replies:** 4\
**Last updated:** [11 May 2023 08:38 UTC](https://discourse.nodered.org/t/i-want-to-have-a-task-list/78343 "2023-05-11T08:38:01Z")

</div>

The attached picture is made by me in PhotoShop. Sometimes I need to execute it line by line according to the task. Not so convenient. Which god can develop such a plug-in

---

## [Excel and Node-RED Integration: How to Map and Show Data?](https://discourse.nodered.org/t/excel-and-node-red-integration-how-to-map-and-show-data/78342)

<div class="topic-metadata">

**Author:** [@khunakon](https://discourse.nodered.org/u/khunakon)\
**Replies:** 1\
**Last updated:** [11 May 2023 08:19 UTC](https://discourse.nodered.org/t/excel-and-node-red-integration-how-to-map-and-show-data/78342 "2023-05-11T08:19:31Z")

</div>

Hello everyone, I'm currently working on a project where I'm using Node-RED to read data from a PLC using the FINS protocol. I've been successful in receiving numeric data from the PLC, but now I want to map this data t…

---

## [Fire a message only once unless it changes](https://discourse.nodered.org/t/fire-a-message-only-once-unless-it-changes/78329)

<div class="topic-metadata">

**Author:** [@Popolackie](https://discourse.nodered.org/u/Popolackie)\
**Replies:** 4\
**Last updated:** [11 May 2023 07:13 UTC](https://discourse.nodered.org/t/fire-a-message-only-once-unless-it-changes/78329 "2023-05-11T07:13:47Z")

</div>

Hi there, I have a question concerning a Solarpanel project. I want to change the setpoint for an inverter via mqtt. The way I did it, the ouput message of a function node is fired everytime the input values come in. Eve…

---

## [🎉 Node-RED 3.1.0-beta.2 released](https://discourse.nodered.org/t/node-red-3-1-0-beta-2-released/76192)

<div class="topic-metadata">

**Author:** [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Replies:** 71\
**Last updated:** [11 May 2023 07:05 UTC](https://discourse.nodered.org/t/node-red-3-1-0-beta-2-released/76192 "2023-05-11T07:05:30Z")

</div>

:tada: We have now published the second beta release of Node-RED 3.1. Node-RED 3.x requires at least Node 14.x, but that reaches end-of-life in a couple months. These days you should really be using Node 16 at least or …

---

## [How to determine total amount of running machines](https://discourse.nodered.org/t/how-to-determine-total-amount-of-running-machines/78330)

<div class="topic-metadata">

**Author:** [@Daims](https://discourse.nodered.org/u/Daims)\
**Replies:** 3\
**Last updated:** [11 May 2023 06:16 UTC](https://discourse.nodered.org/t/how-to-determine-total-amount-of-running-machines/78330 "2023-05-11T06:16:37Z")

</div>

Hi all, I am currently working on a project where i am receiving the state of different machines (state 1= machine on, state 2= machine running). The machines send their state every 10 seconds. There is roughly 25 mac…

---

## [Whistle Pet Tracker Token-based API](https://discourse.nodered.org/t/whistle-pet-tracker-token-based-api/78326)

<div class="topic-metadata">

**Author:** [@mrdvt92](https://discourse.nodered.org/u/mrdvt92)\
**Replies:** 1\
**Last updated:** [11 May 2023 05:10 UTC](https://discourse.nodered.org/t/whistle-pet-tracker-token-based-api/78326 "2023-05-11T05:10:01Z")

</div>

I have a Whistle Pet Tracker and the web service API is quite simple. I have recreated the service in Perl from Python to figure it out. But, I'd like to make it a node since I'm moving all of my home network to node-r…

---

## [Mqtt question: topic in inject node vs properties (topic) in mqtt node](https://discourse.nodered.org/t/mqtt-question-topic-in-inject-node-vs-properties-topic-in-mqtt-node/78339)

<div class="topic-metadata">

**Author:** [@kenkoknz](https://discourse.nodered.org/u/kenkoknz)\
**Replies:** 2\
**Last updated:** [11 May 2023 00:49 UTC](https://discourse.nodered.org/t/mqtt-question-topic-in-inject-node-vs-properties-topic-in-mqtt-node/78339 "2023-05-11T00:49:55Z")

</div>

Hi, I am playing around to connect to thingspeak via mqtt using the mqtt node. Initially I send a payload with the appropriate topic in the inject node: That did not work... However, when I added the topic in th…

---

## [Combine time and motiondetector?](https://discourse.nodered.org/t/combine-time-and-motiondetector/78320)

<div class="topic-metadata">

**Author:** [@FSHelgeland](https://discourse.nodered.org/u/FSHelgeland)\
**Replies:** 4\
**Last updated:** [10 May 2023 19:39 UTC](https://discourse.nodered.org/t/combine-time-and-motiondetector/78320 "2023-05-10T19:39:20Z")

</div>

\[ { "id": "f3ea71643a175185", "type": "tab", "label": "Motion and Timer", "disabled": false, "info": "" }, { "id": "06d052e7017b5cd4", "type": "inject",…

---

## [Text-entry node for the flow editor?](https://discourse.nodered.org/t/text-entry-node-for-the-flow-editor/78159)

<div class="topic-metadata">

**Author:** [@BigGuyWhoKills](https://discourse.nodered.org/u/BigGuyWhoKills)\
**Replies:** 3\
**Last updated:** [10 May 2023 18:38 UTC](https://discourse.nodered.org/t/text-entry-node-for-the-flow-editor/78159 "2023-05-10T18:38:57Z")

</div>

Is there a node that allows text entry in the flow editor? Similar to an inject node, but where the text-entry box is always open. I want to use this for setting flow variables. Ideally, it would also show the current…

---

## [Automated Bedroom Light Control with Node-RED](https://discourse.nodered.org/t/automated-bedroom-light-control-with-node-red/78321)

<div class="topic-metadata">

**Author:** [@ronyn77](https://discourse.nodered.org/u/ronyn77)\
**Replies:** 2\
**Last updated:** [10 May 2023 17:38 UTC](https://discourse.nodered.org/t/automated-bedroom-light-control-with-node-red/78321 "2023-05-10T17:38:26Z")

</div>

I would like to build a Node-RED flow that does the following: At exactly 10:00 PM, it should turn off the bedroom light if it's on. If I turn on the light, a timer will check how much time has passed since I turned on t…

---

## [Help Please! #CSS, #Javascript,#HTML](https://discourse.nodered.org/t/help-please-css-javascript-html/78229)

<div class="topic-metadata">

**Author:** [@Longhorn1988](https://discourse.nodered.org/u/Longhorn1988)\
**Replies:** 6\
**Last updated:** [10 May 2023 16:57 UTC](https://discourse.nodered.org/t/help-please-css-javascript-html/78229 "2023-05-10T16:57:08Z")

</div>

Can someone explain me how can i use like this code (CSS+JS+HTML) in Node-Red?

---

## [Eztimer and Time Range nodes have sunrise for next day](https://discourse.nodered.org/t/eztimer-and-time-range-nodes-have-sunrise-for-next-day/78268)

<div class="topic-metadata">

**Author:** [@vbtrek](https://discourse.nodered.org/u/vbtrek)\
**Replies:** 9\
**Last updated:** [10 May 2023 14:12 UTC](https://discourse.nodered.org/t/eztimer-and-time-range-nodes-have-sunrise-for-next-day/78268 "2023-05-10T14:12:43Z")

</div>

Latest update to node rod 3.0.2 is causing all my time nodes that monitor sunrise to give sunrise for the following day. Been working fine for years and just started doing this. Any suggestions?

---

## [Node disconnection detection](https://discourse.nodered.org/t/node-disconnection-detection/78316)

<div class="topic-metadata">

**Author:** [@Bharatv7370](https://discourse.nodered.org/u/Bharatv7370)\
**Replies:** 1\
**Last updated:** [10 May 2023 13:31 UTC](https://discourse.nodered.org/t/node-disconnection-detection/78316 "2023-05-10T13:31:42Z")

</div>

Hello Friends, Can anyone tell us how we can detect the node is disconnected in the flow? for e.g., I am using MQTT in node & converting the data & passing it to some process function. Now sometimes the MQTT node gets …

---

## [Using boolean status from context](https://discourse.nodered.org/t/using-boolean-status-from-context/78306)

<div class="topic-metadata">

**Author:** [@abandonedhandrail](https://discourse.nodered.org/u/abandonedhandrail)\
**Replies:** 7\
**Last updated:** [10 May 2023 12:28 UTC](https://discourse.nodered.org/t/using-boolean-status-from-context/78306 "2023-05-10T12:28:35Z")

</div>

Evening all, I'm tring to find a way to use true/false status of an object stored in context to drive some later code. I'm hoping to read multiple values (and booleans) from context into multiple payloads, and have mult…

---

## [Value exceeds the limit when its converted from string to json](https://discourse.nodered.org/t/value-exceeds-the-limit-when-its-converted-from-string-to-json/78204)

<div class="topic-metadata">

**Author:** [@colin0031](https://discourse.nodered.org/u/colin0031)\
**Replies:** 11\
**Last updated:** [10 May 2023 10:59 UTC](https://discourse.nodered.org/t/value-exceeds-the-limit-when-its-converted-from-string-to-json/78204 "2023-05-10T10:59:04Z")

</div>

Hello, I am getting a value from a robot (738775312330130003) but when I am converting into object I am getting the value(738775312330130000) with last two numbers as zero zero always. I assume that its because the val…

---

## [Node-red-contrib-ibm-db2 error with Db2 in](https://discourse.nodered.org/t/node-red-contrib-ibm-db2-error-with-db2-in/78192)

<div class="topic-metadata">

**Author:** [@pferreira](https://discourse.nodered.org/u/pferreira)\
**Replies:** 5\
**Last updated:** [10 May 2023 10:15 UTC](https://discourse.nodered.org/t/node-red-contrib-ibm-db2-error-with-db2-in/78192 "2023-05-10T10:15:27Z")

</div>

I’m looking to leverage node-RED to connect to a DB2 docker image I have running. However, when set it up, I get this error (I have node-red running on docker as I have a MacOS device): “Error: Error loading shared libr…

---

## [Send a value to influxdb in a defined time interval](https://discourse.nodered.org/t/send-a-value-to-influxdb-in-a-defined-time-interval/78303)

<div class="topic-metadata">

**Author:** [@trombose009](https://discourse.nodered.org/u/trombose009)\
**Replies:** 8\
**Last updated:** [10 May 2023 09:21 UTC](https://discourse.nodered.org/t/send-a-value-to-influxdb-in-a-defined-time-interval/78303 "2023-05-10T09:21:46Z")

</div>

Hello, I have an electricity meter which outputs the current flow via blink code. This arrives via mqtt in node red. If little current flows, the time between the incoming values is greater, if much current flows, the …

---

## [Clarify Dashboards](https://discourse.nodered.org/t/clarify-dashboards/78300)

<div class="topic-metadata">

**Author:** [@Paul-Reed](https://discourse.nodered.org/u/Paul-Reed)\
**Replies:** 1\
**Last updated:** [10 May 2023 07:25 UTC](https://discourse.nodered.org/t/clarify-dashboards/78300 "2023-05-10T07:25:36Z")

</div>

Anyone tried the new Clarify dashboards (Clarify call them 'Boards')? You may recall that Bernt-Johan - @bbergshaven introduced himself in the forum last year as one of the founders of Clarify, and kindly offered to all…

[Previous page](https://discourse.nodered.org/latest.md?no_subcategories=false&page=346)

[Next page](https://discourse.nodered.org/latest.md?no_subcategories=false&page=348)