# Latest

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

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

**Page:** 664

---

## [Node-RED select sqlite db and transform the date into an object with arrays](https://discourse.nodered.org/t/node-red-select-sqlite-db-and-transform-the-date-into-an-object-with-arrays/18467)

<div class="topic-metadata">

**Author:** [@Argon](https://discourse.nodered.org/u/Argon)\
**Replies:** 4\
**Last updated:** [2 January 2022 06:54 UTC](https://discourse.nodered.org/t/node-red-select-sqlite-db-and-transform-the-date-into-an-object-with-arrays/18467 "2022-01-02T06:54:08Z")

</div>

Hi, To start with, i'm not a pro coder and rather love it to try new things. So some things that i'm saying here could be completly wrong or maybe i'm trying things that are not seen as best practice. :wink: I'm fillin…

---

## [Dashboard and MS SQL database - number and text input nodes](https://discourse.nodered.org/t/dashboard-and-ms-sql-database-number-and-text-input-nodes/55696)

<div class="topic-metadata">

**Author:** [@Naz](https://discourse.nodered.org/u/Naz)\
**Replies:** 2\
**Last updated:** [25 December 2021 23:19 UTC](https://discourse.nodered.org/t/dashboard-and-ms-sql-database-number-and-text-input-nodes/55696 "2021-12-25T23:19:07Z")

</div>

Hi I am very new to node-red. Im testing something with MS SQL. I made a dashboard with numeric and text input. (User\_ID,First\_Name,Last\_Name) . I want it to insert the information into MS SQL. So I was wondering what…

---

## [typedInput API type/types query](https://discourse.nodered.org/t/typedinput-api-type-types-query/55962)

<div class="topic-metadata">

**Author:** [@borpin](https://discourse.nodered.org/u/borpin)\
**Replies:** 6\
**Last updated:** [1 January 2022 23:07 UTC](https://discourse.nodered.org/t/typedinput-api-type-types-query/55962 "2022-01-01T23:07:47Z")

</div>

https://nodered.org/docs/api/ui/typedInput/ In the docs it lists 3 Options; But in the examples is has type which is not listed as an option. Is type the default for this input? Could I replace type:'str' with typ…

---

## [Error with library on function node, is a bug?](https://discourse.nodered.org/t/error-with-library-on-function-node-is-a-bug/55927)

<div class="topic-metadata">

**Author:** [@essereumano](https://discourse.nodered.org/u/essereumano)\
**Replies:** 8\
**Last updated:** [1 January 2022 22:42 UTC](https://discourse.nodered.org/t/error-with-library-on-function-node-is-a-bug/55927 "2022-01-01T22:42:05Z")

</div>

Hello everyone and happy new year. I am using node red 2.1.4 and in the function node I have inserted the library moment in the setup tab, it works correctly but if I go back to the tab on message and I click on the butt…

---

## [HTTP Post template to receive JSON payload](https://discourse.nodered.org/t/http-post-template-to-receive-json-payload/55963)

<div class="topic-metadata">

**Author:** [@thejollypop](https://discourse.nodered.org/u/thejollypop)\
**Replies:** 9\
**Last updated:** [1 January 2022 21:57 UTC](https://discourse.nodered.org/t/http-post-template-to-receive-json-payload/55963 "2022-01-01T21:57:42Z")

</div>

Hi all, my flow parses textual data using a template and GET method, however I am unable to post the result programmatically as a JSON. I want it to be generic and simple, without using scope.send or the 'form' method -…

---

## [Custom node not showing up in Manage Pallette](https://discourse.nodered.org/t/custom-node-not-showing-up-in-manage-pallette/55946)

<div class="topic-metadata">

**Author:** [@shanajira](https://discourse.nodered.org/u/shanajira)\
**Replies:** 7\
**Last updated:** [1 January 2022 21:36 UTC](https://discourse.nodered.org/t/custom-node-not-showing-up-in-manage-pallette/55946 "2022-01-01T21:36:52Z")

</div>

Hello I have been struggling with this problem for a while. Here is the summary: -I have created a very small custom node. Updated the package.json file -followed the instructions to create a custom node. -I have …

---

## [\[uibuilder\] The next step - 3rd-party comms with a uibuilder front-end](https://discourse.nodered.org/t/uibuilder-the-next-step-3rd-party-comms-with-a-uibuilder-front-end/51684)

<div class="topic-metadata">

**Author:** [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Replies:** 27\
**Last updated:** [1 January 2022 20:06 UTC](https://discourse.nodered.org/t/uibuilder-the-next-step-3rd-party-comms-with-a-uibuilder-front-end/51684 "2022-01-01T20:06:21Z")

</div>

Hi all, with the ongoing discussion about the future of Node-RED dashboards, I've been doing yet more work on making uibuilder a better foundation to build on. This proposal lays out a likely approach to enabling anyone…

---

## [Telegram receive channel messages](https://discourse.nodered.org/t/telegram-receive-channel-messages/55928)

<div class="topic-metadata">

**Author:** [@Ferryb](https://discourse.nodered.org/u/Ferryb)\
**Replies:** 2\
**Last updated:** [1 January 2022 19:17 UTC](https://discourse.nodered.org/t/telegram-receive-channel-messages/55928 "2022-01-01T19:17:49Z")

</div>

I'm trying to read a telegram channel but I can't get it to work. I can read my bot but not a channel linked to this bot. Anyone have an idea if this is possible?

---

## [Beginner create a test node Circular dependency issue](https://discourse.nodered.org/t/beginner-create-a-test-node-circular-dependency-issue/55958)

<div class="topic-metadata">

**Author:** [@bbartling](https://discourse.nodered.org/u/bbartling)\
**Replies:** 9\
**Last updated:** [1 January 2022 17:50 UTC](https://discourse.nodered.org/t/beginner-create-a-test-node-circular-dependency-issue/55958 "2022-01-01T17:50:31Z")

</div>

I'm experimenting trying to learn how to create nodes with installing them locally with npm install on the package.json file. For learning purposes & experimentation, I have very generic node called msg-recycler where a…

---

## [Home Assistant dimmer slider integration](https://discourse.nodered.org/t/home-assistant-dimmer-slider-integration/55925)

<div class="topic-metadata">

**Author:** [@Markusbj](https://discourse.nodered.org/u/Markusbj)\
**Replies:** 3\
**Last updated:** [1 January 2022 16:40 UTC](https://discourse.nodered.org/t/home-assistant-dimmer-slider-integration/55925 "2022-01-01T16:40:27Z")

</div>

Hi I woud like to create and integrate dimmer slider switch from Node-Red to Home Assistant, lika switcher integration. How can i create a dimmer switch? I have installed a HASC dimmer but I dont have a entity in HA li…

---

## [Node-red-contrib-influxdb specifying parameters in a function node](https://discourse.nodered.org/t/node-red-contrib-influxdb-specifying-parameters-in-a-function-node/55934)

<div class="topic-metadata">

**Author:** [@Bodad](https://discourse.nodered.org/u/Bodad)\
**Replies:** 5\
**Last updated:** [1 January 2022 15:30 UTC](https://discourse.nodered.org/t/node-red-contrib-influxdb-specifying-parameters-in-a-function-node/55934 "2022-01-01T15:30:25Z")

</div>

Hi, I'm using node-Red (V2.0.3) to write to an Influx server (1.8.10) with two databases using this contrib. Writing the data is going Ok but I'm being stumped by writing a node-Red function to query the timestamp of th…

---

## [Mutiple http request issue](https://discourse.nodered.org/t/mutiple-http-request-issue/55955)

<div class="topic-metadata">

**Author:** [@dineshaj](https://discourse.nodered.org/u/dineshaj)\
**Replies:** 1\
**Last updated:** [1 January 2022 12:54 UTC](https://discourse.nodered.org/t/mutiple-http-request-issue/55955 "2022-01-01T12:54:07Z")

</div>

Hi i have a basic auth username and password in JSON as follows (close to 100). { { "username": "user1", "password": "pass1" }, { "username": "user2", "pa…

---

## [Node-red-contrib-p1reader error](https://discourse.nodered.org/t/node-red-contrib-p1reader-error/55650)

<div class="topic-metadata">

**Author:** [@old-grumpy](https://discourse.nodered.org/u/old-grumpy)\
**Replies:** 18\
**Last updated:** [1 January 2022 12:05 UTC](https://discourse.nodered.org/t/node-red-contrib-p1reader-error/55650 "2022-01-01T12:05:24Z")

</div>

node-red-contrib-p1reader installed and worked got data to debug node. Now it give this error and i have no idea how to solve. Reinstall the node,rebooted the pi.Only thing i dit not is turn the pi off as is remote and…

---

## [Interactive chart with zoom and a cursor functionality](https://discourse.nodered.org/t/interactive-chart-with-zoom-and-a-cursor-functionality/55926)

<div class="topic-metadata">

**Author:** [@ChankyTheConqueror](https://discourse.nodered.org/u/ChankyTheConqueror)\
**Replies:** 4\
**Last updated:** [1 January 2022 11:59 UTC](https://discourse.nodered.org/t/interactive-chart-with-zoom-and-a-cursor-functionality/55926 "2022-01-01T11:59:24Z")

</div>

Dear developers, I was wondering whether the chart node incase of a time graph, could be enhanced to have a option of having a second y-axis (or n y axes),data coming in could be differentiated with a new property e.g …

---

## [Alexa Voice Service](https://discourse.nodered.org/t/alexa-voice-service/55950)

<div class="topic-metadata">

**Author:** [@sammachin](https://discourse.nodered.org/u/sammachin)\
**Replies:** 0\
**Last updated:** [1 January 2022 09:56 UTC](https://discourse.nodered.org/t/alexa-voice-service/55950 "2022-01-01T09:56:51Z")

</div>

More of a writeup in my blog post Sam Machin | AlexaWeb Reborn TL;DR a browser based Alexa client implemented totally in Node-RED Looking at separating some of the custom function code out into new nodes now

---

## [Notify Message Call Service Problem](https://discourse.nodered.org/t/notify-message-call-service-problem/55940)

<div class="topic-metadata">

**Author:** [@erausch](https://discourse.nodered.org/u/erausch)\
**Replies:** 4\
**Last updated:** [1 January 2022 07:02 UTC](https://discourse.nodered.org/t/notify-message-call-service-problem/55940 "2022-01-01T07:02:07Z")

</div>

Hi All, I have a flow that will notify any family member that enters our home, via Alexa, who is currently away, and who is also home. (Credit to Tom Schneider for creating the original flow Let Alexa welcome you home )…

---

## [Can't Connect to local IP](https://discourse.nodered.org/t/cant-connect-to-local-ip/55909)

<div class="topic-metadata">

**Author:** [@diogoqwe](https://discourse.nodered.org/u/diogoqwe)\
**Replies:** 23\
**Last updated:** [31 December 2021 20:32 UTC](https://discourse.nodered.org/t/cant-connect-to-local-ip/55909 "2021-12-31T20:32:00Z")

</div>

Basically when i start node red on ubuntu 20.04(virtual machine) it starts and to use it i need to pick my windows local ip address to enter in node red. But it doesnt work. The page doesnt load.

---

## [Node-red-contrib-drawsvg when using Docker (IOTstack)](https://discourse.nodered.org/t/node-red-contrib-drawsvg-when-using-docker-iotstack/55450)

<div class="topic-metadata">

**Author:** [@bogi](https://discourse.nodered.org/u/bogi)\
**Replies:** 19\
**Last updated:** [31 December 2021 23:45 UTC](https://discourse.nodered.org/t/node-red-contrib-drawsvg-when-using-docker-iotstack/55450 "2021-12-31T23:45:26Z")

</div>

Guys, I love IOTstack idea on RB Pi4 with Node-RED and so on. By studying this wonderful forum i found fantastic tools I'd love to use in my system. One of the most wanted is the ability to make my own layouts, photos, …

---

## [Node-red-contrib-ffmpeg-spawn dev](https://discourse.nodered.org/t/node-red-contrib-ffmpeg-spawn-dev/54850)

<div class="topic-metadata">

**Author:** [@kevinGodell](https://discourse.nodered.org/u/kevinGodell)\
**Replies:** 3\
**Last updated:** [31 December 2021 21:52 UTC](https://discourse.nodered.org/t/node-red-contrib-ffmpeg-spawn-dev/54850 "2021-12-31T21:52:17Z")

</div>

...continued from Node-red-contrib-ffmpeg-spawn I am currently working on adding support for credentials in node-red-contrib-ffmpeg-spawn. The situation is that many people, myself included, use ffmpeg to connect to an…

---

## [Project authentication failure - The thing I never remember when things stop working](https://discourse.nodered.org/t/project-authentication-failure-the-thing-i-never-remember-when-things-stop-working/55938)

<div class="topic-metadata">

**Author:** [@Mrb32](https://discourse.nodered.org/u/Mrb32)\
**Replies:** 0\
**Last updated:** [31 December 2021 18:51 UTC](https://discourse.nodered.org/t/project-authentication-failure-the-thing-i-never-remember-when-things-stop-working/55938 "2021-12-31T18:51:45Z")

</div>

Ever since GitHub changed their authentication, I always get stuck on this for some reason... I set SSH encryption up, and use a GitHub personal access token, nothing particularly exotic. I use a Mac and save my GitHub…

---

## [Light / packing NodeRed](https://discourse.nodered.org/t/light-packing-nodered/55912)

<div class="topic-metadata">

**Author:** [@thalesmaoa](https://discourse.nodered.org/u/thalesmaoa)\
**Replies:** 6\
**Last updated:** [31 December 2021 19:17 UTC](https://discourse.nodered.org/t/light-packing-nodered/55912 "2021-12-31T19:17:29Z")

</div>

Hi there, I've been using NodeRed for almost everything now. Since I have a server running, I send almost everything to it and deploy. Fast curve of development. Mainly with sensors and IoT. However, I'm facing a peculi…

---

## [How to get the date for the last Monday from today?](https://discourse.nodered.org/t/how-to-get-the-date-for-the-last-monday-from-today/55857)

<div class="topic-metadata">

**Author:** [@Romprod](https://discourse.nodered.org/u/Romprod)\
**Replies:** 4\
**Last updated:** [31 December 2021 17:28 UTC](https://discourse.nodered.org/t/how-to-get-the-date-for-the-last-monday-from-today/55857 "2021-12-31T17:28:15Z")

</div>

Hey guys, I'm looking for an automated way to get the date for the previous Monday from 'today' So for example if I check now it would return 27-12-2021 and if I run it in 7 days time it would be 03-12-2021 etc etc Is…

---

## [Node-red-contrib-mp4frag dev](https://discourse.nodered.org/t/node-red-contrib-mp4frag-dev/55930)

<div class="topic-metadata">

**Author:** [@kevinGodell](https://discourse.nodered.org/u/kevinGodell)\
**Replies:** 0\
**Last updated:** [31 December 2021 15:14 UTC](https://discourse.nodered.org/t/node-red-contrib-mp4frag-dev/55930 "2021-12-31T15:14:19Z")

</div>

I recently made a change to allow the node's status to be displayed, wired, both, or none. I realize that I was probably pushing too much information to the editor's status and did not allow for that info to be routed to…

---

## [Override dashboard-chart hover over graph?](https://discourse.nodered.org/t/override-dashboard-chart-hover-over-graph/55929)

<div class="topic-metadata">

**Author:** [@Damorck](https://discourse.nodered.org/u/Damorck)\
**Replies:** 0\
**Last updated:** [31 December 2021 15:02 UTC](https://discourse.nodered.org/t/override-dashboard-chart-hover-over-graph/55929 "2021-12-31T15:02:31Z")

</div>

When hovering over my graph the text box is too small. How to overide this? My example:

---

## [Need help to setup Play sound node](https://discourse.nodered.org/t/need-help-to-setup-play-sound-node/55004)

<div class="topic-metadata">

**Author:** [@funhall](https://discourse.nodered.org/u/funhall)\
**Replies:** 21\
**Last updated:** [31 December 2021 14:18 UTC](https://discourse.nodered.org/t/need-help-to-setup-play-sound-node/55004 "2021-12-31T14:18:39Z")

</div>

I like to use play sound node but dont understand how to fill out the player options and the Audio options. I have 2 setup- one with sound thru the HDMI and one on usb sound card. I really hope someone can help me. th…

---

## [Specify user in the update-nodejs-and-nodered script](https://discourse.nodered.org/t/specify-user-in-the-update-nodejs-and-nodered-script/55871)

<div class="topic-metadata">

**Author:** [@trentinc](https://discourse.nodered.org/u/trentinc)\
**Replies:** 4\
**Last updated:** [31 December 2021 14:10 UTC](https://discourse.nodered.org/t/specify-user-in-the-update-nodejs-and-nodered-script/55871 "2021-12-31T14:10:49Z")

</div>

I've been learning Ansible for automatic deployment of NODE-RED and ran into a stumbling block. The pi zero w (assuming all armv6's) doesn't have an official nodejs rep so one would need to use the bash \<(curl -sL https…

---

## [Timezone setting for Node Red on Home Assistant OS](https://discourse.nodered.org/t/timezone-setting-for-node-red-on-home-assistant-os/55923)

<div class="topic-metadata">

**Author:** [@thanhtam23](https://discourse.nodered.org/u/thanhtam23)\
**Replies:** 2\
**Last updated:** [31 December 2021 13:38 UTC](https://discourse.nodered.org/t/timezone-setting-for-node-red-on-home-assistant-os/55923 "2021-12-31T13:38:32Z")

</div>

Hi, I'm new to Node Red but found it's very helpful to setup my home automation flow. I have setup time range to turn on my light during night time only but somehow the return timing look incorrect. My other steps are…

---

## [Help to know telegram chat ID](https://discourse.nodered.org/t/help-to-know-telegram-chat-id/55918)

<div class="topic-metadata">

**Author:** [@dlorenzo](https://discourse.nodered.org/u/dlorenzo)\
**Replies:** 4\
**Last updated:** [31 December 2021 13:02 UTC](https://discourse.nodered.org/t/help-to-know-telegram-chat-id/55918 "2021-12-31T13:02:34Z")

</div>

Hi friends. I'm using NR v 2.1.3 with node-red-contrib-telegrambot, and need to know the chat ID of the group I'm using with NR. Two weeks ago I found a way using "telegram receiver" node. I just need to post something…

---

## [Problem with node-red-contrib-buffer-parser after upgrading node-RED](https://discourse.nodered.org/t/problem-with-node-red-contrib-buffer-parser-after-upgrading-node-red/55907)

<div class="topic-metadata">

**Author:** [@sad\_cyrano](https://discourse.nodered.org/u/sad_cyrano)\
**Replies:** 2\
**Last updated:** [31 December 2021 12:02 UTC](https://discourse.nodered.org/t/problem-with-node-red-contrib-buffer-parser-after-upgrading-node-red/55907 "2021-12-31T12:02:17Z")

</div>

I work with the really ingenious buffer-parser-node but after changing Node-RED to version 2.1.4 I get a strange error. I have tried it on several platforms (Raspberry Pi and Windows PC) but the result is always the same…

---

## [Canceling payload for a period of time after a state change](https://discourse.nodered.org/t/canceling-payload-for-a-period-of-time-after-a-state-change/55911)

<div class="topic-metadata">

**Author:** [@Rockyca](https://discourse.nodered.org/u/Rockyca)\
**Replies:** 2\
**Last updated:** [31 December 2021 10:38 UTC](https://discourse.nodered.org/t/canceling-payload-for-a-period-of-time-after-a-state-change/55911 "2021-12-31T10:38:48Z")

</div>

I am trying to cancel payload for a period of time after a state change. Automation is as follows: If motion is detected at my front door then send a notification to my phone. if the front door has been opened, cancel…

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

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