Node-Red + FileMaker QuickStart and Links

v1.2
Revision 14.02.2021
Marcel Moré
https://twitter.com/mmore

Background: What is Node Red?

- LowCode Plattform
- Comparable to Claris Connect
- OpenSource (originally from IBM)
- based on NodeJS
. Message-Broker, processes JSON messages 
- available for all platforms/operating systems
- Internet of Things (IoT)
- Home-Automation
- numerous Plugins

Node-RED: Ein Baukasten für das Internet der Dinge
https://jaxenter.de/baukasten-fuer-das-internet-dinge-13532

About
https://nodered.org/about/

Node Red

Homepage
https://nodered.org

Documentation
https://nodered.org/docs/

Forum
https://discourse.nodered.org

Plugin Library
https://flows.nodered.org/search?type=node

github Repo
https://github.com/node-red

Installation

Running Node-RED locally
https://nodered.org/docs/getting-started/local

Installation on Linux
https://github.com/node-red/linux-installers

Installation on Raspberry Pi
https://nodered.org/docs/getting-started/raspberrypi

Installation on Mac
https://diyprojects.io/installing-using-node-red-macos-windows/

Installation on Windows
https://nodered.org/docs/getting-started/windows

Basics

Creating your first flow
https://nodered.org/docs/tutorials/first-flow

Node-RED: Lecture 4 – A tour of the core nodes
http://noderedguide.com/node-red-lecture-4-a-tour-of-the-core-nodes/

Node Red in 5 minutes
https://www.youtube.com/watch?v=f5o4tIz2Zzc

Steve’s Node-Red Guide
https://stevesnoderedguide.com

Dashboard

node-red-dashboard
https://flows.nodered.org/node/node-red-dashboard
https://github.com/node-red/node-red-dashboard

HowTo: NodeRed – Create a user interface with dashboard nodes (german)
https://nerdiy.de/nodered-mit-dashboard-nodes-eine-benutzeroberflaeche-erstellen/

Remote RED - iOS Dashboard Client
https://apps.apple.com/lk/app/remote-red/id1529777665

Access Node-RED Dashboard from Anywhere using Digital Ocean
https://randomnerdtutorials.com/access-node-red-dashboard-anywhere-digital-ocean/

Tutorials

NodeRED Programming Guide
http://noderedguide.com

What is Node-RED (german)
https://smarthome-training.com/de/was-ist-node-red/

NodeRed-Tutorials bei haus-automatisierung.com
https://haus-automatisierung.com/nodered/2017/11/10/node-red-tutorial-reihe-part-1-installation.html
https://www.youtube.com/watch?v=ktGprvHi5jU

Intro to Node-RED: Part 1 Fundamentals
https://www.youtube.com/watch?v=3AR432bguOY

NodeRED for beginners: 1. Why do you need a NodeRED server?
https://www.youtube.com/watch?v=AGMNEEQWEhQ

NodeRed-Tutorial Part 2: Basics and Dashboard with Weather data | haus-automatisierung.com (german)
https://www.youtube.com/watch?v=_jMyAnPjkLQ

NodeRed-Tutorial Part 3: Sonoff with MQTT | haus-automatisierung.com (german)
https://www.youtube.com/watch?v=vg436GGmvfM

Einstieg in RedMatic - Node Red for the HomeMatic CCU | verdrahtet.info (german)
https://www.youtube.com/watch?v=lMIrLS6JM-o

Awesome List of Useful Node-RED Nodes
https://github.com/TotallyInformation/awesome-to-me/blob/master/node-red-useful-nodes.md

Raspberry Pi

https://www.raspberrypi.org/blog/raspberry-pi-400-the-70-desktop-pc/
https://www.rasppishop.de/Raspberry-Pi-400-PC-UNIT-ONLY-DE

Installation auf Raspberry Pi
https://nodered.org/docs/getting-started/raspberrypi

Install Node-RED on Raspberry Pi (german)
https://smarthome-training.com/de/node-red-auf-raspberry-pi-installation/

