Accessing Raw Data in Cayenne

[matthewedallard]

Hello everyone,
I am using the Raspberry Pi 2 Model with Raspbian 7 Debian installed.
My project is to sense and log the temperature of a motor as well as its power draw. What I am wondering is if there is any way to access the actual raw sensor data that Cayenne gathers? If this is not possible directly through the app is there a secondary app I could use on my Pi to do this? Ideally I would like to be able to also have a comma separated list of this data. Any help is very much appreciated.
Cheers,
Matt

[bestes]

Hi Matt,

Welcome!

You’re not the first to ask for this… short answer, we’re opening up an API so you can get the data, and sooner than later we’re going to allow you to download a CSV of all data gathered. Linking the relevant posts too:

Get sensor values in another app [workaround solution!]

Here is my python code that gets the temperature and sends it to my server : from helium.api import * import time import json import urllib2 # Open chrome on the cayenne's login page start_chrome("https://cayenne.mydevices.com/cayenne/login") time.sleep(2) # Fill form with email and password write("xxxxxxxxxx@xxxxxxxx.xxx", into="email") write("xxxxxxxxxxxxxxxxxxxxxxx", into="password") # Click on the "Log In" button press(TAB) press(ENTER) # DEVICE_CODE can be found in the dashboard's URL…

Ability to export/download data

Is there a way to download/export sensor data? Something simple could be implemented with a trigger that after XX day(s)/week(s) all the raw data from YY sensor is emailed to user as CSV file. This would allow further data analysis by the user instead of simply viewing it through your online graphs where data points are averaged depending on the time scale selected. I’m not sure how long the data resides on your servers and when it is parsed to averages after a given time frame (and therefore …

[matthewedallard]

Thanks for your fast reply.
Cheers,
Matt

[picaxe]

These features looks good.

I am after being able to generating and forward live ‘Generic Variables’ data from weird, one off, variable data within the Pi. I.e. My own py scripts and gadgets from e.g. odd ball sensors, counters and devices make up a number. I would like to be able to pass this number forward ‘Pi >> Cayenne’ as a live Generic Variable. This can be then picked up within Cayenne and treated the same as any other sensor input. I feel this would be ‘most liberating’ and allow me to go off and get on the the front end hardware but put the results on line in the fastest way possible.

Once that is sorted, or at the same time I would like my python programs in the Pi to be able to read back data direct into a py script.

~ Andrew