Test

Test

[{"id":"6ed1115c.912ef","type":"mongodb","hostname":"127.0.0.1","port":"27017","db":"test","name":""},{"id":"83fdf63f.7c0208","type":"http in","name":"[post] /cmx","url":"/cmx","method":"post","swaggerDoc":"","x":90,"y":181,"z":"3621d812.c9de28","wires":[["46f0f848.b90f08","21af9334.de506c","f172aa31.0e8d58"]]},{"id":"e55cc9d8.1aa338","type":"mongodb in","mongodb":"6ed1115c.912ef","name":"cmx data","collection":"cmx","operation":"find","x":453,"y":323,"z":"3621d812.c9de28","wires":[["a37b9a5c.5c8468"]]},{"id":"d9d7d480.262828","type":"mongodb out","mongodb":"6ed1115c.912ef","name":"cmx data","collection":"cmx","payonly":true,"upsert":false,"multi":false,"operation":"store","x":535,"y":272,"z":"3621d812.c9de28","wires":[]},{"id":"a37b9a5c.5c8468","type":"http response","name":"cmx response","x":637,"y":322,"z":"3621d812.c9de28","wires":[]},{"id":"1cc8879b.e33778","type":"debug","name":"CMX Data","active":true,"console":"false","complete":"true","x":537,"y":200,"z":"3621d812.c9de28","wires":[]},{"id":"3aea25a6.c515da","type":"http in","name":"[get] /cmx Validator","url":"/cmx","method":"get","swaggerDoc":"","x":115,"y":72,"z":"3621d812.c9de28","wires":[["54771d95.ab88e4","6c9eb49a.93614c"]]},{"id":"54771d95.ab88e4","type":"function","name":"validate-validator","func":"// This node accepts a message with the validator defined in the URL\n// Example: http://yourserver:1880/cmx?validator=8e0846499d9a3f6d23f7868c4d55b9d6325035f5\n// By default, all API requests are accepted (for testing purposes)\n//~~~~~~~~~\nvalidator = msg.payload.validator;\nmsg.payload = validator;\nreturn msg;\n\n\n//Alternatively, set the validator variable to match the Meraki network\n//The URL will not need to include the validator string, for enhanced security\n//~~~~~~~~~\n//validator = \"8e0846499d9a3f6c23f7868c4c25b9d6325035f5\";\n//msg.payload = validator;\n//return msg;","outputs":1,"noerr":0,"x":310,"y":90,"z":"3621d812.c9de28","wires":[["e557075a.1aa8f8","5601778a.a9fe88"]]},{"id":"e557075a.1aa8f8","type":"http response","name":"cmx response","x":598,"y":78,"z":"3621d812.c9de28","wires":[]},{"id":"6c9eb49a.93614c","type":"debug","name":"CMX validator raw","active":false,"console":"false","complete":"payload","x":339,"y":41,"z":"3621d812.c9de28","wires":[]},{"id":"1efcb74f.e10349","type":"http in","name":"[get] /showcmx","url":"/showcmx","method":"get","swaggerDoc":"","x":107,"y":323,"z":"3621d812.c9de28","wires":[["d7d2081f.282df8"]]},{"id":"acf96047.5306a","type":"http in","name":"[get] /showcmxhtml","url":"/showcmxhtml","method":"get","swaggerDoc":"","x":125,"y":461,"z":"3621d812.c9de28","wires":[["b02e2940.4fd1d8"]]},{"id":"a414e870.5beb18","type":"template","name":"Parse Data","field":"payload","format":"handlebars","template":"\n{{#payload}}\n   <h1>data.apMac = {{data.apMac}}</h1>\n   {{#data.observations}}\n    <table border=\"1\" style=\"width:100%\">\n     <tr>\n     <td >{{@index}}</td>\n     <td width=\"300\">clientMac = {{clientMac}}</td>\n     <td width=\"300\">manufacturer = {{manufacturer}}</td>\n     <td width=\"300\">seenTime = {{seenTime}}</td>\n     <td width=\"300\">lat = {{location.lat}}</td>\n     <td width=\"300\">lng = {{location.lng}}</td>\n     <td width=\"300\">unc = {{location.unc}}</td>\n     <td width=\"300\">x = {{x}}</td>\n     <td width=\"300\">y = {{y}}</td>\n     </tr>\n    </table>\n\n    \n   {{/data.observations}}\n   <br>\n{{/payload}}\n\n\n","x":520,"y":461,"z":"3621d812.c9de28","wires":[["282e8c3f.d7d174"]]},{"id":"282e8c3f.d7d174","type":"http response","name":"","x":662,"y":460,"z":"3621d812.c9de28","wires":[]},{"id":"4e878f5.fb1787","type":"mongodb in","mongodb":"6ed1115c.912ef","name":"cmx data","collection":"cmx","operation":"find","x":363.75,"y":457.25,"z":"3621d812.c9de28","wires":[["a414e870.5beb18","fd7224e4.028dd8"]]},{"id":"96bebb9a.694148","type":"comment","name":"CMX in HTML table","info":"CMX in HTML table\n","x":100,"y":418,"z":"3621d812.c9de28","wires":[]},{"id":"bafdd665.450228","type":"comment","name":"CMX core functions","info":"CMX core functions","x":93,"y":29,"z":"3621d812.c9de28","wires":[]},{"id":"b02e2940.4fd1d8","type":"function","name":"limit results","func":"msg.limit = 2;\nmsg.sort = {\"_id\":-1};\nreturn msg;","outputs":1,"noerr":0,"x":276.05765533447266,"y":387.80774688720703,"z":"3621d812.c9de28","wires":[["4e878f5.fb1787"]]},{"id":"fd7224e4.028dd8","type":"function","name":"Extract GPS","func":"var coords = [];\n\nfor (i = 0 ; i < msg.payload.length; i++) {\n     y = msg.payload[i];\n\n     for(j = 0; j < y.data.observations.length; j++) {\n        x = y.data.observations[j];\n        coords.push({\"lat\" : x.location.lat, \"lng\" : x.location.lng});\n    }\n}\n\nmsg.payload = coords;\nreturn msg;\n","outputs":1,"noerr":0,"x":469.423095703125,"y":528.1922912597656,"z":"3621d812.c9de28","wires":[["1d54eed0.e2ab11"]]},{"id":"1d54eed0.e2ab11","type":"debug","name":"","active":false,"console":"true","complete":"payload","x":657.8077392578125,"y":529.4999389648438,"z":"3621d812.c9de28","wires":[]},{"id":"d7d2081f.282df8","type":"function","name":"limit results","func":"msg.limit = 2;\nmsg.sort = {\"_id\":-1};\nreturn msg;","outputs":1,"noerr":0,"x":292,"y":322,"z":"3621d812.c9de28","wires":[["e55cc9d8.1aa338"]]},{"id":"304d4b6e.cfb2b4","type":"comment","name":"CMX in JSON view","info":"","x":91,"y":281,"z":"3621d812.c9de28","wires":[]},{"id":"5601778a.a9fe88","type":"debug","name":"CMX Validator","active":true,"console":"false","complete":"payload","x":599,"y":117,"z":"3621d812.c9de28","wires":[]},{"id":"21af9334.de506c","type":"function","name":"validate-secret","func":"// This node verifies that the secrect configured\n// on the Meraki Dashboard Network, matches.\n//var secret = \"merakilous\"; \nvar secret = \"testing123\";\n\nif(msg.payload.secret == secret){\n    return msg;\n}else{\n    // Secret is invalid\n    \n}\n\n","outputs":1,"noerr":0,"x":303,"y":209,"z":"3621d812.c9de28","wires":[["1cc8879b.e33778","20f2bbcb.df0d44","d9d7d480.262828"]]},{"id":"e8acb38.f17535","type":"comment","name":"Connect DB to function to store data","info":"","x":542,"y":237,"z":"3621d812.c9de28","wires":[]},{"id":"f172aa31.0e8d58","type":"debug","name":"CMX post","active":false,"console":"false","complete":"payload","x":309,"y":144,"z":"3621d812.c9de28","wires":[]},{"id":"20f2bbcb.df0d44","type":"http response","name":"cmx response","x":545,"y":162,"z":"3621d812.c9de28","wires":[]}]
macf0x

Flow Info

created 9 months, 1 week ago

Node Types

Core
  • comment (x4)
  • debug (x5)
  • function (x5)
  • http in (x4)
  • http response (x4)
  • mongodb (x1)
  • mongodb in (x2)
  • mongodb out (x1)
  • template (x1)

Tags

Copy this flow JSON to your clipboard and then import into Node-RED using the Import From > Clipboard (Ctrl-I) menu option