After I had installed a MagicMirror into my kitchen cabinet as an infotainment display about 4 years ago, the desire to present my Alexa shopping list there grew.
There was no corresponding module for MM, it remained with this request.
Since I have been working a lot lately with homeautomation/NodeRed/MQTT, and have integrated various things at home, I decided to do this entirely via NodeRed/MQTT and the MMM-MQTT module:
Dependencies / assumption:
NodeRed
Mosquitto as a MQTT-Broker
Amazon account
Alexa
The following pallete in NodeRed:
Node-Red Contrib-Alexa-Remote2-Applestrudel
MQTT Node
For the MagicMirror:
The MMM-MQTT Module
NodeRed Flow:
Version 1.0
NodeRed Flow:
[
{
"id": "5b659ecf053ddcb5",
"type": "tab",
"label": "Alexa Shoppinglist",
"disabled": false,
"info": "",
"env": []
},
{
"id": "cad49a51d4b6511a",
"type": "alexa-remote-list",
"z": "5b659ecf053ddcb5",
"name": "",
"account": "xxxxxxxxxxxx",
"config": {
"option": "getListItems",
"value": {
"list": {
"type": "str",
"value": "YW16bjEuYWNjb3VudC5BRVJLR1NETVE2VFpUQ1lBWVFTV0g3TE9HNU1BLVNIT1BQSU5HX0lURU0="
}
}
},
"x": 320,
"y": 140,
"wires": [
[
"b25d557111e8e60f"
]
]
},
{
"id": "8cb45371b536085f",
"type": "inject",
"z": "5b659ecf053ddcb5",
"name": "",
"props": [
{
"p": "payload"
}
],
"repeat": "60",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "",
"payloadType": "date",
"x": 130,
"y": 140,
"wires": [
[
"cad49a51d4b6511a"
]
]
},
{
"id": "1d408e6875212897",
"type": "mqtt out",
"z": "5b659ecf053ddcb5",
"name": "",
"topic": "Alexa/Torsten/Einkaufsliste",
"qos": "0",
"retain": "",
"respTopic": "",
"contentType": "",
"userProps": "",
"correl": "",
"expiry": "",
"broker": "a4a3cc56ed9dd522",
"x": 1160,
"y": 140,
"wires": []
},
{
"id": "b25d557111e8e60f",
"type": "function",
"z": "5b659ecf053ddcb5",
"name": "Array für Einkaufslisten Items",
"func": "// Create new empty array\nvar ItemArray = []\n\n// Read the first 10 Elements of the Shoppinglist and fill the Array\nif (msg.payload[0].completed === false) {\n ItemArray.push(msg.payload[0].value) \n}\nif (msg.payload[1].completed === false) {\n ItemArray.push(msg.payload[1].value)\n}\nif (msg.payload[2].completed === false) {\n ItemArray.push(msg.payload[2].value)\n}\nif (msg.payload[3].completed === false) {\n ItemArray.push(msg.payload[3].value)\n}\nif (msg.payload[4].completed === false) {\n ItemArray.push(msg.payload[4].value)\n}\nif (msg.payload[5].completed === false) {\n ItemArray.push(msg.payload[5].value)\n}\nif (msg.payload[6].completed === false) {\n ItemArray.push(msg.payload[6].value)\n}\nif (msg.payload[7].completed === false) {\n ItemArray.push(msg.payload[7].value)\n}\nif (msg.payload[8].completed === false) {\n ItemArray.push(msg.payload[8].value)\n}\nif (msg.payload[9].completed === false) {\n ItemArray.push(msg.payload[9].value)\n}\n// capitalized the first Letter\nconst capitalizedArray = ItemArray.map(word => {\n return word.charAt(0).toUpperCase() + word.slice(1);\n})\n\nmsg.payload = capitalizedArray\nreturn msg;",
"outputs": 1,
"timeout": 0,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 580,
"y": 140,
"wires": [
[
"a32bd922c84f7f9d"
]
]
},
{
"id": "a32bd922c84f7f9d",
"type": "template",
"z": "5b659ecf053ddcb5",
"name": "",
"field": "payload",
"fieldType": "msg",
"format": "handlebars",
"syntax": "mustache",
"template": "\n<p align=\"left\">\n {{payload.0}}<br>\n {{payload.1}}<br>\n {{payload.2}}<br>\n {{payload.3}}<br>\n {{payload.4}}<br>\n {{payload.5}}<br>\n {{payload.6}}<br>\n {{payload.7}}<br>\n {{payload.8}}<br>\n {{payload.9}}<br>\n </P>\n\n\n",
"output": "str",
"x": 840,
"y": 140,
"wires": [
[
"1d408e6875212897",
"59efa1a703a3da3d"
]
]
},
{
"id": "59efa1a703a3da3d",
"type": "debug",
"z": "5b659ecf053ddcb5",
"name": "debug 13",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "false",
"statusVal": "",
"statusType": "auto",
"x": 620,
"y": 240,
"wires": []
},
{
"id": "b3eb788434b61b34",
"type": "alexa-remote-account",
"name": "Alexa Torsten",
"authMethod": "proxy",
"proxyOwnIp": "192.168.2.240",
"proxyPort": "3456",
"cookieFile": "/home/pi/alex-cookie-torsten.txt",
"refreshInterval": "3",
"alexaServiceHost": "layla.amazon.de",
"pushDispatchHost": "",
"amazonPage": "amazon.de",
"acceptLanguage": "de-DE",
"onKeywordInLanguage": "an",
"userAgent": "",
"usePushConnection": "on",
"autoInit": "on",
"autoQueryActivityOnTrigger": "off"
},
{
"id": "a4a3cc56ed9dd522",
"type": "mqtt-broker",
"name": "MQTT-Server",
"broker": "192.168.2.2",
"port": "1883",
"clientid": "",
"autoConnect": true,
"usetls": false,
"protocolVersion": "4",
"keepalive": "60",
"cleansession": true,
"autoUnsubscribe": true,
"birthTopic": "",
"birthQos": "0",
"birthRetain": "false",
"birthPayload": "",
"birthMsg": {},
"closeTopic": "",
"closeQos": "0",
"closeRetain": "false",
"closePayload": "",
"closeMsg": {},
"willTopic": "",
"willQos": "0",
"willRetain": "false",
"willPayload": "",
"willMsg": {},
"userProps": "",
"sessionExpiry": ""
}
]
node-red-contrib-alexa-remote2-applestrudel:
The establishment of the Amazon account is a bit tricky, so here a small instructions as I have successfully made:
Install the node-red-contrib-alexa-remote2-applestrudel module from the Repository in NodeRed
Select the node Alexa List:
Create a new Alexa connection:
At the back of the plus symbol:
Name: e.g. Alexa1
Auth method: proxy
This IP: Address of the machine on the NodeRed runs e.g. localhost or 192.168.x.x
Port: 3456
If you want to integrate several Alexa instances, please different ports per instance, since all instances have to be authenticated independently and have to run on different ports.
Filepath: Path and file name of the cookies:
e.g. /home/pi/alexa_cookie1.txt
With several instances, a different cookie path can be created
e.g. /home/pi/alexa_cookie2.txt
The file must be specified, it is created automatically and filled with content.
Set the settings for Amazon as from the list here. I took over the rest of the settings.
Then add on the top and click on Deploy in NodeRed.
Now open the browser on the machine where NodeRed is running and enter the browser line:
http://localhost:3456
Important: The call must take place on the machine from NodeRed and not via the network on another computer, otherwise the Auth Cookie cannot be written.
With several Alexa instances, it should be done exactly like this, since each instance requires its own auth cookie. Think of the changed port numbers at several authorities.
Now you should get to an Amazon side to authenticate yourself.
I did this with my cell phone number, you get an SMS with a security code that you enter.
Now the message should appear in the browser window:
Amazon Alexa Cookie Successfully Retrieved. You can close the browser. "
If a file with the name was created under the path for the cookie, it should have worked.
In the Node Alexa List you should now
select your Alexa account and under Select: “Get-List-Items” and then select the shopping list underneath.
Magic Mirror Config for MMM-MQTT:
clone Git repository in the module directory and install
Config.js:
{
module: 'MMM-MQTT',
position: 'top_left',
header: 'MQTT',
config: {
logging: false,
useWildcards: true,
bigMode: false, // Set to true to display big numbers with label above
mqttServers: [
{
address: '192.168.2.2', // Server address or IP address of the MQTT Broker
port: '1883', // Port number if other than default
user: '*******', // Leave out for no user
password: '******', // Leave out for no password
subscriptions: [
{
topic: 'Alexa/Torsten/Einkaufsliste', // Topic to look for
label: 'Einkaufsliste', // Displayed in front of value
sortOrder: 10, // Can be used to sort entries in the same table
},
],
},
],
},
},
It takes a while for the entries to appear, depending on the interval as it is set in NodeRed. For testing I set 5sek, 1min in normal operation.
The first 10 entries of the shopping list, which are not yet ticked off, are shown.
If you need more than 10 items, the functional node and the template Node must be expanded.
Consider: When displaying on the MM, the space for the number of objects in design is already taken into account, even if the list is not completely filled.
Hope i can help anybody who have the same wish…
Greetings Torsten
