Web Data Import to Cayenne Dashboard or Trigger

Community Help With My Project
#1

So here is what I am trying to do. I want to somehow read a table data element from a website and have that data either populate in my Cayenne dashboard or use it to trigger an event.

Right now I have a Google Sheet that is populated with a lake’s water depth off of a website. I want to somehow trigger an event based on changes to the water depth data item. is there a way to somehow do this using either Google sheets or some other way?

I have a floating boat dock on Norris Lake in TN. Right now I am using a Cayenne dashboard to actuate winches that adjust the cables for fluctuations in lake water level. The lake level is constantly updated and I have that feeding into a Google Sheet - I want to somehow use a trigger or otherwise to automatically trigger an alert and actuate my cable winches for a certain drop or increase in lake level.

Is there a way to do this?

#2

why don’t you directly measure water level and send it to cayenne with a microcontroller and water level sensor?

#3

that’s a fair question. I have not been able to find a sensor that will measure water depth down to 25-30 feet- which is what I am dealing with off the dock. Is there one that will work with Cayenne?

#4

you got to find the sensor which can get connected to supported hardware Cayenne Docs then it will work with cayenne.

#5

My other concern: As the water rises the dock cables are pulled in and the dock “travels” up a sloped bank via wheels on the shore-side of the ramp. The sensor is likely to encounter rocks and ledges that will throw off the reading. Since multiple sites publish and update the lake level daily as a function of feet above sea level - I thought that would be most reliable if I can somehow get Cayenne to recognize it

#6

there will be API where you get the sensor data using python and send it to cayenne using GitHub - myDevicesIoT/Cayenne-MQTT-Python: Python Library for Cayenne MQTT API

#7

Thank you - but is this saying there will be an API or there is already a solution? Sorry but I am not a computer programmer - is there a narrative or description? The GitHub link does not especially help me

#8

You are getting your data from a website? so the process will be:-

Website Data -----> API ------> Get Data (request library) -----> Send Data (Cayenne Python Library) -----> Cayenne.

This all will be done in a single python code. you will need to get the data using the python request library by calling the get method Requests: HTTP for Humans™ — Requests 2.25.1 documentation then parse the required data and send it to cayenne using GitHub - myDevicesIoT/Cayenne-MQTT-Python: Python Library for Cayenne MQTT API

#9

Awesome – this looks like it will provide me the resources I need.

Thank You! – and I will let you know how it works out

image075011.png

image453132.png

image257021.png

image408892.jpg

#10

i also came across this tutorial on google sheet API https://www.analyticsvidhya.com/blog/2020/07/read-and-update-google-spreadsheets-with-python/
so you can use the data from the google sheet directly.