Extracting On Off Data Points

Moderators: adafruit_support_bill, adafruit

Forum rules
If you're posting code, please make sure your code does not include your Adafruit IO Active Key or WiFi network credentials.
Locked
User avatar
Buzzie8
 
Posts: 1
Joined: Tue Nov 30, 2021 9:19 am

Extracting On Off Data Points

Post by Buzzie8 »

Hi all, I want to be able to extract on and off data from a dashboard I created on Adafruit IO. My sensor senses a vibration on and off but I need to extract the on-off times to create a timestamp and duration database that I can use for some other analytics that I am working on. Essentially, I need to be able to take on off data points and move them into a spreadsheet/database for now. Any similar projects to review that do this? Any guidance is greatly appreciated.

User avatar
mikeysklar
 
Posts: 14165
Joined: Mon Aug 01, 2016 8:10 pm

Re: Extracting On Off Data Points

Post by mikeysklar »

It seems like this should be doable using "Get Feed Data" we supply some examples in the documentation using curl to pull down the data in formats you could import to a spreadsheet.

https://io.adafruit.com/api/docs/#get-feed-data

A more elaborate setup to lookup for automatic logging to a spreadsheet of on/off durations in the future would be the time tracking cube.

https://learn.adafruit.com/time-tracking-cube

Locked
Forum rules
If you're posting code, please make sure your code does not include your Adafruit IO Active Key or WiFi network credentials.

Return to “Internet of Things: Adafruit IO and Wippersnapper”