# Latest

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

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

**Page:** 1123

---

## [Custom Node Error missing types](https://discourse.nodered.org/t/custom-node-error-missing-types/24379)

<div class="topic-metadata">

**Author:** [@Iliyas](https://discourse.nodered.org/u/Iliyas)\
**Replies:** 1\
**Last updated:** [7 April 2020 07:34 UTC](https://discourse.nodered.org/t/custom-node-error-missing-types/24379 "2020-04-07T07:34:25Z")

</div>

Hello All, I have created a custom node and I have deployed it successfully it is working fine but now I have some done some changes in my node.js code and I have replaced my previous custom node code with this code but…

---

## [External Cloudant intermittent error 401](https://discourse.nodered.org/t/external-cloudant-intermittent-error-401/23255)

<div class="topic-metadata">

**Author:** [@piptan](https://discourse.nodered.org/u/piptan)\
**Replies:** 1\
**Last updated:** [7 April 2020 07:28 UTC](https://discourse.nodered.org/t/external-cloudant-intermittent-error-401/23255 "2020-04-07T07:28:46Z")

</div>

Hi, I can successfully access external Cloudant DB from my node. But, from time to time, I receive error "couch returned 401". All I have to do to fix this is to go to External Cloudant server properties 's edit page an…

---

## [Error al intentar instalar libreria nodo modbus tcp](https://discourse.nodered.org/t/error-al-intentar-instalar-libreria-nodo-modbus-tcp/24362)

<div class="topic-metadata">

**Author:** [@JulianTN](https://discourse.nodered.org/u/JulianTN)\
**Replies:** 0\
**Last updated:** [6 April 2020 23:15 UTC](https://discourse.nodered.org/t/error-al-intentar-instalar-libreria-nodo-modbus-tcp/24362 "2020-04-06T23:15:57Z")

</div>

Hola, soy un poco nuevo en lo que es Node-RED. estoy intentando generar un servidor para la herramienta de Schneider, Augmented Operator Advisor. Abro el editor de node-red desde el manager de AOA, intento instalar la …

---

## [Get events from google calendar](https://discourse.nodered.org/t/get-events-from-google-calendar/4830)

<div class="topic-metadata">

**Author:** [@Xenobiologist](https://discourse.nodered.org/u/Xenobiologist)\
**Replies:** 21\
**Last updated:** [6 April 2020 22:13 UTC](https://discourse.nodered.org/t/get-events-from-google-calendar/4830 "2020-04-06T22:13:34Z")

</div>

Hello, I would like to get a list of events between two dates (start /end) or all events for the next (3 / 7) days. I'm currently using # node-red-node-google 0.1.4 My problem is, that these nodes only provide the opt…

---

## [Ignore same message within 5 seconds](https://discourse.nodered.org/t/ignore-same-message-within-5-seconds/24274)

<div class="topic-metadata">

**Author:** [@cymplecy](https://discourse.nodered.org/u/cymplecy)\
**Replies:** 16\
**Last updated:** [6 April 2020 20:57 UTC](https://discourse.nodered.org/t/ignore-same-message-within-5-seconds/24274 "2020-04-06T20:57:10Z")

</div>

I'm trying to come up with a method of ignoring short term duplicate messages But this little idea doesn't quite seem to work in the way I want it to i.e use RBE to block repeats but reset it 5 secs after a message com…

---

## [UI-Table: how to use commands to add / update table content dynamically](https://discourse.nodered.org/t/ui-table-how-to-use-commands-to-add-update-table-content-dynamically/23240)

<div class="topic-metadata">

**Author:** [@Battassini](https://discourse.nodered.org/u/Battassini)\
**Replies:** 18\
**Last updated:** [6 April 2020 20:45 UTC](https://discourse.nodered.org/t/ui-table-how-to-use-commands-to-add-update-table-content-dynamically/23240 "2020-04-06T20:45:07Z")

</div>

Good afternoon guys. I have a question and I'm going to the forum for sure someone will know the answer. I'll try to explain. I'm using for learning and ready example of the ui table node( node-red-node-ui-table). In …

---

## ["Error: unable to verify the first certificate"](https://discourse.nodered.org/t/error-unable-to-verify-the-first-certificate/24345)

<div class="topic-metadata">

**Author:** [@boesh](https://discourse.nodered.org/u/boesh)\
**Replies:** 0\
**Last updated:** [6 April 2020 18:50 UTC](https://discourse.nodered.org/t/error-unable-to-verify-the-first-certificate/24345 "2020-04-06T18:50:12Z")

</div>

Hi, I'm new to Node-RED and I'm trying and doing some easy first steps. I have solar-edge node installed using the right site-ID and API-ID but get stuck with the following error "Error: unable to verify the first cer…

---

## [Dashboard admin page](https://discourse.nodered.org/t/dashboard-admin-page/24327)

<div class="topic-metadata">

**Author:** [@Beefy\_carrot](https://discourse.nodered.org/u/Beefy_carrot)\
**Replies:** 3\
**Last updated:** [6 April 2020 20:11 UTC](https://discourse.nodered.org/t/dashboard-admin-page/24327 "2020-04-06T20:11:19Z")

</div>

Hi! i want to make a UI with admin functions( add sensor, delete sensor, set sensor meta data rules) and having a page for view of data. does the node-red dashboard have limitiations for interacting with the nodes and va…

---

## [Node-red slowly](https://discourse.nodered.org/t/node-red-slowly/24342)

<div class="topic-metadata">

**Author:** [@Folgore](https://discourse.nodered.org/u/Folgore)\
**Replies:** 4\
**Last updated:** [6 April 2020 19:22 UTC](https://discourse.nodered.org/t/node-red-slowly/24342 "2020-04-06T19:22:33Z")

</div>

Hi , I am crazy and I know, but i have a problem with my flow.... I want read an array json (now with 903 element) to put in a 80 chart. I have first start with a for...but the dashboard lost the communication, I have m…

---

## [Search Array and output Boolean](https://discourse.nodered.org/t/search-array-and-output-boolean/24341)

<div class="topic-metadata">

**Author:** [@nadamson](https://discourse.nodered.org/u/nadamson)\
**Replies:** 4\
**Last updated:** [6 April 2020 18:47 UTC](https://discourse.nodered.org/t/search-array-and-output-boolean/24341 "2020-04-06T18:47:43Z")

</div>

Hello All, I have an array that I would like to be able to search for certain strings. Here is an example of the array output in the Debug window. \["LA","NJ","NJ-NJ","NJ-NJ","NJ-NJ","NJ-NJ","MS1","WA"\] Then I would l…

---

## [\[SUGGESTION\] Flow library format for contributed node examples](https://discourse.nodered.org/t/suggestion-flow-library-format-for-contributed-node-examples/24293)

<div class="topic-metadata">

**Author:** [@drmibell](https://discourse.nodered.org/u/drmibell)\
**Replies:** 3\
**Last updated:** [6 April 2020 18:19 UTC](https://discourse.nodered.org/t/suggestion-flow-library-format-for-contributed-node-examples/24293 "2020-04-06T18:19:26Z")

</div>

It would be nice if the flow library could show the sample flows for contributed nodes in the same way that the cookbook formats its examples. That is, hide the JSON until the user presses a Show flow button and then pro…

---

## ["Rate detection" - can it be done "easily"?](https://discourse.nodered.org/t/rate-detection-can-it-be-done-easily/24188)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 9\
**Last updated:** [6 April 2020 17:50 UTC](https://discourse.nodered.org/t/rate-detection-can-it-be-done-easily/24188 "2020-04-06T17:50:45Z")

</div>

Sort of from my other post about finding the error, The problem is still a bit unknown to what happened. It is now possible it was on another machine and the error handling parts of the flow went into overdrive. :fro…

---

## [I can't install a palette](https://discourse.nodered.org/t/i-cant-install-a-palette/24339)

<div class="topic-metadata">

**Author:** [@oceane](https://discourse.nodered.org/u/oceane)\
**Replies:** 0\
**Last updated:** [6 April 2020 17:25 UTC](https://discourse.nodered.org/t/i-cant-install-a-palette/24339 "2020-04-06T17:25:42Z")

</div>

Hello, i want to install the palette : node-red-node-sqlite. I tried to install it by terminal or by Node-red directly My log : C:\\Users\\perri\\AppData\\Roaming\\npm\\node\_modules\\node-red\>npm install node-red-node-sqlite …

---

## [Java to JSON conversion](https://discourse.nodered.org/t/java-to-json-conversion/24332)

<div class="topic-metadata">

**Author:** [@makowski13](https://discourse.nodered.org/u/makowski13)\
**Replies:** 4\
**Last updated:** [6 April 2020 17:15 UTC](https://discourse.nodered.org/t/java-to-json-conversion/24332 "2020-04-06T17:15:47Z")

</div>

I imported a java code and received an JSON array error, can anyone help?

---

## [Getting started with Dashboards](https://discourse.nodered.org/t/getting-started-with-dashboards/24322)

<div class="topic-metadata">

**Author:** [@jakorten](https://discourse.nodered.org/u/jakorten)\
**Replies:** 5\
**Last updated:** [6 April 2020 17:15 UTC](https://discourse.nodered.org/t/getting-started-with-dashboards/24322 "2020-04-06T17:15:09Z")

</div>

Hi gals and guys, I'm just starting with Node-RED on a Raspberry Pi: Node-RED version: v1.0.3 Node.js version: v10.15.2 Linux 4.19.97-v7l+ arm LE (Raspbian Buster) The thing is I want to create a simple MQTT applic…

---

## [\[Feedback Needed\] Russian language translation](https://discourse.nodered.org/t/feedback-needed-russian-language-translation/21280)

<div class="topic-metadata">

**Author:** [@7dir](https://discourse.nodered.org/u/7dir)\
**Replies:** 7\
**Last updated:** [6 April 2020 17:14 UTC](https://discourse.nodered.org/t/feedback-needed-russian-language-translation/21280 "2020-04-06T17:14:23Z")

</div>

Hello! My name is Michael. I\`m from Russia. I took interest in the node-red. I\`d like to localize node-red on the Russian Market. I\`ll send Pull Request. Could you give me your consent or some comment.

---

## [\[PR\] add typed input for filename prop on native file(in) node](https://discourse.nodered.org/t/pr-add-typed-input-for-filename-prop-on-native-file-in-node/24253)

<div class="topic-metadata">

**Author:** [@bug00](https://discourse.nodered.org/u/bug00)\
**Replies:** 13\
**Last updated:** [6 April 2020 16:14 UTC](https://discourse.nodered.org/t/pr-add-typed-input-for-filename-prop-on-native-file-in-node/24253 "2020-04-06T16:14:06Z")

</div>

Hi, i have fork node and extend file / file in node on filename properties for add choice of input type (msg, str, jsonata, ...) Default it's str type with "" value, then old confidg node won't be impacted by this smal…

---

## [Fatal error Unable to import automationhat python library](https://discourse.nodered.org/t/fatal-error-unable-to-import-automationhat-python-library/24326)

<div class="topic-metadata">

**Author:** [@drikos\_pag](https://discourse.nodered.org/u/drikos_pag)\
**Replies:** 1\
**Last updated:** [6 April 2020 15:47 UTC](https://discourse.nodered.org/t/fatal-error-unable-to-import-automationhat-python-library/24326 "2020-04-06T15:47:32Z")

</div>

Hello to everybody, I would like to give me your help regarding one issue that I have. I have installed the node red to my Mac and when I tried to start today the node-red I have the following error: 6 Apr 18:05:59 - …

---

## [Stop interval trigger with msg.reset](https://discourse.nodered.org/t/stop-interval-trigger-with-msg-reset/24305)

<div class="topic-metadata">

**Author:** [@mansahlgren](https://discourse.nodered.org/u/mansahlgren)\
**Replies:** 15\
**Last updated:** [6 April 2020 15:26 UTC](https://discourse.nodered.org/t/stop-interval-trigger-with-msg-reset/24305 "2020-04-06T15:26:11Z")

</div>

I have a function node, f1, which triggers a trigger node so that it (the trigger node) starts generating pulses according to an interval. The pulses trigger another function node, f2, which simulates data for a given t…

---

## [Using global variables in a paragraph / template](https://discourse.nodered.org/t/using-global-variables-in-a-paragraph-template/24299)

<div class="topic-metadata">

**Author:** [@mixnode](https://discourse.nodered.org/u/mixnode)\
**Replies:** 3\
**Last updated:** [6 April 2020 14:20 UTC](https://discourse.nodered.org/t/using-global-variables-in-a-paragraph-template/24299 "2020-04-06T14:20:36Z")

</div>

Hi, I have some global variables set. Like sun.rise. Seems to be in the context data. I'd like to retrieve them and use them in a dashboard template, or in a function that is crafted to output to a template. I've name…

---

## [Anybody knows how to use predictor node in machine learning node package?](https://discourse.nodered.org/t/anybody-knows-how-to-use-predictor-node-in-machine-learning-node-package/24323)

<div class="topic-metadata">

**Author:** [@Phil](https://discourse.nodered.org/u/Phil)\
**Replies:** 0\
**Last updated:** [6 April 2020 15:02 UTC](https://discourse.nodered.org/t/anybody-knows-how-to-use-predictor-node-in-machine-learning-node-package/24323 "2020-04-06T15:02:00Z")

</div>

I am trying to build a project with node-red-contrib-machine-learning. the example given on the page is working till the last sample . when I try to input my own value there seems to be some error. does anybody know the…

---

## [Setting Dynamic Data in N.R. for uibuilder jQuery F.E.?](https://discourse.nodered.org/t/setting-dynamic-data-in-n-r-for-uibuilder-jquery-f-e/24304)

<div class="topic-metadata">

**Author:** [@Digital-Thor](https://discourse.nodered.org/u/Digital-Thor)\
**Replies:** 1\
**Last updated:** [6 April 2020 14:32 UTC](https://discourse.nodered.org/t/setting-dynamic-data-in-n-r-for-uibuilder-jquery-f-e/24304 "2020-04-06T14:32:08Z")

</div>

I'm making progress with the basics of uibuilder, but not quite following how to catch changes in "dynamic" data. Let's say I want to catch a value change in the client side jQuery app using the uibuilder pattern: ui…

---

## [Basic url works fine in browser not in node-red HTTP request](https://discourse.nodered.org/t/basic-url-works-fine-in-browser-not-in-node-red-http-request/24316)

<div class="topic-metadata">

**Author:** [@rwmingis](https://discourse.nodered.org/u/rwmingis)\
**Replies:** 2\
**Last updated:** [6 April 2020 13:45 UTC](https://discourse.nodered.org/t/basic-url-works-fine-in-browser-not-in-node-red-http-request/24316 "2020-04-06T13:45:30Z")

</div>

Hi there, I'm trying to access Sydney airport json data at: http://www.bom.gov.au/fwo/IDN60801/IDN60801.94767.json When I navigate there in chrome, it works fine and I get a page full of JSON data. When I access it f…

---

## [Node-red for web-based simulations](https://discourse.nodered.org/t/node-red-for-web-based-simulations/19285)

<div class="topic-metadata">

**Author:** [@Federico](https://discourse.nodered.org/u/Federico)\
**Replies:** 4\
**Last updated:** [6 April 2020 13:25 UTC](https://discourse.nodered.org/t/node-red-for-web-based-simulations/19285 "2020-04-06T13:25:06Z")

</div>

Hello everyone, do you think is possible to use Node-red and its node wiring editor for discrete event / agent based simulation with the OESjs simulation framework? In principle it should be viable, by using the OESjs …

---

## [UI-SVG - elementid](https://discourse.nodered.org/t/ui-svg-elementid/24004)

<div class="topic-metadata">

**Author:** [@greenembrace](https://discourse.nodered.org/u/greenembrace)\
**Replies:** 14\
**Last updated:** [6 April 2020 08:36 UTC](https://discourse.nodered.org/t/ui-svg-elementid/24004 "2020-04-06T08:36:59Z")

</div>

Hi, dashboard SVG Node: Events Property: Selector field: I have created a selector to access multiple id's as per Christmas lights example. my selector field -\> \[id^=Output-5\] does select correctly all Id's starti…

---

## [Occur error when run command \`sudo npm install -g node-red-admin\`](https://discourse.nodered.org/t/occur-error-when-run-command-sudo-npm-install-g-node-red-admin/24271)

<div class="topic-metadata">

**Author:** [@lingzhongli](https://discourse.nodered.org/u/lingzhongli)\
**Replies:** 7\
**Last updated:** [6 April 2020 07:55 UTC](https://discourse.nodered.org/t/occur-error-when-run-command-sudo-npm-install-g-node-red-admin/24271 "2020-04-06T07:55:44Z")

</div>

How to solve this problem?

---

## [Inserting to mySql database](https://discourse.nodered.org/t/inserting-to-mysql-database/24294)

<div class="topic-metadata">

**Author:** [@iankillz](https://discourse.nodered.org/u/iankillz)\
**Replies:** 2\
**Last updated:** [6 April 2020 07:36 UTC](https://discourse.nodered.org/t/inserting-to-mysql-database/24294 "2020-04-06T07:36:22Z")

</div>

Hello guys, I need help inserting the value from a function to my MySql database but every time I deploy, it says "Error: ER\_BAD\_FIELD\_ERROR: Unknown column 'available' in 'field list'" " This is my flow so the change n…

---

## [Bitcoin wallet set nodes?](https://discourse.nodered.org/t/bitcoin-wallet-set-nodes/24292)

<div class="topic-metadata">

**Author:** [@lizzardguki](https://discourse.nodered.org/u/lizzardguki)\
**Replies:** 2\
**Last updated:** [6 April 2020 06:12 UTC](https://discourse.nodered.org/t/bitcoin-wallet-set-nodes/24292 "2020-04-06T06:12:10Z")

</div>

Why no one of the contributors built a node-red node/nodes for use with bitcoin ?

---

## [Run a function if I receive a direct message or a mention in Slack?](https://discourse.nodered.org/t/run-a-function-if-i-receive-a-direct-message-or-a-mention-in-slack/24266)

<div class="topic-metadata">

**Author:** [@mversion](https://discourse.nodered.org/u/mversion)\
**Replies:** 1\
**Last updated:** [6 April 2020 00:12 UTC](https://discourse.nodered.org/t/run-a-function-if-i-receive-a-direct-message-or-a-mention-in-slack/24266 "2020-04-06T00:12:45Z")

</div>

I'm sure this is doable, but don't know where to start. So, my idea is to switch on a tp-link light, if I have an unread direct message or a @mention of my username in Slack and then turn it off if I clear my unread cou…

---

## [Excel: how to write in desired cell](https://discourse.nodered.org/t/excel-how-to-write-in-desired-cell/24291)

<div class="topic-metadata">

**Author:** [@rromele](https://discourse.nodered.org/u/rromele)\
**Replies:** 3\
**Last updated:** [5 April 2020 23:47 UTC](https://discourse.nodered.org/t/excel-how-to-write-in-desired-cell/24291 "2020-04-05T23:47:15Z")

</div>

Hi, should I write this message in cell "C3", how can this be done with the node "file"? \[{"id":"2735b2c2.710b4e","type":"file","z":"9c807128.5de97","name":"","filename":"c:\\\\a\\\\12345.xls","appendNewline":true,"create…

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

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