# General **URL:** https://discourse.nodered.org/c/general/7.md?page=239 [Latest](https://discourse.nodered.org/latest.md) · [Categories](https://discourse.nodered.org/categories.md) · [Tags](https://discourse.nodered.org/tags.md) **Page:** 240 --- ## [Node-red-contrib-postgrestor-next](https://discourse.nodered.org/t/node-red-contrib-postgrestor-next/76032)
**Author:** [@Chrolloo123](https://discourse.nodered.org/u/Chrolloo123)\ **Replies:** 0\ **Last updated:** [3 March 2023 03:41 UTC](https://discourse.nodered.org/t/node-red-contrib-postgrestor-next/76032 "2023-03-03T03:41:02Z")
Everytime I tried to save my query to postgres I've got an error it says "error: invalid input syntax for type json" here's my flow: \[ { "id": "3095d062c0825ec3", "type": "mqtt in", "z": "14… --- ## [Cannot interact with any buttons on nodes (timestamps, debug nodes) Cannot see values and trigger times of nodes](https://discourse.nodered.org/t/cannot-interact-with-any-buttons-on-nodes-timestamps-debug-nodes-cannot-see-values-and-trigger-times-of-nodes/76021)
**Author:** [@xxgmxx](https://discourse.nodered.org/u/xxgmxx)\ **Replies:** 2\ **Last updated:** [2 March 2023 21:06 UTC](https://discourse.nodered.org/t/cannot-interact-with-any-buttons-on-nodes-timestamps-debug-nodes-cannot-see-values-and-trigger-times-of-nodes/76021 "2023-03-02T21:06:03Z")
Hey there, guys! Can anyone tell me why I cannot press the timestamp button in any of my flows? The debug button also doesn't work :confused: I have to keep reloading the page until it does. Homeassistant's companion app… --- ## [Decode "object: date:" in an mqtt frame](https://discourse.nodered.org/t/decode-object-date-in-an-mqtt-frame/76019)
**Author:** [@Ayno](https://discourse.nodered.org/u/Ayno)\ **Replies:** 0\ **Last updated:** [2 March 2023 19:13 UTC](https://discourse.nodered.org/t/decode-object-date-in-an-mqtt-frame/76019 "2023-03-02T19:13:01Z")
Hello, I have Lora devices and a LoraWan Gateway to transmit in MQTT the information of devices here is one of them : (the one of the Dragino LDS02) object applicationID: "3" applicationName: "Rak7268" devEUI: "a84041… --- ## [More jsonata array filtering](https://discourse.nodered.org/t/more-jsonata-array-filtering/75937)
**Author:** [@tobiasselin](https://discourse.nodered.org/u/tobiasselin)\ **Replies:** 20\ **Last updated:** [2 March 2023 18:14 UTC](https://discourse.nodered.org/t/more-jsonata-array-filtering/75937 "2023-03-02T18:14:50Z")
I want to filter arrays for some key value with jsonata, eg: ... \`exchange-document\`\[\`$\`.kind = "A2"\].\`bibliographic-data\`... but I am interested in more than one value so I have tried ... \`exchange-document\`\[\`$\`.kind… --- ## [Node RED w/ VPN](https://discourse.nodered.org/t/node-red-w-vpn/76007)
**Author:** [@MVArdent](https://discourse.nodered.org/u/MVArdent)\ **Replies:** 2\ **Last updated:** [2 March 2023 17:54 UTC](https://discourse.nodered.org/t/node-red-w-vpn/76007 "2023-03-02T17:54:24Z")
I have a question and please forgive me if it seems basic. I have a client about an hour away with a project we are doing. Its basically a packaging line with 8 station controlled with PLC's. There is a main hub which… --- ## [Tuya device integration without HA](https://discourse.nodered.org/t/tuya-device-integration-without-ha/76006)
**Author:** [@DeWoAlliSeged7](https://discourse.nodered.org/u/DeWoAlliSeged7)\ **Replies:** 1\ **Last updated:** [2 March 2023 17:37 UTC](https://discourse.nodered.org/t/tuya-device-integration-without-ha/76006 "2023-03-02T17:37:26Z")
Hello How do i change the status of a tuya device? I got the node-red-contrib-tuya-smart-device palet. I have the device connedted! I can debug device data (If i use the switch on my app i get the respons: ) But … --- ## [Use TTN payload as a GPS message in Telegram](https://discourse.nodered.org/t/use-ttn-payload-as-a-gps-message-in-telegram/76003)
**Author:** [@Prilex](https://discourse.nodered.org/u/Prilex)\ **Replies:** 6\ **Last updated:** [2 March 2023 17:10 UTC](https://discourse.nodered.org/t/use-ttn-payload-as-a-gps-message-in-telegram/76003 "2023-03-02T17:10:04Z")
Hi forum, I'm starting learning node-red for an Arduino project. I have an MQTT node that receives the TTN (The Things Network) data, another one that send messages to Telegram (using a bot) with the information of the … --- ## [Context file not written when using multiple localfilesystem entries](https://discourse.nodered.org/t/context-file-not-written-when-using-multiple-localfilesystem-entries/71617)
**Author:** [@interscope101](https://discourse.nodered.org/u/interscope101)\ **Replies:** 51\ **Last updated:** [2 March 2023 17:06 UTC](https://discourse.nodered.org/t/context-file-not-written-when-using-multiple-localfilesystem-entries/71617 "2023-03-02T17:06:26Z")
I need to have seperate localfilesystems. I tried this config based on a forum example, yet noticed that when something is saved in "file" it also automatically gets saved in "file2" and "file3". I understand that th… --- ## [Access to mqtt retained messages](https://discourse.nodered.org/t/access-to-mqtt-retained-messages/75914)
**Author:** [@ianh33](https://discourse.nodered.org/u/ianh33)\ **Replies:** 16\ **Last updated:** [2 March 2023 16:27 UTC](https://discourse.nodered.org/t/access-to-mqtt-retained-messages/75914 "2023-03-02T16:27:01Z")
I have a pi relay /sensor which successfully subscribes to an mqtt mosquitto broker. I have node red flows which publish 'retained' mqqt data (e.g. astropi/heater/set/ON) . 'Set' triggers a relay on the pi and reports … --- ## [Get data from multiple Excel files and add it to existing Excel file](https://discourse.nodered.org/t/get-data-from-multiple-excel-files-and-add-it-to-existing-excel-file/76002)
**Author:** [@Amor](https://discourse.nodered.org/u/Amor)\ **Replies:** 0\ **Last updated:** [2 March 2023 16:24 UTC](https://discourse.nodered.org/t/get-data-from-multiple-excel-files-and-add-it-to-existing-excel-file/76002 "2023-03-02T16:24:23Z")
Hi I'm new to node-red and I'm not sure if my problem can be solved. But I'll try anyway :slight\_smile: I have multiple Excel files running on my OneDrive that I'm sharing whit my coworkers. The files are identical and… --- ## [Node Red User Interface Page](https://discourse.nodered.org/t/node-red-user-interface-page/75987)
**Author:** [@Kimber](https://discourse.nodered.org/u/Kimber)\ **Replies:** 11\ **Last updated:** [2 March 2023 14:59 UTC](https://discourse.nodered.org/t/node-red-user-interface-page/75987 "2023-03-02T14:59:19Z")
Good Day all. Im looking for advice. I have been using a simple ThinkPad. I7 Core, 16GB of RAM. Running Windows 10 Enterprise. I have been building a Node Red Application that pulls data from many PLC processors. The … --- ## [My first time to use html parser](https://discourse.nodered.org/t/my-first-time-to-use-html-parser/75917)
**Author:** [@makerstorage](https://discourse.nodered.org/u/makerstorage)\ **Replies:** 2\ **Last updated:** [2 March 2023 13:32 UTC](https://discourse.nodered.org/t/my-first-time-to-use-html-parser/75917 "2023-03-02T13:32:49Z")
Hi, It is my first time to use html parser. I am trying to get: Binance Adds BNX, YFI & More Pairs on Cross Margin & Isolated Margin html part: \
Binance Adds BNX, YFI & … --- ## [Pythonshell shows error but the script is running in the ssh box](https://discourse.nodered.org/t/pythonshell-shows-error-but-the-script-is-running-in-the-ssh-box/75979)
**Author:** [@DeWoAlliSeged7](https://discourse.nodered.org/u/DeWoAlliSeged7)\ **Replies:** 2\ **Last updated:** [2 March 2023 10:18 UTC](https://discourse.nodered.org/t/pythonshell-shows-error-but-the-script-is-running-in-the-ssh-box/75979 "2023-03-02T10:18:27Z")
Hello I would like to run a python script with Node-RED. I added the pythonshell palett. I can run the script in the ssh box but if i start the script with the pythonshell i get the error: (It is two times the same… --- ## [Scaled value while reading Modbus](https://discourse.nodered.org/t/scaled-value-while-reading-modbus/75871)
**Author:** [@Manuel\_o](https://discourse.nodered.org/u/Manuel_o)\ **Replies:** 5\ **Last updated:** [2 March 2023 09:37 UTC](https://discourse.nodered.org/t/scaled-value-while-reading-modbus/75871 "2023-03-02T09:37:55Z")
Hey, I tried to find some answers here in the forum but without sucsess. I am reading a value from a dosingpump. I manage to get the raw (DEZ) value. For example as in the image below: 26032. But this value is somehow… --- ## [How to check duplicate value](https://discourse.nodered.org/t/how-to-check-duplicate-value/75977)
**Author:** [@komkitPP](https://discourse.nodered.org/u/komkitPP)\ **Replies:** 1\ **Last updated:** [2 March 2023 07:43 UTC](https://discourse.nodered.org/t/how-to-check-duplicate-value/75977 "2023-03-02T07:43:07Z")
Example : If the value is 6, not insert value 6 again. I use switch \> \*\* \*\*\> How to check\*\* \*\*\> --- ## [Node-Red to Posgresql](https://discourse.nodered.org/t/node-red-to-posgresql/75934)
**Author:** [@Chrolloo123](https://discourse.nodered.org/u/Chrolloo123)\ **Replies:** 2\ **Last updated:** [2 March 2023 04:21 UTC](https://discourse.nodered.org/t/node-red-to-posgresql/75934 "2023-03-02T04:21:36Z")
I have tried many postgres node but I can't find any node that's working. I have a flow example here: \[ { "id": "23fe0d38e71e8b24", "type": "postgrestor", "z": "ee21e3b499ee5ae7", "n… --- ## [Format moment.js output](https://discourse.nodered.org/t/format-moment-js-output/75972)
**Author:** [@richiep](https://discourse.nodered.org/u/richiep)\ **Replies:** 2\ **Last updated:** [2 March 2023 01:02 UTC](https://discourse.nodered.org/t/format-moment-js-output/75972 "2023-03-02T01:02:20Z")
Hey All, I'm working with moment.js to write a time stamp to a txt file. I have it working but the output looks like this. 56o563nt().for56pmt('March 1, 2023 6:56 PM'); I want it to format like this March 1, 2023 … --- ## [Why is the flow file in AppData\\Roaming\\SPB\_Data on my Windows PC?](https://discourse.nodered.org/t/why-is-the-flow-file-in-appdata-roaming-spb-data-on-my-windows-pc/17825)
**Author:** [@PaulM](https://discourse.nodered.org/u/PaulM)\ **Replies:** 7\ **Last updated:** [1 March 2023 21:40 UTC](https://discourse.nodered.org/t/why-is-the-flow-file-in-appdata-roaming-spb-data-on-my-windows-pc/17825 "2023-03-01T21:40:04Z")
I found that the ".node-red" folder on one of my Windows PC is in: "C:\\Users\\xxxx\\AppData\\Roaming\\SPB\_Data" instead of the normal "C:\\Users\\xxxx". I don't understand why this has happened. Can I change this location to… --- ## [Executar serviço através de linhas de comando function](https://discourse.nodered.org/t/executar-servico-atraves-de-linhas-de-comando-function/73124)
**Author:** [@EduardoRCB](https://discourse.nodered.org/u/EduardoRCB)\ **Replies:** 6\ **Last updated:** [1 March 2023 20:28 UTC](https://discourse.nodered.org/t/executar-servico-atraves-de-linhas-de-comando-function/73124 "2023-03-01T20:28:55Z")
Boa tarde ! Alguém saberia como executar um serviço através de linhas de comando dentro de um nó function? Encontrei o códigoe exemplo abaixo, mas não funciona: --- ## [Websocket link to get GPS coordinates](https://discourse.nodered.org/t/websocket-link-to-get-gps-coordinates/75963)
**Author:** [@tnesheim](https://discourse.nodered.org/u/tnesheim)\ **Replies:** 0\ **Last updated:** [1 March 2023 19:13 UTC](https://discourse.nodered.org/t/websocket-link-to-get-gps-coordinates/75963 "2023-03-01T19:13:59Z")
Hi I have this "URL": wss://gps-websocket.blackvuecloud.com/?token=(a very long string of charaters) which will get me some GPS locations. I see in the Chrome-inspect that the GET method is used, but at the same time … --- ## [NR with Buster vs Bullseye?](https://discourse.nodered.org/t/nr-with-buster-vs-bullseye/75843)
**Author:** [@gNeandr](https://discourse.nodered.org/u/gNeandr)\ **Replies:** 11\ **Last updated:** [1 March 2023 12:29 UTC](https://discourse.nodered.org/t/nr-with-buster-vs-bullseye/75843 "2023-03-01T12:29:29Z")
Wonder why Node-red only runs up to Raspian 11 (Buster), and why the official version 12 (Bullseye) is not (or not yet) supported. Basically no problem, thought with Bullseye later updates would be avoided. --- ## [Node red contrib-alexa-remote2](https://discourse.nodered.org/t/node-red-contrib-alexa-remote2/75930)
**Author:** [@Giacomo23](https://discourse.nodered.org/u/Giacomo23)\ **Replies:** 18\ **Last updated:** [1 March 2023 16:24 UTC](https://discourse.nodered.org/t/node-red-contrib-alexa-remote2/75930 "2023-03-01T16:24:51Z")
Hi everyone, I'm using the contrib-alexa-remote2 on device activity node. I logged in to the relevant page during the deployment phase and saved the cookies in my PI the only thing is that when I try to call an echo dev… --- ## [Handling message objects full of objects](https://discourse.nodered.org/t/handling-message-objects-full-of-objects/75941)
**Author:** [@steven\_191](https://discourse.nodered.org/u/steven_191)\ **Replies:** 2\ **Last updated:** [1 March 2023 15:04 UTC](https://discourse.nodered.org/t/handling-message-objects-full-of-objects/75941 "2023-03-01T15:04:49Z")
Due to my lack of javascript skill, im struggling with a bit of code. I thought there was a node that could take a message and separate the content into individual objects that could be then sent out one after the other. … --- ## [Graph Generate + PDF & MAIL](https://discourse.nodered.org/t/graph-generate-pdf-mail/75739)
**Author:** [@ankit.prasad](https://discourse.nodered.org/u/ankit.prasad)\ **Replies:** 5\ **Last updated:** [1 March 2023 14:33 UTC](https://discourse.nodered.org/t/graph-generate-pdf-mail/75739 "2023-03-01T14:33:53Z")
How to generate Graph from Influxdb . Use node-red and filter data based on API (unique ID) and generate PDF and automate it During the Specified time -Shoot Email to user. --- ## [Flexdash edit mode disappeared](https://discourse.nodered.org/t/flexdash-edit-mode-disappeared/75924)
**Author:** [@cscheidl](https://discourse.nodered.org/u/cscheidl)\ **Replies:** 3\ **Last updated:** [1 March 2023 14:15 UTC](https://discourse.nodered.org/t/flexdash-edit-mode-disappeared/75924 "2023-03-01T14:15:02Z")
Good day to all... I'm trying to use flexdash and node-red to develop a user interface to watch and control a lot of customer sensors/actors. The flows got quite complicated now... After some time, I noticed, that the … --- ## [Node-Red to PostgreSQL](https://discourse.nodered.org/t/node-red-to-postgresql/75926)
**Author:** [@Chrolloo123](https://discourse.nodered.org/u/Chrolloo123)\ **Replies:** 7\ **Last updated:** [1 March 2023 11:45 UTC](https://discourse.nodered.org/t/node-red-to-postgresql/75926 "2023-03-01T11:45:28Z")
I just recently used Node-red. I created a function that can save to local postgres using node-red-contrib-postgres-multi package I have a data from my mqtt client: msg.topic = 'data' msg.payload = \[ … --- ## [Net Atmo login - how to connect?](https://discourse.nodered.org/t/net-atmo-login-how-to-connect/75756)
**Author:** [@juntiedt](https://discourse.nodered.org/u/juntiedt)\ **Replies:** 14\ **Last updated:** [1 March 2023 13:42 UTC](https://discourse.nodered.org/t/net-atmo-login-how-to-connect/75756 "2023-03-01T13:42:12Z")
Since a few years I am using node-red-contrib-netatmo-dashboard. Today I updated the node and found out, that the login does not work anymore. It seems that Net Atmo has changed the Authentification process. With my C… --- ## [Value out of range](https://discourse.nodered.org/t/value-out-of-range/75876)
**Author:** [@gopinath.m](https://discourse.nodered.org/u/gopinath.m)\ **Replies:** 1\ **Last updated:** [1 March 2023 12:30 UTC](https://discourse.nodered.org/t/value-out-of-range/75876 "2023-03-01T12:30:31Z")
Hi I am receiving some messages from azure cloud and converting them into JSON Object .but sometimes i am getting below error,can anyone guide me how to solve this issue. \[error\] RangeError: The value of "value" is out … --- ## [MIN/MAX from mqtt](https://discourse.nodered.org/t/min-max-from-mqtt/75832)
**Author:** [@mra2ko](https://discourse.nodered.org/u/mra2ko)\ **Replies:** 12\ **Last updated:** [1 March 2023 10:50 UTC](https://discourse.nodered.org/t/min-max-from-mqtt/75832 "2023-03-01T10:50:08Z")
Hi, we have some sensors, whitch send data to mqtt. So and we like show min/max value after last 24h in LCD. Import from MQTT - make min and max values in last 24h and back send separately (2 values min and max) sent bac… --- ## [Do Node-red MQTT nodes and CLI mosquitto\_pub interfere with each other?](https://discourse.nodered.org/t/do-node-red-mqtt-nodes-and-cli-mosquitto-pub-interfere-with-each-other/75837)
**Author:** [@jbudd](https://discourse.nodered.org/u/jbudd)\ **Replies:** 5\ **Last updated:** [1 March 2023 09:20 UTC](https://discourse.nodered.org/t/do-node-red-mqtt-nodes-and-cli-mosquitto-pub-interfere-with-each-other/75837 "2023-03-01T09:20:36Z")
I'm using Node-red MQTT nodes on two Raspberry Pies as well as publishing at intervals with mosquitto\_pub in a shell script. I keep seeing status Disconnected in Node-red and I suspect that when the command line connect… [Previous page](https://discourse.nodered.org/c/general/7.md?page=238) [Next page](https://discourse.nodered.org/c/general/7.md?page=240)