Getting started with Node-RED
https://projects.raspberrypi.org/en/projects/getting-started-with-node-red

FileMaker and Node Red

Attention: Requirements for the use of the Data API with Node Red:

1. A valid SSL certificate must be installed from the FileMaker server! The supplied default certificate from Claris is not sufficient!
Cheap SSL certificates are available e.g. at namecheap
https://www.namecheap.com/security/ssl-certificates/comodo/positivessl/

Authentication of the certificate is possible via email. (No entry in a public DNS server is required).

Tip: Define FileMaker Server address as subdomain (fms.mydomain.com). For this, too, a complete DNS server does not have to exist, but the subdomain can also simply be entered in the host file:
https://setapp.com/how-to/edit-mac-hosts-file

2. The FileMaker Data API Plugin must be installed.

Node Red Plugin: FileMaker Data API
https://flows.nodered.org/node/node-red-contrib-filemaker
https://github.com/Luidog/fms-api-client

Tip: A good starting point for experimenting: Installing Node-Red in a Linux VM together with FileMaker Server v19

Installation FM Server Linux
https://the.fmsoup.org/t/installation-of-filemaker-server-in-pictures/1410

If you want to access Node-Red from FileMaker Client, the easiest way to do this is with a REST API endpoint.

Create an HTTP Endpoint
https://cookbook.nodered.org/http/create-an-http-endpoint

The API Endpoint returns a JSON object, which is taken over with the FileMaker Script command "Insert from URL":
https://fmhelp.filemaker.com/help/18/fmp/en/index.html#page/FMP_Help/insert-from-url.html

With the JSONGetElement functions the desired values can be retrieved from the result:
https://fmhelp.filemaker.com/help/18/fmp/en/index.html#page/FMP_Help/jsongetelement.html

More info here:

FileMaker Magazine: Using Node-RED & the FileMaker Data API
https://www.filemakermagazine.com/videos/using-node-red-filemaker-data-api

Presentation: FileMaker of Things APIs and IoT Using Node Red (Lui de la Parra, Seedcode)
https://support.claris.com/servlet/fileField?entityId=ka10H000000g7sr&field=Public_File_1__Body__s
https://www.youtube.com/watch?v=NAxhuWRsZWw

Cloud Hosting

How to Securely Host Node-RED in Cloud (For Free), and Safely Expose it to the Internet over HTTPS
https://hackernoon.com/how-to-securely-host-node-red-in-cloud-for-free-and-safely-expose-it-to-the-internet-over-https-hw5d3220

Access Node-RED Dashboard from Anywhere using Digital Ocean
https://randomnerdtutorials.com/access-node-red-dashboard-anywhere-digital-ocean/

FRED
https://fred.sensetecnic.com

Stackhero for Node-RED
https://www.stackhero.io/en/services/Node-RED

Running on IBM Cloud
https://nodered.org/docs/getting-started/ibmcloud

Projects

Monitor website and web server with Node-Red (german)
https://nachbelichtet.com/website-und-webserver-mit-node-red-ueberwachen/

Monitor Linux Servers with SSH/command line tools and Node-Red
https://funprojects.blog/2020/04/11/monitor-old-linux-servers/

Sqlite and Node-Red
https://funprojects.blog/2019/12/26/sqlite-and-node-red/

Connecting NodeRed with Telegram, simple and traceable
https://www.youtube.com/watch?v=kXvYEzLHzJQ

Controlling Alexa with NodeRed
https://www.youtube.com/watch?v=nTfbNan4jCg

Raspberry Pi Instagram Followers Counter
https://www.hackster.io/giobauermeister/raspberry-pi-instagram-followers-counter-2651ad

c't-Smart-Home - A ready-to-use Node-RED setup for home automation
https://awesomeopensource.com/project/ct-Open-Source/ct-Smart-Home

Control Fritzbox with Node-RED (german)
https://www.heise.de/news/Fritzbox-mit-Node-RED-kontrollieren-4849253.html