# Latest **URL:** https://discourse.nodered.org/latest.md?page=610 [Latest](https://discourse.nodered.org/latest.md) · [Categories](https://discourse.nodered.org/categories.md) · [Tags](https://discourse.nodered.org/tags.md) **Page:** 611 --- ## [Pass topic to JSON data](https://discourse.nodered.org/t/pass-topic-to-json-data/59683)
**Author:** [@CAL37](https://discourse.nodered.org/u/CAL37)\ **Replies:** 2\ **Last updated:** [11 March 2022 13:30 UTC](https://discourse.nodered.org/t/pass-topic-to-json-data/59683 "2022-03-11T13:30:35Z")
I created this flow so I could turn on the TV/change source between Hulu and Netflix using Alexa. I have the topic defined in the Alexa nodes and I can see the topic is being passed all the way to the call service node, … --- ## [Load a mustache template from file with read node and then inject data in it by a function node](https://discourse.nodered.org/t/load-a-mustache-template-from-file-with-read-node-and-then-inject-data-in-it-by-a-function-node/59702)
**Author:** [@oliver](https://discourse.nodered.org/u/oliver)\ **Replies:** 10\ **Last updated:** [11 March 2022 13:07 UTC](https://discourse.nodered.org/t/load-a-mustache-template-from-file-with-read-node-and-then-inject-data-in-it-by-a-function-node/59702 "2022-03-11T13:07:57Z")
Hi, is it possible to load a mustache template from file with a read node and then inject data in it by a function node? Thanks in advance! --- ## [Is there an HTTP API where I can ask for Pings for Integration Tests?](https://discourse.nodered.org/t/is-there-an-http-api-where-i-can-ask-for-pings-for-integration-tests/59707)
**Author:** [@Shan](https://discourse.nodered.org/u/Shan)\ **Replies:** 1\ **Last updated:** [11 March 2022 12:44 UTC](https://discourse.nodered.org/t/is-there-an-http-api-where-i-can-ask-for-pings-for-integration-tests/59707 "2022-03-11T12:44:46Z")
Is there an HTTP GET API within the node-red API reference which I could use for some integrations tests just to know if node-red is up and running for example via a docker-compose stack or a standalone instance on a ma… --- ## [Mqtt message to python script into db database](https://discourse.nodered.org/t/mqtt-message-to-python-script-into-db-database/59694)
**Author:** [@sayod](https://discourse.nodered.org/u/sayod)\ **Replies:** 11\ **Last updated:** [11 March 2022 11:54 UTC](https://discourse.nodered.org/t/mqtt-message-to-python-script-into-db-database/59694 "2022-03-11T11:54:53Z")
i want a mqtt message to upload into a database without manually typing, python main.py in the Terminal. This is the python code i use: Save MQTT Data to SQLite Database using Python | Lindevs --- ## [Ui-template: sending msg through a function](https://discourse.nodered.org/t/ui-template-sending-msg-through-a-function/59686)
**Author:** [@regissg](https://discourse.nodered.org/u/regissg)\ **Replies:** 5\ **Last updated:** [11 March 2022 11:20 UTC](https://discourse.nodered.org/t/ui-template-sending-msg-through-a-function/59686 "2022-03-11T11:20:58Z")
I have tried all day to send a message through a function within the ui-template. Here is a very basic example (one of many tries) inspired from the ui-template help and few other but to be frank I am not familiar with … --- ## [What spec server would i need for my business](https://discourse.nodered.org/t/what-spec-server-would-i-need-for-my-business/59678)
**Author:** [@dezire](https://discourse.nodered.org/u/dezire)\ **Replies:** 4\ **Last updated:** [11 March 2022 10:27 UTC](https://discourse.nodered.org/t/what-spec-server-would-i-need-for-my-business/59678 "2022-03-11T10:27:59Z")
I am planning to use node red docker container for production. What spec server should i expect to run 100 node red container? --- ## [Creating bar chart from a csv file shows nothing :(](https://discourse.nodered.org/t/creating-bar-chart-from-a-csv-file-shows-nothing/59608)
**Author:** [@Gitsaibot](https://discourse.nodered.org/u/Gitsaibot)\ **Replies:** 5\ **Last updated:** [10 March 2022 21:18 UTC](https://discourse.nodered.org/t/creating-bar-chart-from-a-csv-file-shows-nothing/59608 "2022-03-10T21:18:45Z")
Hello, I would like to display a value as a bar in a bar chart every 15 minutes. The period is 24 hours. Like this: Here is my flow and the debug output from "msg.generate" The data looks okay to me. What is sti… --- ## [Twitter alternative](https://discourse.nodered.org/t/twitter-alternative/59652)
**Author:** [@ilse.markert](https://discourse.nodered.org/u/ilse.markert)\ **Replies:** 4\ **Last updated:** [11 March 2022 08:55 UTC](https://discourse.nodered.org/t/twitter-alternative/59652 "2022-03-11T08:55:08Z")
Hello, I'm looking for some ideas. I'm using node red in a greenhouse setting. Yesterday I integrated a webcam and I thought it would be cool to publish a feed on twitter for it. I wanted to use it to check up on my da… --- ## [Possibility to delete the collected values in a fully configurable charts in a dashboard template node](https://discourse.nodered.org/t/possibility-to-delete-the-collected-values-in-a-fully-configurable-charts-in-a-dashboard-template-node/59666)
**Author:** [@Jackcat](https://discourse.nodered.org/u/Jackcat)\ **Replies:** 4\ **Last updated:** [11 March 2022 08:51 UTC](https://discourse.nodered.org/t/possibility-to-delete-the-collected-values-in-a-fully-configurable-charts-in-a-dashboard-template-node/59666 "2022-03-11T08:51:33Z")
Hello Node-Red Community, I have a problem that I have been struggling with for a few days now and would like your advice. I wanted to create a chart with X and Y axis labels in the dashboard. After ruling out the poss… --- ## [Charts in node-red with data from mysql database](https://discourse.nodered.org/t/charts-in-node-red-with-data-from-mysql-database/27539)
**Author:** [@node96](https://discourse.nodered.org/u/node96)\ **Replies:** 19\ **Last updated:** [11 March 2022 05:15 UTC](https://discourse.nodered.org/t/charts-in-node-red-with-data-from-mysql-database/27539 "2022-03-11T05:15:21Z")
hello, I am trying to build a chart with some data from mysql database. I have a query to the database and it returns a object with temperatures that I want to send to a chart and make a line chart. So that I can see t… --- ## [Extract a variable at a specific time and feed into function](https://discourse.nodered.org/t/extract-a-variable-at-a-specific-time-and-feed-into-function/59687)
**Author:** [@rocketsausages](https://discourse.nodered.org/u/rocketsausages)\ **Replies:** 1\ **Last updated:** [11 March 2022 00:22 UTC](https://discourse.nodered.org/t/extract-a-variable-at-a-specific-time-and-feed-into-function/59687 "2022-03-11T00:22:36Z")
I have a variable which changes throughout the day, I want to take that variable at a specific time and feed it into another function. for example at midnight my variable is 60, so I want to take "60" and feed that into… --- ## [Subflows and \`import\`... not always working the same](https://discourse.nodered.org/t/subflows-and-import-not-always-working-the-same/59684)
**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\ **Replies:** 2\ **Last updated:** [10 March 2022 23:51 UTC](https://discourse.nodered.org/t/subflows-and-import-not-always-working-the-same/59684 "2022-03-10T23:51:18Z")
I have (I know it is not a good idea, but this is the situation as it presents itself to me just now) a few different versions of a subflow I wrote on different machines. I export what I think is the latest and import o… --- ## [The colour in/on this isn't changing. (CSS)](https://discourse.nodered.org/t/the-colour-in-on-this-isnt-changing-css/59639)
**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\ **Replies:** 27\ **Last updated:** [10 March 2022 22:29 UTC](https://discourse.nodered.org/t/the-colour-in-on-this-isnt-changing-css/59639 "2022-03-10T22:29:45Z")
Sorry folks, I was given this a long time ago to address a question I had and now I am trying to apply it, it isn't working. Not blaming the person who gave it to me. It is probably something on my machine. (But befo… --- ## [VueJS / UIBuilder - v-for ranged values not being passed to Node-Red](https://discourse.nodered.org/t/vuejs-uibuilder-v-for-ranged-values-not-being-passed-to-node-red/59662)
**Author:** [@Dustin](https://discourse.nodered.org/u/Dustin)\ **Replies:** 3\ **Last updated:** [10 March 2022 20:06 UTC](https://discourse.nodered.org/t/vuejs-uibuilder-v-for-ranged-values-not-being-passed-to-node-red/59662 "2022-03-10T20:06:46Z")
I am messing around with UIBuilder and decided to try to learn VueJS. My coding skills in Javascript/html/css are basic, at best. I think my issue is more VueJS than NodeRed, but not 100% sure. I started this project bu… --- ## [There experiment is this article so i need the code of it](https://discourse.nodered.org/t/there-experiment-is-this-article-so-i-need-the-code-of-it/59675)
**Author:** [@fathi](https://discourse.nodered.org/u/fathi)\ **Replies:** 6\ **Last updated:** [10 March 2022 19:48 UTC](https://discourse.nodered.org/t/there-experiment-is-this-article-so-i-need-the-code-of-it/59675 "2022-03-10T19:48:42Z")
Low-Cost Precision Monitoring System of Machine Tools for SMEs Author : kanglin Xing --- ## [I have a XML file that I needed to read it on real time by using NOD RED](https://discourse.nodered.org/t/i-have-a-xml-file-that-i-needed-to-read-it-on-real-time-by-using-nod-red/59674)
**Author:** [@fathi](https://discourse.nodered.org/u/fathi)\ **Replies:** 7\ **Last updated:** [10 March 2022 19:44 UTC](https://discourse.nodered.org/t/i-have-a-xml-file-that-i-needed-to-read-it-on-real-time-by-using-nod-red/59674 "2022-03-10T19:44:15Z")
I am stuck on how to read a XML file on real time using NODE RED I will attach the XML file if its needed --- ## [Show html msg.payload on dashboard with template.node](https://discourse.nodered.org/t/show-html-msg-payload-on-dashboard-with-template-node/59650)
**Author:** [@Hoeby](https://discourse.nodered.org/u/Hoeby)\ **Replies:** 3\ **Last updated:** [10 March 2022 18:23 UTC](https://discourse.nodered.org/t/show-html-msg-payload-on-dashboard-with-template-node/59650 "2022-03-10T18:23:43Z")
I am trying to post a HTML code as msg.payload on a dashboard with a template.node But the template.node doesn't post it as HTML text, but as plain text. msg.payload looks like: \07-03-2022 R1 Beta:\\ Check v… --- ## [HELP! Bootlooped my RPi with NR flow](https://discourse.nodered.org/t/help-bootlooped-my-rpi-with-nr-flow/59670)
**Author:** [@daxliniere](https://discourse.nodered.org/u/daxliniere)\ **Replies:** 3\ **Last updated:** [10 March 2022 18:15 UTC](https://discourse.nodered.org/t/help-bootlooped-my-rpi-with-nr-flow/59670 "2022-03-10T18:15:55Z")
Hey gang, I was testing out a flow which would automatically reboot my RPi whenever the RAM usage was \>75% and somehow I've got it stuck in a bootloop. Can anyone suggest a way to get out of this, please? I used an ex… --- ## [Converting String to Ascii for DataLogic Scanner](https://discourse.nodered.org/t/converting-string-to-ascii-for-datalogic-scanner/59599)
**Author:** [@jts450](https://discourse.nodered.org/u/jts450)\ **Replies:** 17\ **Last updated:** [10 March 2022 16:33 UTC](https://discourse.nodered.org/t/converting-string-to-ascii-for-datalogic-scanner/59599 "2022-03-10T16:33:57Z")
I have a DataLogix Scanner and I am using TCP/IP node to read barcode data from the scanner and trigger the scanner at IP and Port 51240. This is working fine but according to the manufacture you use port 1023 for changi… --- ## [Ui-button CSS field not working](https://discourse.nodered.org/t/ui-button-css-field-not-working/59610)
**Author:** [@regissg](https://discourse.nodered.org/u/regissg)\ **Replies:** 6\ **Last updated:** [10 March 2022 15:26 UTC](https://discourse.nodered.org/t/ui-button-css-field-not-working/59610 "2022-03-10T15:26:14Z")
By default ui-button uppercase the label. I have tried to use the CSS field and a very basic ui-template (see below) to have it "capitalized" instead but it does not seem to work. Am I doing something wrong or is that a… --- ## [Uibuilder with PostgreSQL connection](https://discourse.nodered.org/t/uibuilder-with-postgresql-connection/59644)
**Author:** [@endkinghenry](https://discourse.nodered.org/u/endkinghenry)\ **Replies:** 2\ **Last updated:** [10 March 2022 15:01 UTC](https://discourse.nodered.org/t/uibuilder-with-postgresql-connection/59644 "2022-03-10T15:01:47Z")
Dear sir, madam, Is there a way to connect the uibuilder with the PostgreSQL database to call/ gather data, something similar to the code below here, without using the local flow connection (connecting the lines togethe… --- ## [Gstreamer stream capture](https://discourse.nodered.org/t/gstreamer-stream-capture/59617)
**Author:** [@jmorris644](https://discourse.nodered.org/u/jmorris644)\ **Replies:** 3\ **Last updated:** [10 March 2022 14:12 UTC](https://discourse.nodered.org/t/gstreamer-stream-capture/59617 "2022-03-10T14:12:59Z")
I am running node-red on a Jetson Nano. I am using gstreamer to grab video from a USB connected camera. (I need to use Gstreamer and not ffmpeg because I am splitting the video source into two pipes and the other program… --- ## [Template query …](https://discourse.nodered.org/t/template-query/59651)
**Author:** [@Alpal](https://discourse.nodered.org/u/Alpal)\ **Replies:** 6\ **Last updated:** [10 March 2022 11:58 UTC](https://discourse.nodered.org/t/template-query/59651 "2022-03-10T11:58:22Z")
Newbie here. Hi! I use these templates to display camera images off the internet as shown (proprietary info redacted). I’m curious as to when the data is transferred. Is it only when I look at the images on the dashboard… --- ## [Part 2: Parent context variable accessed in subflow’s first function node yields undefined?](https://discourse.nodered.org/t/part-2-parent-context-variable-accessed-in-subflow-s-first-function-node-yields-undefined/59362)
**Author:** [@r0ller](https://discourse.nodered.org/u/r0ller)\ **Replies:** 1\ **Last updated:** [10 March 2022 11:13 UTC](https://discourse.nodered.org/t/part-2-parent-context-variable-accessed-in-subflow-s-first-function-node-yields-undefined/59362 "2022-03-10T11:13:04Z")
The existing thread with the same topic got closed automatically so continuing it here... Managed to make a minimal flow which can reproduce the issue on 2.2.2 and made a video of it. However, it still cannot be reprodu… --- ## [Issues in persisting messages in MQTT Broker using NodeRed MQTT Nodes](https://discourse.nodered.org/t/issues-in-persisting-messages-in-mqtt-broker-using-nodered-mqtt-nodes/4666)
**Author:** [@suryas](https://discourse.nodered.org/u/suryas)\ **Replies:** 25\ **Last updated:** [10 March 2022 10:37 UTC](https://discourse.nodered.org/t/issues-in-persisting-messages-in-mqtt-broker-using-nodered-mqtt-nodes/4666 "2022-03-10T10:37:12Z")
Hi I have an use case which requires persisting the MQTT messages in Broker whenever a subscriber goes offline. When the subscriber reconnects all the messages published when it was offline should be delivered. To achi… --- ## [MQTT data persistence not possible due to automatic unsubscribe before disconnect](https://discourse.nodered.org/t/mqtt-data-persistence-not-possible-due-to-automatic-unsubscribe-before-disconnect/56865)
**Author:** [@Keylies](https://discourse.nodered.org/u/Keylies)\ **Replies:** 8\ **Last updated:** [10 March 2022 10:34 UTC](https://discourse.nodered.org/t/mqtt-data-persistence-not-possible-due-to-automatic-unsubscribe-before-disconnect/56865 "2022-03-10T10:34:21Z")
Hello everyone, I have trouble testing the persistence of MQTT messages with Node-RED. I have a Node-RED 2.1.6 server, in which a "mqtt in" node subscribes to a topic. I would like that if my Node-RED server goes down… --- ## [Watson IoT Platform to Node Red local](https://discourse.nodered.org/t/watson-iot-platform-to-node-red-local/59634)
**Author:** [@PanK](https://discourse.nodered.org/u/PanK)\ **Replies:** 0\ **Last updated:** [10 March 2022 06:05 UTC](https://discourse.nodered.org/t/watson-iot-platform-to-node-red-local/59634 "2022-03-10T06:05:54Z")
0 I am trying to receive event data publish to WIoTP using node-red on a local server. I try both IBM IoT in node and the mqtt in node but either work. My configuration using IoT in node is Authentication as "API Key".… --- ## [Help| how to split string from mqtt](https://discourse.nodered.org/t/help-how-to-split-string-from-mqtt/48931)
**Author:** [@puteramelaka](https://discourse.nodered.org/u/puteramelaka)\ **Replies:** 40\ **Last updated:** [10 March 2022 06:03 UTC](https://discourse.nodered.org/t/help-how-to-split-string-from-mqtt/48931 "2022-03-10T06:03:10Z")
i have send reading of accelerometer from MQTT to node-red in three axis (x -axis,y-axis and z-axis). however the message recieved is in the form of string. i have been watching youtube and reading google etc.i found th… --- ## [How to change the text input line color with CSS](https://discourse.nodered.org/t/how-to-change-the-text-input-line-color-with-css/59629)
**Author:** [@WeeSeong](https://discourse.nodered.org/u/WeeSeong)\ **Replies:** 1\ **Last updated:** [10 March 2022 05:05 UTC](https://discourse.nodered.org/t/how-to-change-the-text-input-line-color-with-css/59629 "2022-03-10T05:05:06Z")
Hi, sorry to post again, I'm trying to change the text input line color to match the background but can't seem to find a way to do so. I've been testing around with these css styles but can't seem to work but the line… --- ## [Cannot GET error handler - Controling HTTP\_status\_codes](https://discourse.nodered.org/t/cannot-get-error-handler-controling-http-status-codes/59627)
**Author:** [@meeki007](https://discourse.nodered.org/u/meeki007)\ **Replies:** 0\ **Last updated:** [10 March 2022 03:30 UTC](https://discourse.nodered.org/t/cannot-get-error-handler-controling-http-status-codes/59627 "2022-03-10T03:30:16Z")
This is in response to closed thread: I just had to deal with this issue and found nginx was a great solution. Solution: proxy\_intercept\_errors on; http://nginx.org/en/docs/http/ngx\_http\_proxy\_module.html#proxy\_inte… [Previous page](https://discourse.nodered.org/latest.md?page=609) [Next page](https://discourse.nodered.org/latest.md?page=611)