# Latest

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

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

**Page:** 996

---

## [How can I read the last 5 records from a file?](https://discourse.nodered.org/t/how-can-i-read-the-last-5-records-from-a-file/33112)

<div class="topic-metadata">

**Author:** [@manjha](https://discourse.nodered.org/u/manjha)\
**Replies:** 4\
**Last updated:** [21 September 2020 21:22 UTC](https://discourse.nodered.org/t/how-can-i-read-the-last-5-records-from-a-file/33112 "2020-09-21T21:22:14Z")

</div>

I have a flow that reads a txt file. Output is a complete list of records, which I would like to parse. I tried several of the available parsers, the csv parser works, but returns each record as a separate output. Is t…

---

## [Import of multiple flows, causes MQTT to oscillate between connected and disconnected state](https://discourse.nodered.org/t/import-of-multiple-flows-causes-mqtt-to-oscillate-between-connected-and-disconnected-state/33130)

<div class="topic-metadata">

**Author:** [@freds](https://discourse.nodered.org/u/freds)\
**Replies:** 6\
**Last updated:** [21 September 2020 20:47 UTC](https://discourse.nodered.org/t/import-of-multiple-flows-causes-mqtt-to-oscillate-between-connected-and-disconnected-state/33130 "2020-09-21T20:47:49Z")

</div>

I was developing a solution with multiple flows (eleven) on a Raspberry Pi 4 and reached a point with the visual editor was going out to lunch for extended periods of time. So I restarted node red in safe mode and export…

---

## [Multiple outputs](https://discourse.nodered.org/t/multiple-outputs/33153)

<div class="topic-metadata">

**Author:** [@bmoel](https://discourse.nodered.org/u/bmoel)\
**Replies:** 4\
**Last updated:** [21 September 2020 20:33 UTC](https://discourse.nodered.org/t/multiple-outputs/33153 "2020-09-21T20:33:07Z")

</div>

I'm trying to get the ModBus flexwriter to work, but I am getting unreliable results using multiple function nodes as input the Flexwriter node. Seems I cant trust in which order the different node sends to the flexwrite…

---

## [Node-red V1.1.3 Windows10](https://discourse.nodered.org/t/node-red-v1-1-3-windows10/33151)

<div class="topic-metadata">

**Author:** [@ShanmugaCA](https://discourse.nodered.org/u/ShanmugaCA)\
**Replies:** 1\
**Last updated:** [21 September 2020 20:13 UTC](https://discourse.nodered.org/t/node-red-v1-1-3-windows10/33151 "2020-09-21T20:13:38Z")

</div>

Hello! Have installed the node-red-contrib-firebase and the node-red version 1.1.3 exits automatically. I tried the safe mode node-red --safe and that too exists, and no errors displayed. Any help? thanks much best …

---

## [Well, that odd npm issue is back!](https://discourse.nodered.org/t/well-that-odd-npm-issue-is-back/30569)

<div class="topic-metadata">

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\
**Replies:** 23\
**Last updated:** [21 September 2020 20:06 UTC](https://discourse.nodered.org/t/well-that-odd-npm-issue-is-back/30569 "2020-09-21T20:06:33Z")

</div>

Well, that odd npm issue is back! I just tried to mass load modules via the npm cli via the script I wrote, that has been working fine for a while, until that it. On a refresh NR install, after removing NR, node.js, an…

---

## [NR Grafana API keys](https://discourse.nodered.org/t/nr-grafana-api-keys/33045)

<div class="topic-metadata">

**Author:** [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Replies:** 7\
**Last updated:** [21 September 2020 18:00 UTC](https://discourse.nodered.org/t/nr-grafana-api-keys/33045 "2020-09-21T18:00:07Z")

</div>

Hi. I Was wondering can we use Grafana API keys, to secure the InfluxDB using NR? Is it possible to do something like this, but with NR?

---

## [Change Time Format string value](https://discourse.nodered.org/t/change-time-format-string-value/33146)

<div class="topic-metadata">

**Author:** [@Ward](https://discourse.nodered.org/u/Ward)\
**Replies:** 10\
**Last updated:** [21 September 2020 17:05 UTC](https://discourse.nodered.org/t/change-time-format-string-value/33146 "2020-09-21T17:05:38Z")

</div>

Hi, Little background. I wrote a flow where i store all the alarms in a csv file. And every time the csv file is updated i read the new alarms and write only those to InfluxDB. Everything works except, i want to use the…

---

## [How to refresh my sqlite 3 database through node red](https://discourse.nodered.org/t/how-to-refresh-my-sqlite-3-database-through-node-red/33133)

<div class="topic-metadata">

**Author:** [@shipra](https://discourse.nodered.org/u/shipra)\
**Replies:** 40\
**Last updated:** [21 September 2020 14:51 UTC](https://discourse.nodered.org/t/how-to-refresh-my-sqlite-3-database-through-node-red/33133 "2020-09-21T14:51:49Z")

</div>

Sir, I am doing a code in which user choice I am taking ,So if user wants to refresh it Database just by entering any input that input I am taking on MQTT pub node and then that pub node should trigger my Refresh Functio…

---

## [Catch errors during flow deployment](https://discourse.nodered.org/t/catch-errors-during-flow-deployment/33096)

<div class="topic-metadata">

**Author:** [@jens\_rossbach](https://discourse.nodered.org/u/jens_rossbach)\
**Replies:** 8\
**Last updated:** [21 September 2020 14:48 UTC](https://discourse.nodered.org/t/catch-errors-during-flow-deployment/33096 "2020-09-21T14:48:37Z")

</div>

Hello, I'm currently writing a node that has to emit an error under certain circumstances (not as part of handling an input message). For this I'm using the node.error() function passing in an error message and as secon…

---

## [Converting SQLite Query to a CSV File](https://discourse.nodered.org/t/converting-sqlite-query-to-a-csv-file/1937)

<div class="topic-metadata">

**Author:** [@zacharyalan09](https://discourse.nodered.org/u/zacharyalan09)\
**Replies:** 7\
**Last updated:** [21 September 2020 14:13 UTC](https://discourse.nodered.org/t/converting-sqlite-query-to-a-csv-file/1937 "2020-09-21T14:13:45Z")

</div>

Hello! Quick question, I'm hoping you folks can help me out with. I've created an SQLite database to store time-based data about my system and want to create and export a .csv file of specific queries on demand. So far…

---

## [Use FFmpeg to convert RSTP stream to MP4](https://discourse.nodered.org/t/use-ffmpeg-to-convert-rstp-stream-to-mp4/32883)

<div class="topic-metadata">

**Author:** [@nygma2004](https://discourse.nodered.org/u/nygma2004)\
**Replies:** 45\
**Last updated:** [21 September 2020 11:54 UTC](https://discourse.nodered.org/t/use-ffmpeg-to-convert-rstp-stream-to-mp4/32883 "2020-09-21T11:54:24Z")

</div>

Hi All, There has been some discussion on the forum how to use FFmpeg to convert the RSTP IP Camera feed to MP4. Recently, I tried doing the same with my Reolink cameras and I used the same command that has worked fine…

---

## [Replicate tcp request](https://discourse.nodered.org/t/replicate-tcp-request/33139)

<div class="topic-metadata">

**Author:** [@JosephDe](https://discourse.nodered.org/u/JosephDe)\
**Replies:** 3\
**Last updated:** [21 September 2020 11:08 UTC](https://discourse.nodered.org/t/replicate-tcp-request/33139 "2020-09-21T11:08:09Z")

</div>

Hi everyone! I'm new to node red and want to create customise node to to control my remote device. I would like to start with the functionalities of tcp request node. And later gradually add functions to it. Is there any…

---

## [Inject or Triggers at specific time](https://discourse.nodered.org/t/inject-or-triggers-at-specific-time/33135)

<div class="topic-metadata">

**Author:** [@Henjoe](https://discourse.nodered.org/u/Henjoe)\
**Replies:** 4\
**Last updated:** [21 September 2020 10:40 UTC](https://discourse.nodered.org/t/inject-or-triggers-at-specific-time/33135 "2020-09-21T10:40:01Z")

</div>

Dear Node-red experts, I want to trigger my functions or node at specific time, to be exactly, I need to computer something at every HOUR and every DAY. If time is at \[00:00:00, 01:00:00,02:00:00 and so on and so forth…

---

## [Parsing array of objects](https://discourse.nodered.org/t/parsing-array-of-objects/33126)

<div class="topic-metadata">

**Author:** [@Paul-Reed](https://discourse.nodered.org/u/Paul-Reed)\
**Replies:** 6\
**Last updated:** [21 September 2020 09:56 UTC](https://discourse.nodered.org/t/parsing-array-of-objects/33126 "2020-09-21T09:56:41Z")

</div>

Anyone help with extracting data from an array of objects. { "length":6792, "data":\[ { "fruit":"Apples", "id":32827, "sales":\[ { "week":5, …

---

## [Tips on streamlining this function](https://discourse.nodered.org/t/tips-on-streamlining-this-function/33092)

<div class="topic-metadata">

**Author:** [@877](https://discourse.nodered.org/u/877)\
**Replies:** 21\
**Last updated:** [21 September 2020 09:47 UTC](https://discourse.nodered.org/t/tips-on-streamlining-this-function/33092 "2020-09-21T09:47:44Z")

</div>

Hello all, I have written a function node which works, but I think there must be a clever way of doing it, rather than individual IF/ELSE statements. Here is the flow, simply mqtt json data going through the function n…

---

## [Fs-file-lister: pre fill path from msg.payload](https://discourse.nodered.org/t/fs-file-lister-pre-fill-path-from-msg-payload/33110)

<div class="topic-metadata">

**Author:** [@manjha](https://discourse.nodered.org/u/manjha)\
**Replies:** 4\
**Last updated:** [21 September 2020 09:03 UTC](https://discourse.nodered.org/t/fs-file-lister-pre-fill-path-from-msg-payload/33110 "2020-09-21T09:03:49Z")

</div>

I am using the fs-file-lister node to read info from a file. When I hard code the file path, this works great, content of the file is read. But I want to be able to feed the path information to the node via msg.payload…

---

## [Send an email and include the current IP address](https://discourse.nodered.org/t/send-an-email-and-include-the-current-ip-address/33091)

<div class="topic-metadata">

**Author:** [@volker1078](https://discourse.nodered.org/u/volker1078)\
**Replies:** 12\
**Last updated:** [21 September 2020 09:01 UTC](https://discourse.nodered.org/t/send-an-email-and-include-the-current-ip-address/33091 "2020-09-21T09:01:57Z")

</div>

Hello, I have built in an email alert in Node Red that if a certain value is exceeded I get a mial. Now I would like to transfer my IP address so that when the mail arrives I just have to click on a link with the IP and…

---

## [Ascii string to hex](https://discourse.nodered.org/t/ascii-string-to-hex/33138)

<div class="topic-metadata">

**Author:** [@goc333](https://discourse.nodered.org/u/goc333)\
**Replies:** 1\
**Last updated:** [21 September 2020 08:44 UTC](https://discourse.nodered.org/t/ascii-string-to-hex/33138 "2020-09-21T08:44:19Z")

</div>

Hello everyone, I have some data in database that I need to sand on mqtt. My data looks like this : 50C0E54373C3B68 First thing I need to do is converting this string to hex to look like this: 0x50 0xC0 0xE0... I tr…

---

## [Searching an audio player (+flow) for streams / local files](https://discourse.nodered.org/t/searching-an-audio-player-flow-for-streams-local-files/18714)

<div class="topic-metadata">

**Author:** [@WhiteLion](https://discourse.nodered.org/u/WhiteLion)\
**Replies:** 7\
**Last updated:** [3 December 2019 15:03 UTC](https://discourse.nodered.org/t/searching-an-audio-player-flow-for-streams-local-files/18714 "2019-12-03T15:03:41Z")

</div>

Hiho, I ve a view audio related questions: Is there a way to fast-foward / rewind a mp3 song while playing with PlaySound node? How to play .m3u playlists / streams ? I could manage to extract the steam url from .m3u…

---

## [TCP-Handhake with JVC](https://discourse.nodered.org/t/tcp-handhake-with-jvc/33127)

<div class="topic-metadata">

**Author:** [@rustemg](https://discourse.nodered.org/u/rustemg)\
**Replies:** 5\
**Last updated:** [20 September 2020 23:32 UTC](https://discourse.nodered.org/t/tcp-handhake-with-jvc/33127 "2020-09-20T23:32:57Z")

</div>

Hello! I have projector D-Ila. I use a node "TCP request" (as here TCP/IP 3 way handshake) I'm trying to set up a connection. I manage to send the first command, but the connection remains open. This means that I ca…

---

## [Concatenate Strings from a Payload](https://discourse.nodered.org/t/concatenate-strings-from-a-payload/32895)

<div class="topic-metadata">

**Author:** [@aieseres](https://discourse.nodered.org/u/aieseres)\
**Replies:** 13\
**Last updated:** [20 September 2020 19:40 UTC](https://discourse.nodered.org/t/concatenate-strings-from-a-payload/32895 "2020-09-20T19:40:21Z")

</div>

I'm working on a project where I need to send images from an ESP32-CAM to Node-Red via MQTT. As the image can be very heavy, I chose to split the string (Base64) into chunks and reassemble it in Node-Red. To reassemble I…

---

## [MQTT input to MySQL](https://discourse.nodered.org/t/mqtt-input-to-mysql/33118)

<div class="topic-metadata">

**Author:** [@topche](https://discourse.nodered.org/u/topche)\
**Replies:** 4\
**Last updated:** [20 September 2020 19:05 UTC](https://discourse.nodered.org/t/mqtt-input-to-mysql/33118 "2020-09-20T19:05:59Z")

</div>

I just want to clarify, that i'm completely new in Node Red. Hello, i have my project with NodeMCU+BME280+DS18B20 and tasmota fimware installed nad MQTT brocker. So I have this input on my MQTT comming: {"Time":"2020…

---

## [Notification when Aqara binary senors went offline](https://discourse.nodered.org/t/notification-when-aqara-binary-senors-went-offline/33081)

<div class="topic-metadata">

**Author:** [@terminus](https://discourse.nodered.org/u/terminus)\
**Replies:** 13\
**Last updated:** [20 September 2020 16:53 UTC](https://discourse.nodered.org/t/notification-when-aqara-binary-senors-went-offline/33081 "2020-09-20T16:53:08Z")

</div>

Hey guys! First of all I have to confess, I'm a noob :slight\_smile: I get things working most of the time but if it comes to coding it's over for me :slight\_smile: What I'm trying to do is a "watchdog" for my Zigbee Se…

---

## [If-set-else-set node](https://discourse.nodered.org/t/if-set-else-set-node/33120)

<div class="topic-metadata">

**Author:** [@ludekvodicka](https://discourse.nodered.org/u/ludekvodicka)\
**Replies:** 7\
**Last updated:** [20 September 2020 16:45 UTC](https://discourse.nodered.org/t/if-set-else-set-node/33120 "2020-09-20T16:45:05Z")

</div>

Hello there, sorry for such easy question, probably I missed something, but I can't find a node for following thing. I have system (Loxone) which feeds by flow by some values, for example "0" and "1" as a state of the …

---

## [How to get the bool value of a boolean node](https://discourse.nodered.org/t/how-to-get-the-bool-value-of-a-boolean-node/33116)

<div class="topic-metadata">

**Author:** [@mad\_dad](https://discourse.nodered.org/u/mad_dad)\
**Replies:** 2\
**Last updated:** [20 September 2020 15:41 UTC](https://discourse.nodered.org/t/how-to-get-the-bool-value-of-a-boolean-node/33116 "2020-09-20T15:41:53Z")

</div>

I'm using an OR node, configured as XOR, from the node-red-contrib-bool-gate palette. It's comparing the msg.payload.value of 2 inputs, and the output of the XOR node only shows the input states in debug. Right under t…

---

## [Initialize when opening dashboard tab?](https://discourse.nodered.org/t/initialize-when-opening-dashboard-tab/33111)

<div class="topic-metadata">

**Author:** [@manjha](https://discourse.nodered.org/u/manjha)\
**Replies:** 1\
**Last updated:** [20 September 2020 15:31 UTC](https://discourse.nodered.org/t/initialize-when-opening-dashboard-tab/33111 "2020-09-20T15:31:02Z")

</div>

I am developing a dashboard with a number of tabs, and am looking for a way to initialize the data. Right now I have defined a "refresh" button, which triggers a flow that pulls information from Domoticz and feeds that i…

---

## [\[newbie\] changing a date time format](https://discourse.nodered.org/t/newbie-changing-a-date-time-format/33107)

<div class="topic-metadata">

**Author:** [@hugocoolens](https://discourse.nodered.org/u/hugocoolens)\
**Replies:** 6\
**Last updated:** [20 September 2020 15:19 UTC](https://discourse.nodered.org/t/newbie-changing-a-date-time-format/33107 "2020-09-20T15:19:54Z")

</div>

I made a flow which reads out the temperature from a sensor and writes the temperature together with a timestamp in a file. I'm struggling however with the time-date format: Currently I get data in a tab separated form…

---

## [Convert a flow into an apk](https://discourse.nodered.org/t/convert-a-flow-into-an-apk/33097)

<div class="topic-metadata">

**Author:** [@makram](https://discourse.nodered.org/u/makram)\
**Replies:** 3\
**Last updated:** [20 September 2020 10:16 UTC](https://discourse.nodered.org/t/convert-a-flow-into-an-apk/33097 "2020-09-20T10:16:52Z")

</div>

Is it possible to convert a node red flow into a application or a .exe file

---

## [Mindconnect/MQTT](https://discourse.nodered.org/t/mindconnect-mqtt/33078)

<div class="topic-metadata">

**Author:** [@Tom\_Klein](https://discourse.nodered.org/u/Tom_Klein)\
**Replies:** 4\
**Last updated:** [20 September 2020 11:30 UTC](https://discourse.nodered.org/t/mindconnect-mqtt/33078 "2020-09-20T11:30:37Z")

</div>

Hello everybody, Since I am a beginner in Node-Red and have not yet fully understood everything, I have an important question for you: I'm getting data from a sensor via MQTT, which is already working. These are sent a…

---

## [Need some help scraping a website](https://discourse.nodered.org/t/need-some-help-scraping-a-website/33084)

<div class="topic-metadata">

**Author:** [@mitchell](https://discourse.nodered.org/u/mitchell)\
**Replies:** 3\
**Last updated:** [20 September 2020 08:53 UTC](https://discourse.nodered.org/t/need-some-help-scraping-a-website/33084 "2020-09-20T08:53:02Z")

</div>

I managed to scrap a simple website as test and got the correct data back. But I am trying scrap the “out of stock” notice on here: https://www.nvidia.com/en-gb/shop/geforce/?page=1&limit=9&locale=en-gb So I can make …

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

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