# Viewing and saving device data

**URL:** <https://community.smartthings.com/t/viewing-and-saving-device-data/162315>\
**Category:** Projects & Stories\
**Created:** [April 27, 2019, 8:19pm UTC](https://community.smartthings.com/t/viewing-and-saving-device-data/162315 "2019-04-27T20:19:52Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Steerpike](https://avatars.discourse-cdn.com/v4/letter/s/f04885/32.png) [@Steerpike](https://community.smartthings.com/u/Steerpike)\
**Post date:** [April 27, 2019, 8:19pm UTC](https://community.smartthings.com/t/viewing-and-saving-device-data/162315/1 "2019-04-27T20:19:52Z")

</div>

I’ve now got a bunch of temperature, humidity, light-level, etc sensors that provide useful information about my home. What is the best way to save this data for further analysis?

The Phone app has the ‘recently’ tab (which amusingly uses a light-gray font on a white background … UI best practices, anyone?!) but this data is essentially view only on the phone. The browser-accessible ‘API’ page ([https://graph.api.smartthings.com](https://graph.api.smartthings.com) ) allows one to select a device (under ‘my devices’), view the current data, and then get a fairly decent history of that data. One has to click the ‘more…’ button over and over and over, but eventually you can get pages of data spanning hundreds of readings. From there, you can copy/paste the data, and then use your best excel parsing skills to get the data into a usable format.

Is there an easier way to achieve this? If I buy ‘action tiles’, will it let me deal with historical data more easily? Is there a limit to how far back the data from the API page is stored? Thanks!

---

<div class="post-metadata">

**Author:** ![philh30](https://avatars.discourse-cdn.com/v4/letter/p/41988e/32.png) [@philh30](https://community.smartthings.com/u/philh30)\
**Post date:** [April 27, 2019, 8:23pm UTC](https://community.smartthings.com/t/viewing-and-saving-device-data/162315/2 "2019-04-27T20:23:57Z")

</div>

> [@ROUNDUP: Data Logging and Charting Solutions](https://community.smartthings.com/t/roundup-data-logging-and-charting-solutions/80108):
>
> There’s loads of data logging and charting solutions, so I thought I’d create an index. Reply with any solutions I’ve missed and I will update this post. [Amazon DynamoDB](https://aws.amazon.com/dynamodb/) [cloud ([free/paid](https://aws.amazon.com/dynamodb/pricing/))]: [Elastic Stack](https://www.elastic.co/) (LogStash+Beats+Elasticsearch+Kibana) [private (free) / cloud ([paid](https://www.elastic.co/cloud/as-a-service/pricing))]: Can’t see a specific thread on the community, but here’s a github link: [Google Sheets](https://sheets.google.com) [cloud (free)]: [GroveStreams](https://www.grovestreams.com/) [cloud ([free/paid](https://www.grovestreams.com/pricing.html))]: [InfluxData TICK Stack](https://www.influxdata.com/) (Telegraf+InfluxDB+Chronograf+Kapacitor ) + [Grafana](http://grafana.org/) [private (free) / cloud (paid)]: [Initial State](https://www.initialstate.com/) [cloud ([free/paid](https://www.initialstate.com/#/pricing))]: [PlotWatt](https://www.plotwatt.com/) [cloud (free/paid)]: Note: PlotWatt is discontinuing its support for 3rd party residential energy monitors on March 31st, 2017 ThingLayer [cloud (free)]: Discontinued?? [T…](https://thingspeak.com/)

---

<div class="post-metadata">

**Author:** ![Philippe\_Portes](https://yyz2.discourse-cdn.com/smartthings/user_avatar/community.smartthings.com/philippe_portes/32/67960_2.png) [@Philippe\_Portes](https://community.smartthings.com/u/Philippe_Portes)\
**Post date:** [April 27, 2019, 10:33pm UTC](https://community.smartthings.com/t/viewing-and-saving-device-data/162315/3 "2019-04-27T22:33:31Z")

</div>

I have a dump of temperature and battery level in a mysql database for more than 2 years now. Works like a charm. You can then pull from that database different views using any chart service. I used [Dashboard.IO](http://Dashboard.IO).  
You can adapt my code to what you want to archive. Advantage is that nothing of you privacy goes on-line if you have a local machine (NAS, PC). [https://github.com/philippeportesppo/Dump\_Temperature\_Battery\_Level\_SmartThings](https://github.com/philippeportesppo/Dump_Temperature_Battery_Level_SmartThings)