Due to high demand expect some shipping delays at this time, orders may not ship for 3-4 business days. On MLK Day no orders will be shipped.
0

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.
Please be positive and constructive with your questions and comments.

Extracting On Off Data Points

by Buzzie8 on Tue Nov 30, 2021 10:26 am

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.

Buzzie8
 
Posts: 1
Joined: Tue Nov 30, 2021 9:19 am

Re: Extracting On Off Data Points

by mikeysklar on Thu Dec 02, 2021 2:16 pm

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

mikeysklar
 
Posts: 6536
Joined: Mon Aug 01, 2016 8:10 pm

Please be positive and constructive with your questions and comments.