# Latest

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

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

**Page:** 514

---

## [Would a wemo insight have to be polled to act on energy usage changes?](https://discourse.nodered.org/t/would-a-wemo-insight-have-to-be-polled-to-act-on-energy-usage-changes/66671)

<div class="topic-metadata">

**Author:** [@hepcat72](https://discourse.nodered.org/u/hepcat72)\
**Replies:** 6\
**Last updated:** [20 August 2022 15:32 UTC](https://discourse.nodered.org/t/would-a-wemo-insight-have-to-be-polled-to-act-on-energy-usage-changes/66671 "2022-08-20T15:32:24Z")

</div>

...or does a wemo insight node instance on a flow continuously stream usage information? I'm trying to decide between getting a wemo insight versus another Sonoff S31 15A. The Sonoff (flashed with tasmota) can reach out…

---

## [Version v3.0.2 seems not compatible with @particle/node-red-contrib-particle-official 0.1.7](https://discourse.nodered.org/t/version-v3-0-2-seems-not-compatible-with-particle-node-red-contrib-particle-official-0-1-7/66505)

<div class="topic-metadata">

**Author:** [@pacitoali](https://discourse.nodered.org/u/pacitoali)\
**Replies:** 3\
**Last updated:** [20 August 2022 13:37 UTC](https://discourse.nodered.org/t/version-v3-0-2-seems-not-compatible-with-particle-node-red-contrib-particle-official-0-1-7/66505 "2022-08-20T13:37:50Z")

</div>

With version v3.0.2 my NR docker server (node.js v16) stop every 7776 seconds (about 129 minutes), the time for reauthentication. I was able to solve it in two ways: reverting NR to v2.2.2 or changing the res.body.expir…

---

## [Chart node does not show stored data](https://discourse.nodered.org/t/chart-node-does-not-show-stored-data/66697)

<div class="topic-metadata">

**Author:** [@27plants](https://discourse.nodered.org/u/27plants)\
**Replies:** 6\
**Last updated:** [20 August 2022 13:37 UTC](https://discourse.nodered.org/t/chart-node-does-not-show-stored-data/66697 "2022-08-20T13:37:38Z")

</div>

Hi, sorry I'm new to node-red but i have an issue regarding the chart node. My "show cloud coverage for the day" does't work even if the data seems good (see debug 1). The chart just seems empty. I'm unsure of wh…

---

## [NR + MQTT as standalone server - opinions](https://discourse.nodered.org/t/nr-mqtt-as-standalone-server-opinions/64618)

<div class="topic-metadata">

**Author:** [@PizzaProgram](https://discourse.nodered.org/u/PizzaProgram)\
**Replies:** 3\
**Last updated:** [20 August 2022 12:58 UTC](https://discourse.nodered.org/t/nr-mqtt-as-standalone-server-opinions/64618 "2022-08-20T12:58:36Z")

</div>

I've searched everything 3 weeks long, and now I'm here to ask for any opinions or experiense about: What would be the best praktice to run NR + MQTT on a "public" VPS ? The Job: ... would be to handle ca 50 pizzerias b…

---

## [Re-run different nodes at different times](https://discourse.nodered.org/t/re-run-different-nodes-at-different-times/66693)

<div class="topic-metadata">

**Author:** [@mrks1337](https://discourse.nodered.org/u/mrks1337)\
**Replies:** 1\
**Last updated:** [20 August 2022 12:16 UTC](https://discourse.nodered.org/t/re-run-different-nodes-at-different-times/66693 "2022-08-20T12:16:05Z")

</div>

Hi! I have the following Flow created to login with an API and then fetch data from a second endpoint. \[ { "id": "4d1f98b0.642758", "type": "http request", "z": "c155aa476d7d3fe2", "…

---

## [How to insert in a database?](https://discourse.nodered.org/t/how-to-insert-in-a-database/66435)

<div class="topic-metadata">

**Author:** [@mykerinos1](https://discourse.nodered.org/u/mykerinos1)\
**Replies:** 47\
**Last updated:** [20 August 2022 09:48 UTC](https://discourse.nodered.org/t/how-to-insert-in-a-database/66435 "2022-08-20T09:48:14Z")

</div>

Hello, i just created a new database and i'd like to insert data coming from a "http Request "that output is a parsed json object but i d on't know how to doCan you help me insert these data ? i created my sql node and…

---

## [How to set a global var with dynamic index on change node](https://discourse.nodered.org/t/how-to-set-a-global-var-with-dynamic-index-on-change-node/66627)

<div class="topic-metadata">

**Author:** [@VMarques](https://discourse.nodered.org/u/VMarques)\
**Replies:** 3\
**Last updated:** [20 August 2022 00:10 UTC](https://discourse.nodered.org/t/how-to-set-a-global-var-with-dynamic-index-on-change-node/66627 "2022-08-20T00:10:08Z")

</div>

Hi There guys, I am trying to, read a file containing a json string (all fine here), parse the keys and declare global vars with the name from the json, The flow looks like this, Split node loads the var name in …

---

## [How to connect node red at distance?](https://discourse.nodered.org/t/how-to-connect-node-red-at-distance/66537)

<div class="topic-metadata">

**Author:** [@azertym](https://discourse.nodered.org/u/azertym)\
**Replies:** 8\
**Last updated:** [19 August 2022 23:32 UTC](https://discourse.nodered.org/t/how-to-connect-node-red-at-distance/66537 "2022-08-19T23:32:02Z")

</div>

Hi all, I would like to know if it's possible to connect in node red at distance without local ip ? My pi is at 1000 km from me, and i would like to connect at node-red without VNC. The best method for me it's to type…

---

## [Raspberry Pi PLC Analog Read Problem](https://discourse.nodered.org/t/raspberry-pi-plc-analog-read-problem/66677)

<div class="topic-metadata">

**Author:** [@locutus](https://discourse.nodered.org/u/locutus)\
**Replies:** 3\
**Last updated:** [19 August 2022 22:22 UTC](https://discourse.nodered.org/t/raspberry-pi-plc-analog-read-problem/66677 "2022-08-19T22:22:41Z")

</div>

Hey all, completely new to node-red. I'm trying to use the analog read node to read off of an analog pressure sensor on a RPI PLC shield. Right now I'm just connecting 5 V to I0.5 pin (which is the analog/digital input p…

---

## [JSON Sqlite database query .. 2 into 1?](https://discourse.nodered.org/t/json-sqlite-database-query-2-into-1/66673)

<div class="topic-metadata">

**Author:** [@questuk](https://discourse.nodered.org/u/questuk)\
**Replies:** 1\
**Last updated:** [19 August 2022 17:08 UTC](https://discourse.nodered.org/t/json-sqlite-database-query-2-into-1/66673 "2022-08-19T17:08:48Z")

</div>

Hi, Sorry for asking here,but I have tried on a Sqlite forum and so far no answers. :pensive: But I know on here your are knowledgeable and some use JSON and SQlite. I have a JSON SQLite database, at the moment I use …

---

## [Splitting a konstant data stream into 200 sub streams](https://discourse.nodered.org/t/splitting-a-konstant-data-stream-into-200-sub-streams/66665)

<div class="topic-metadata">

**Author:** [@edstobi](https://discourse.nodered.org/u/edstobi)\
**Replies:** 2\
**Last updated:** [19 August 2022 13:35 UTC](https://discourse.nodered.org/t/splitting-a-konstant-data-stream-into-200-sub-streams/66665 "2022-08-19T13:35:19Z")

</div>

hello i am turning to you again today as i need an idea on how to implement a flow reasonably, briefly and efficiently. I get a constant stream of values via a single function. This is several hundred a minute, but th…

---

## [Run as service from c++ program](https://discourse.nodered.org/t/run-as-service-from-c-program/66653)

<div class="topic-metadata">

**Author:** [@Lupin\_III](https://discourse.nodered.org/u/Lupin_III)\
**Replies:** 6\
**Last updated:** [19 August 2022 13:24 UTC](https://discourse.nodered.org/t/run-as-service-from-c-program/66653 "2022-08-19T13:24:26Z")

</div>

Hi, I'm facing this problem, even if I know it isn't strictly related with node-red itself. I have installed node-red on debian with the raccomanded script, so I can run it as service. My problem is that I don't have t…

---

## [How to connect DB node to a local server?](https://discourse.nodered.org/t/how-to-connect-db-node-to-a-local-server/66648)

<div class="topic-metadata">

**Author:** [@mykerinos1](https://discourse.nodered.org/u/mykerinos1)\
**Replies:** 2\
**Last updated:** [19 August 2022 12:00 UTC](https://discourse.nodered.org/t/how-to-connect-db-node-to-a-local-server/66648 "2022-08-19T12:00:59Z")

</div>

Hello. i moved my database on my local server sinology. I don't know how to set DB node. because nodered is on a raspberry and database is with an other ip. So if i set localhost it doesnt work. if i set server ip like h…

---

## [SQLite data into PDF report](https://discourse.nodered.org/t/sqlite-data-into-pdf-report/65782)

<div class="topic-metadata">

**Author:** [@SplitSecComp](https://discourse.nodered.org/u/SplitSecComp)\
**Replies:** 35\
**Last updated:** [19 August 2022 10:45 UTC](https://discourse.nodered.org/t/sqlite-data-into-pdf-report/65782 "2022-08-19T10:45:21Z")

</div>

Hi. I want to display SQLite data in a PDF report in a table format. I can get the PDF file to work as well as the table in in the PDF file with PDFMake. I can also get the SQL data out of the data basis with queries. H…

---

## [Ui template: content disappeared on send](https://discourse.nodered.org/t/ui-template-content-disappeared-on-send/66658)

<div class="topic-metadata">

**Author:** [@Kai](https://discourse.nodered.org/u/Kai)\
**Replies:** 2\
**Last updated:** [19 August 2022 10:10 UTC](https://discourse.nodered.org/t/ui-template-content-disappeared-on-send/66658 "2022-08-19T10:10:55Z")

</div>

Hi, hope someone can help My content disappeared after trigger the angular js send function :sweat: \[ { "id": "b17f4e2518ccb979", "type": "ui\_template", "z": "08f7a2f8d6e59272", "gr…

---

## [Flow's env variable not updated or lost](https://discourse.nodered.org/t/flows-env-variable-not-updated-or-lost/66641)

<div class="topic-metadata">

**Author:** [@Barbudor](https://discourse.nodered.org/u/Barbudor)\
**Replies:** 2\
**Last updated:** [19 August 2022 09:54 UTC](https://discourse.nodered.org/t/flows-env-variable-not-updated-or-lost/66641 "2022-08-19T09:54:01Z")

</div>

Hello, I store global parameters for my flow such as a user credential, API server URL, alarm destination emails... into flows' environment variables. I have standard subflows that are re-used in many flows that can get…

---

## [Syntax error in settings.js while using configuration from the official documentation](https://discourse.nodered.org/t/syntax-error-in-settings-js-while-using-configuration-from-the-official-documentation/66655)

<div class="topic-metadata">

**Author:** [@Marcom-UR](https://discourse.nodered.org/u/Marcom-UR)\
**Replies:** 2\
**Last updated:** [19 August 2022 09:37 UTC](https://discourse.nodered.org/t/syntax-error-in-settings-js-while-using-configuration-from-the-official-documentation/66655 "2022-08-19T09:37:27Z")

</div>

Hi, does somebody know what could be the reason for this problem? I have not seen anybody else encounter the same thing for testing im using this settings.js configuration: adminAuth: { type: "credentials", use…

---

## [Http request with dynamic credentials](https://discourse.nodered.org/t/http-request-with-dynamic-credentials/66644)

<div class="topic-metadata">

**Author:** [@plouc](https://discourse.nodered.org/u/plouc)\
**Replies:** 5\
**Last updated:** [19 August 2022 09:24 UTC](https://discourse.nodered.org/t/http-request-with-dynamic-credentials/66644 "2022-08-19T09:24:17Z")

</div>

Hello everyone! I'm building in node-red a central controller for various audio/video equipment. they have a web interface, so an easy way to control them is to use the node http-request. This works great, however som…

---

## [Sending data from dashboard template (for the closed topic from Vrrrum)](https://discourse.nodered.org/t/sending-data-from-dashboard-template-for-the-closed-topic-from-vrrrum/66656)

<div class="topic-metadata">

**Author:** [@paulalsmith1000](https://discourse.nodered.org/u/paulalsmith1000)\
**Replies:** 0\
**Last updated:** [19 August 2022 09:17 UTC](https://discourse.nodered.org/t/sending-data-from-dashboard-template-for-the-closed-topic-from-vrrrum/66656 "2022-08-19T09:17:19Z")

</div>

I know this has already been answered, but I found a solution from another post that seems very easy to understand. For beginners like myself (and perhaps Vrrrum) it might help you get started. I've just copied this di…

---

## [Create a formatted Excel Report with node red](https://discourse.nodered.org/t/create-a-formatted-excel-report-with-node-red/66646)

<div class="topic-metadata">

**Author:** [@Chorum](https://discourse.nodered.org/u/Chorum)\
**Replies:** 2\
**Last updated:** [19 August 2022 08:26 UTC](https://discourse.nodered.org/t/create-a-formatted-excel-report-with-node-red/66646 "2022-08-19T08:26:12Z")

</div>

Hello, I am reading Data from a Database and write it to a multisheet Excel file. The Name of the Node is excel-sheets. (Its downloadable on the Dashboard) I would like to know: it is possible to create a full formatte…

---

## [Pb layout dashboard](https://discourse.nodered.org/t/pb-layout-dashboard/66640)

<div class="topic-metadata">

**Author:** [@SARTH1](https://discourse.nodered.org/u/SARTH1)\
**Replies:** 0\
**Last updated:** [19 August 2022 06:45 UTC](https://discourse.nodered.org/t/pb-layout-dashboard/66640 "2022-08-19T06:45:47Z")

</div>

Bonjour Node-RED version: v2.2.2; Node.js version: v18.4.0 Dans mon application, pour chaque dashboard, en cliquant sur layout, j obtiens cette vue mais les objets ne sont pas sur la vue. Pourriez vous m'aider à retro…

---

## [Question(Advice wanted): External "display and control unit" with pi zero](https://discourse.nodered.org/t/question-advice-wanted-external-display-and-control-unit-with-pi-zero/66616)

<div class="topic-metadata">

**Author:** [@Aaroneisele55](https://discourse.nodered.org/u/Aaroneisele55)\
**Replies:** 4\
**Last updated:** [19 August 2022 04:57 UTC](https://discourse.nodered.org/t/question-advice-wanted-external-display-and-control-unit-with-pi-zero/66616 "2022-08-19T04:57:08Z")

</div>

Hello, I have: A Raspberry pi 4b with a keyboard, a camera and a unicorn hat connected An arduino Esplora that gives light sensor data to that pi via HC05 Bluetooth Serial and custom Program Now i wanted to have som…

---

## [Hue Dimmer stop sending informations](https://discourse.nodered.org/t/hue-dimmer-stop-sending-informations/66635)

<div class="topic-metadata">

**Author:** [@NH04121986](https://discourse.nodered.org/u/NH04121986)\
**Replies:** 0\
**Last updated:** [19 August 2022 04:18 UTC](https://discourse.nodered.org/t/hue-dimmer-stop-sending-informations/66635 "2022-08-19T04:18:05Z")

</div>

Hi guys. I have a SmartHome based on Apple HomeKit and started weeks ago to bring everything into Node-Red. So I‘m a newbie. Most of the thongs are running quite well, but I got problems with my Hue Dimmer V1. I did a …

---

## [Creating a Lookup Table with double digits](https://discourse.nodered.org/t/creating-a-lookup-table-with-double-digits/66623)

<div class="topic-metadata">

**Author:** [@Jaime\_G](https://discourse.nodered.org/u/Jaime_G)\
**Replies:** 5\
**Last updated:** [19 August 2022 00:04 UTC](https://discourse.nodered.org/t/creating-a-lookup-table-with-double-digits/66623 "2022-08-19T00:04:13Z")

</div>

Hi community! I've been using a look up function that I've created for some time now and it's been working well,,,, until today that I ran into a scenario that has double digits. When I inject the value 1 through 9 …

---

## [Connection to socket.io websocket for updates, how?](https://discourse.nodered.org/t/connection-to-socket-io-websocket-for-updates-how/15482)

<div class="topic-metadata">

**Author:** [@swiftnesses](https://discourse.nodered.org/u/swiftnesses)\
**Replies:** 14\
**Last updated:** [18 August 2022 23:09 UTC](https://discourse.nodered.org/t/connection-to-socket-io-websocket-for-updates-how/15482 "2022-08-18T23:09:59Z")

</div>

Good day, I'm looking for a way to connect to a simple socket.io websocket to receive real time events, an example can be found here: https://ws.moodo.co:9090 (view-source). How can I best achieve this in Node Red?

---

## [How to use msg.payload of a function into javascript?](https://discourse.nodered.org/t/how-to-use-msg-payload-of-a-function-into-javascript/66626)

<div class="topic-metadata">

**Author:** [@Macko](https://discourse.nodered.org/u/Macko)\
**Replies:** 5\
**Last updated:** [18 August 2022 22:55 UTC](https://discourse.nodered.org/t/how-to-use-msg-payload-of-a-function-into-javascript/66626 "2022-08-18T22:55:14Z")

</div>

I have a function that pulls information from a database, I've even saved it to a global variable. The problem is that I don't know how to use this value in javascript, I have tried with global.get() but the console giv…

---

## [OPC xml client ItemName/ItemPath](https://discourse.nodered.org/t/opc-xml-client-itemname-itempath/65707)

<div class="topic-metadata">

**Author:** [@Neligan](https://discourse.nodered.org/u/Neligan)\
**Replies:** 4\
**Last updated:** [18 August 2022 21:32 UTC](https://discourse.nodered.org/t/opc-xml-client-itemname-itempath/65707 "2022-08-18T21:32:27Z")

</div>

hi, i'm trying to use opcxml supflow (opcxml subflow (flow) - Node-RED) and have some problems to read the variables of a SIMOTION D445\_2 (Siemens). With an external Client there are no Problems to get the Values. But sp…

---

## [Read out the waste calendar](https://discourse.nodered.org/t/read-out-the-waste-calendar/66488)

<div class="topic-metadata">

**Author:** [@Wurmi](https://discourse.nodered.org/u/Wurmi)\
**Replies:** 31\
**Last updated:** [18 August 2022 18:53 UTC](https://discourse.nodered.org/t/read-out-the-waste-calendar/66488 "2022-08-18T18:53:07Z")

</div>

Hi guys, i have tried to read out this page per http request "Bad Schallerbach - GEM2GO WEB - Zentrum - Bürger\<br\>service - Abfall & Entsorgung - Abfalltermine" But the information about the schedule is not included i…

---

## [Node Red Dashboard side menu doesn't show](https://discourse.nodered.org/t/node-red-dashboard-side-menu-doesnt-show/66538)

<div class="topic-metadata">

**Author:** [@SandeepA](https://discourse.nodered.org/u/SandeepA)\
**Replies:** 5\
**Last updated:** [18 August 2022 18:52 UTC](https://discourse.nodered.org/t/node-red-dashboard-side-menu-doesnt-show/66538 "2022-08-18T18:52:04Z")

</div>

Hi , I have set up NR Dashboard on one of our environments. But for some reason i don't see the hamburger icon for side menu. Nor do i see the side menu which allows me to navigate between groups. I checked the forum…

---

## [I have to ping every 5 - 10 second a device to see if it is online or offline (i don't know the ip)](https://discourse.nodered.org/t/i-have-to-ping-every-5-10-second-a-device-to-see-if-it-is-online-or-offline-i-dont-know-the-ip/65878)

<div class="topic-metadata">

**Author:** [@Manupaolas](https://discourse.nodered.org/u/Manupaolas)\
**Replies:** 36\
**Last updated:** [18 August 2022 18:01 UTC](https://discourse.nodered.org/t/i-have-to-ping-every-5-10-second-a-device-to-see-if-it-is-online-or-offline-i-dont-know-the-ip/65878 "2022-08-18T18:01:41Z")

</div>

Ok, the title may be confusing or not, but i have my PC that currently is in an appartment connected to the internet with a mobile router, so the IP is always changing, i've tried several methods, that kinda worked but n…

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

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