# Latest

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

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

**Page:** 528

---

## [SIP ringer/strobe](https://discourse.nodered.org/t/sip-ringer-strobe/65644)

<div class="topic-metadata">

**Author:** [@talesmaschio](https://discourse.nodered.org/u/talesmaschio)\
**Replies:** 4\
**Last updated:** [26 July 2022 20:51 UTC](https://discourse.nodered.org/t/sip-ringer-strobe/65644 "2022-07-26T20:51:45Z")

</div>

Hello all, I'm looking for a way to alert people about incoming phone calls in a noisy environment. The telephony system is full IP/SIP based. I'm aware of SIP strobes like the ones from Cyberdata but they cost a lot an…

---

## [I have 4 entities in Home assistant that I need to switch a switch when they all change state](https://discourse.nodered.org/t/i-have-4-entities-in-home-assistant-that-i-need-to-switch-a-switch-when-they-all-change-state/65608)

<div class="topic-metadata">

**Author:** [@keithcrooks1](https://discourse.nodered.org/u/keithcrooks1)\
**Replies:** 5\
**Last updated:** [26 July 2022 20:44 UTC](https://discourse.nodered.org/t/i-have-4-entities-in-home-assistant-that-i-need-to-switch-a-switch-when-they-all-change-state/65608 "2022-07-26T20:44:27Z")

</div>

Hi guys, I use Home assistant, I have 2 entities that are phones and show either Home or away and 2 entities that either show Kitchen or not\_home I need ro create a group or 2 groups that when all 4 items show away or…

---

## [How to flush serial request node](https://discourse.nodered.org/t/how-to-flush-serial-request-node/65486)

<div class="topic-metadata">

**Author:** [@dsplitz](https://discourse.nodered.org/u/dsplitz)\
**Replies:** 9\
**Last updated:** [26 July 2022 20:38 UTC](https://discourse.nodered.org/t/how-to-flush-serial-request-node/65486 "2022-07-26T20:38:59Z")

</div>

I have a function that sends a file over the serial port. I parse the file into messages sent via the "serial request" node. Is there a way to flush the buffered messages so I don't have to wait for each one to timeout i…

---

## [NodeRed Update V2\>3: Password protection removed](https://discourse.nodered.org/t/nodered-update-v2-3-password-protection-removed/65590)

<div class="topic-metadata">

**Author:** [@dsporer](https://discourse.nodered.org/u/dsporer)\
**Replies:** 10\
**Last updated:** [26 July 2022 19:21 UTC](https://discourse.nodered.org/t/nodered-update-v2-3-password-protection-removed/65590 "2022-07-26T19:21:21Z")

</div>

Does anyone know the background? Is this to be expected with every update via the script?

---

## [Serial message structure](https://discourse.nodered.org/t/serial-message-structure/65648)

<div class="topic-metadata">

**Author:** [@RemyH](https://discourse.nodered.org/u/RemyH)\
**Replies:** 4\
**Last updated:** [26 July 2022 18:24 UTC](https://discourse.nodered.org/t/serial-message-structure/65648 "2022-07-26T18:24:24Z")

</div>

Bonjour If someone can tell me what I'm missing to have the same format of the message that I want to send by an rf433 frame the first is OK and the second is NOK thanks in advance

---

## [PSQL Node "Syntax Error" at UPDATE](https://discourse.nodered.org/t/psql-node-syntax-error-at-update/65651)

<div class="topic-metadata">

**Author:** [@davidrodord56](https://discourse.nodered.org/u/davidrodord56)\
**Replies:** 0\
**Last updated:** [26 July 2022 18:00 UTC](https://discourse.nodered.org/t/psql-node-syntax-error-at-update/65651 "2022-07-26T18:00:28Z")

</div>

Hi everybody, does anybody knows why I'm Getting this error in postgres node? The error is: Blockquote "error: syntax error at or near "WHERE"" The node Query is: UPDATE public.km\_tracker SET km = {{msg.payload.km}…

---

## [Trouble getting Persistent Storage to work](https://discourse.nodered.org/t/trouble-getting-persistent-storage-to-work/65639)

<div class="topic-metadata">

**Author:** [@SSHIntoMe](https://discourse.nodered.org/u/SSHIntoMe)\
**Replies:** 13\
**Last updated:** [26 July 2022 17:22 UTC](https://discourse.nodered.org/t/trouble-getting-persistent-storage-to-work/65639 "2022-07-26T17:22:25Z")

</div>

When attempting to store variables, they simply get lost upon reboot. This is my settings.js: module.exports = { flowFile: 'flows.json', flowFilePretty: true, contextStorage: { default: "memoryOnly", memoryOnly: …

---

## [How to save writing with if and else in function node](https://discourse.nodered.org/t/how-to-save-writing-with-if-and-else-in-function-node/65274)

<div class="topic-metadata">

**Author:** [@devifast](https://discourse.nodered.org/u/devifast)\
**Replies:** 29\
**Last updated:** [26 July 2022 17:21 UTC](https://discourse.nodered.org/t/how-to-save-writing-with-if-and-else-in-function-node/65274 "2022-07-26T17:21:35Z")

</div>

Hello, I am sending you sample code. I am not at all experienced in this field. My question is, is there a way to abbreviate this? Greetings. //solar pump to pool on,off var slrpool\_on = { payload: 1}; var slrpool\_o…

---

## [Websockets passing all msg properties as payload instead of discrete](https://discourse.nodered.org/t/websockets-passing-all-msg-properties-as-payload-instead-of-discrete/65369)

<div class="topic-metadata">

**Author:** [@Rgrove](https://discourse.nodered.org/u/Rgrove)\
**Replies:** 7\
**Last updated:** [26 July 2022 16:07 UTC](https://discourse.nodered.org/t/websockets-passing-all-msg-properties-as-payload-instead-of-discrete/65369 "2022-07-26T16:07:51Z")

</div>

Good morning! Edited for less words... I have two RPi's. Flow set up on Site A, then copied to Site B, with some unique params changed (site ID, temp sensors serial's). Both send data via websockets to a master NodeR…

---

## [SEND SMS from NODE RED using HUAWEI E8372 WINGLE](https://discourse.nodered.org/t/send-sms-from-node-red-using-huawei-e8372-wingle/65621)

<div class="topic-metadata">

**Author:** [@baji\_l](https://discourse.nodered.org/u/baji_l)\
**Replies:** 3\
**Last updated:** [26 July 2022 14:57 UTC](https://discourse.nodered.org/t/send-sms-from-node-red-using-huawei-e8372-wingle/65621 "2022-07-26T14:57:18Z")

</div>

Hi I am newbie with Node red, Exploring just over few months, working on a test project to send SMS using HUAWEI-SEND-SMS node. the wingle device is in the approved list and I am able to send SMS no issue. If the trigger…

---

## [Local Node Red Website Rspond in Node Red](https://discourse.nodered.org/t/local-node-red-website-rspond-in-node-red/65528)

<div class="topic-metadata">

**Author:** [@Worscht](https://discourse.nodered.org/u/Worscht)\
**Replies:** 5\
**Last updated:** [26 July 2022 13:59 UTC](https://discourse.nodered.org/t/local-node-red-website-rspond-in-node-red/65528 "2022-07-26T13:59:58Z")

</div>

Hello, i got this own Webside for node Red (HTML,CSS) and i am looking for a simple script that i get an output when i click on The buttons of this Dashboard. But i have no idea how Java Script works may someone could …

---

## [Error in node tfcocossd](https://discourse.nodered.org/t/error-in-node-tfcocossd/65522)

<div class="topic-metadata">

**Author:** [@faridomu](https://discourse.nodered.org/u/faridomu)\
**Replies:** 4\
**Last updated:** [26 July 2022 13:00 UTC](https://discourse.nodered.org/t/error-in-node-tfcocossd/65522 "2022-07-26T13:00:25Z")

</div>

Hello everyone I have problem using node tfcocossd on my image detection flow. I tried my flow on my local server and raspberry pi server. when I tried in local server, it worked. But when i try in raspberry pi, i got …

---

## [Uploading file in filemaker](https://discourse.nodered.org/t/uploading-file-in-filemaker/65564)

<div class="topic-metadata">

**Author:** [@mebsn](https://discourse.nodered.org/u/mebsn)\
**Replies:** 4\
**Last updated:** [26 July 2022 10:53 UTC](https://discourse.nodered.org/t/uploading-file-in-filemaker/65564 "2022-07-26T10:53:32Z")

</div>

hello, guys i am trying to upload file in an existing filemaker record, and i am using record Id in which i want to add file, but it tells me that recordId access is denied, any help?

---

## [SQLite Error - Exporting data to sql database](https://discourse.nodered.org/t/sqlite-error-exporting-data-to-sql-database/65599)

<div class="topic-metadata">

**Author:** [@keshavvasudeva](https://discourse.nodered.org/u/keshavvasudeva)\
**Replies:** 4\
**Last updated:** [26 July 2022 10:35 UTC](https://discourse.nodered.org/t/sqlite-error-exporting-data-to-sql-database/65599 "2022-07-26T10:35:23Z")

</div>

I have the following code in Node Red: msg = { "topic": "INSERT INTO TestTable (PV, SV) values (" + "'" + parseFloat(flow.get("PV") / 10) + "," + parseFloat(flow.get("SV")) + "')", } return msg; However, I am gettin…

---

## [Change html class based on variable value](https://discourse.nodered.org/t/change-html-class-based-on-variable-value/65482)

<div class="topic-metadata">

**Author:** [@scoobie71](https://discourse.nodered.org/u/scoobie71)\
**Replies:** 9\
**Last updated:** [26 July 2022 10:09 UTC](https://discourse.nodered.org/t/change-html-class-based-on-variable-value/65482 "2022-07-26T10:09:22Z")

</div>

On my message i have a boolean property called state. (msg.state). I am using an html template with a button on it. I havbe created two css classes, one with red background and one with green. When the msg.state is tru…

---

## [Node-red-node-email error](https://discourse.nodered.org/t/node-red-node-email-error/65629)

<div class="topic-metadata">

**Author:** [@Ti-Reks](https://discourse.nodered.org/u/Ti-Reks)\
**Replies:** 0\
**Last updated:** [26 July 2022 07:41 UTC](https://discourse.nodered.org/t/node-red-node-email-error/65629 "2022-07-26T07:41:25Z")

</div>

Receiving email with an attachment does not work correctly. Content-Type: text/plain; charset=windows-1251; name="60510Q01.PP7" Content-Disposition: attachment; filename="60510Q01.PP7" Content-Transfer-Encoding: 8bit …

---

## [Xml validation against with xsd node red](https://discourse.nodered.org/t/xml-validation-against-with-xsd-node-red/65625)

<div class="topic-metadata">

**Author:** [@chawana](https://discourse.nodered.org/u/chawana)\
**Replies:** 0\
**Last updated:** [26 July 2022 05:44 UTC](https://discourse.nodered.org/t/xml-validation-against-with-xsd-node-red/65625 "2022-07-26T05:44:08Z")

</div>

Anyone have sample flow for xml validation against with xsd

---

## [Lost Holding Register Data every time I deploy project on Node-RED](https://discourse.nodered.org/t/lost-holding-register-data-every-time-i-deploy-project-on-node-red/65619)

<div class="topic-metadata">

**Author:** [@SachinKumar-tech](https://discourse.nodered.org/u/SachinKumar-tech)\
**Replies:** 2\
**Last updated:** [26 July 2022 04:12 UTC](https://discourse.nodered.org/t/lost-holding-register-data-every-time-i-deploy-project-on-node-red/65619 "2022-07-26T04:12:50Z")

</div>

I am working on MODBUS-Server Node And used one IP address to configure & Connect it via Master Device. Every time I deploy Project on Node-RED Server , I lost my Holding Register Data.

---

## [When using MC read, there will be a timeout problem when inserting data](https://discourse.nodered.org/t/when-using-mc-read-there-will-be-a-timeout-problem-when-inserting-data/65568)

<div class="topic-metadata">

**Author:** [@SNWBS](https://discourse.nodered.org/u/SNWBS)\
**Replies:** 3\
**Last updated:** [26 July 2022 03:06 UTC](https://discourse.nodered.org/t/when-using-mc-read-there-will-be-a-timeout-problem-when-inserting-data/65568 "2022-07-26T03:06:19Z")

</div>

I just entered the field of Node-red, so I don't know how to use it yet. MC read is indeed connected to the PLC, but there will be errors when transmitting data. Is there any way to improve it, or increase the max age? …

---

## [Help with email attachments](https://discourse.nodered.org/t/help-with-email-attachments/65533)

<div class="topic-metadata">

**Author:** [@billyballbag](https://discourse.nodered.org/u/billyballbag)\
**Replies:** 5\
**Last updated:** [25 July 2022 21:14 UTC](https://discourse.nodered.org/t/help-with-email-attachments/65533 "2022-07-25T21:14:59Z")

</div>

Hi all, I’m looking for some help with a flow I’m working on, it essentially takes emails in via SMTP and then pushes them to an API, I’ve got it working with the text payload of the message but now need to figure out h…

---

## [Sqlite query not working with mustache query](https://discourse.nodered.org/t/sqlite-query-not-working-with-mustache-query/65607)

<div class="topic-metadata">

**Author:** [@scoobie71](https://discourse.nodered.org/u/scoobie71)\
**Replies:** 2\
**Last updated:** [25 July 2022 20:56 UTC](https://discourse.nodered.org/t/sqlite-query-not-working-with-mustache-query/65607 "2022-07-25T20:56:10Z")

</div>

I am using a template node to execute a query in sqlite using the msg.topic. My query is: select \* from rfidtaglist where id={{payload.id}}; On the debug i can see that in the query paylaod.id is replaced by an integ…

---

## [Connection Refused in Azure IOT HUB](https://discourse.nodered.org/t/connection-refused-in-azure-iot-hub/65518)

<div class="topic-metadata">

**Author:** [@bachloo.rahul](https://discourse.nodered.org/u/bachloo.rahul)\
**Replies:** 5\
**Last updated:** [25 July 2022 20:14 UTC](https://discourse.nodered.org/t/connection-refused-in-azure-iot-hub/65518 "2022-07-25T20:14:50Z")

</div>

\[ { "id": "1c0fb3c4214105c2", "type": "tab", "label": "Flow 3", "disabled": false, "info": "", "env": \[\] }, { "id": "191eb7ca.b71a8", "type": "a…

---

## [Authentication with cookies to log who has pressed a certain button](https://discourse.nodered.org/t/authentication-with-cookies-to-log-who-has-pressed-a-certain-button/65483)

<div class="topic-metadata">

**Author:** [@Giu-seppe](https://discourse.nodered.org/u/Giu-seppe)\
**Replies:** 4\
**Last updated:** [25 July 2022 19:56 UTC](https://discourse.nodered.org/t/authentication-with-cookies-to-log-who-has-pressed-a-certain-button/65483 "2022-07-25T19:56:37Z")

</div>

hi guys, I am trying to implement a new feature in my application. I would need to understand, among a list of users, which user has pressed a certain button within the dashboard and log it. I don't need the feature t…

---

## [Http-request error](https://discourse.nodered.org/t/http-request-error/65597)

<div class="topic-metadata">

**Author:** [@Swissurs](https://discourse.nodered.org/u/Swissurs)\
**Replies:** 6\
**Last updated:** [25 July 2022 19:50 UTC](https://discourse.nodered.org/t/http-request-error/65597 "2022-07-25T19:50:24Z")

</div>

Hi, I can get data with the following request in browser https://192.168.0.74:1443/api/config/flags But in nod red - http request there is a error - unable\_to\_veryfy\_leaf-signature. see also pic for debug infos T…

---

## [Node red remote access](https://discourse.nodered.org/t/node-red-remote-access/65506)

<div class="topic-metadata">

**Author:** [@Branchy29](https://discourse.nodered.org/u/Branchy29)\
**Replies:** 6\
**Last updated:** [25 July 2022 18:18 UTC](https://discourse.nodered.org/t/node-red-remote-access/65506 "2022-07-25T18:18:03Z")

</div>

Hi All, Im trying to Controll a raspberry Pi with node red on via a remote location , the PI is connected to a mobile router with a good data plan but I want to be able to remote in and activate the UI on the node red f…

---

## [Unknown node types](https://discourse.nodered.org/t/unknown-node-types/65579)

<div class="topic-metadata">

**Author:** [@Swissurs](https://discourse.nodered.org/u/Swissurs)\
**Replies:** 2\
**Last updated:** [25 July 2022 18:15 UTC](https://discourse.nodered.org/t/unknown-node-types/65579 "2022-07-25T18:15:11Z")

</div>

Hi, how to find the required node if get message unknown node types I import a sample and try to deploy. The message ui\_group unknown node type is shown. I installed several nodes but could not found the ui\_group than…

---

## [Nodered process burning cpu resources](https://discourse.nodered.org/t/nodered-process-burning-cpu-resources/65584)

<div class="topic-metadata">

**Author:** [@FeliceM](https://discourse.nodered.org/u/FeliceM)\
**Replies:** 11\
**Last updated:** [25 July 2022 17:05 UTC](https://discourse.nodered.org/t/nodered-process-burning-cpu-resources/65584 "2022-07-25T17:05:23Z")

</div>

I have a box with Ubuntu that I use to write and test scripts and nodes. I found it was quite unresponsive and Started investigating who is taking 300% of the resources. I did found the following process and files to b…

---

## [httpStatic and projects (followup and solution)](https://discourse.nodered.org/t/httpstatic-and-projects-followup-and-solution/65596)

<div class="topic-metadata">

**Author:** [@he\_nodered](https://discourse.nodered.org/u/he_nodered)\
**Replies:** 0\
**Last updated:** [25 July 2022 17:03 UTC](https://discourse.nodered.org/t/httpstatic-and-projects-followup-and-solution/65596 "2022-07-25T17:03:41Z")

</div>

As now V3.0 is out, I've thought, that I look into this again - the main idea was to add static html/js/png-files to the project and serve these through the node-red-dashboard (see my original post here: httpStatic and p…

---

## [CSV file - last line require](https://discourse.nodered.org/t/csv-file-last-line-require/11153)

<div class="topic-metadata">

**Author:** [@frobek](https://discourse.nodered.org/u/frobek)\
**Replies:** 5\
**Last updated:** [25 July 2022 16:25 UTC](https://discourse.nodered.org/t/csv-file-last-line-require/11153 "2022-07-25T16:25:29Z")

</div>

Hello, This is my first post, so let me introduce myself. My name is Robert and I am from Poland, I just start my adventure with node red, so forgive me some illy questions. I have a CSV file from dropbox. The file is …

---

## [How get only one value from a CSV file](https://discourse.nodered.org/t/how-get-only-one-value-from-a-csv-file/65444)

<div class="topic-metadata">

**Author:** [@Disaile12](https://discourse.nodered.org/u/Disaile12)\
**Replies:** 5\
**Last updated:** [25 July 2022 16:22 UTC](https://discourse.nodered.org/t/how-get-only-one-value-from-a-csv-file/65444 "2022-07-25T16:22:20Z")

</div>

Hello, I have a query. I am currently graphing a data series from a .CSV file and everything is perfect, but now I need to grab the last recorded value of a single column in particular. The file contains 4 columns, A,B,C…

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

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