API to pull data

Emporia Energy Community Product Ideas API to pull data

Viewing 28 reply threads
  • Author
    Posts
    • #5722 Report Abuse
      jh26
      Member

      I want to automate a daily pull of my data so that I can run some automatic analysis. Would like a RESTful API instead of the just the manually activated CSV email.

    • #5731 Report Abuse
      DrGuns
      Member

      Curious what analysis you are running. I’ve been trying to figure out how I could go about pulling the data for a couple of my expansion module channels Heat & A/C(need both since I have a heat pump system) aggregate and pull down local temperature data from something like OpenWeatherMap.org and plot the heating/cooling power usage relative to outside temp and what I know to be my inside temp(Plotting the differential essentially). Then I could compare what kind of effect changing the temperature setpoint of the thermostat gives me. Or what my before and after looks like on Insulating and air sealing rooms in my house(to see if I’m earning that money back). I’ve never messed with pulling down data through API’s. Hopefully one of these days I can get the free time and can learn how.

      • #6157 Report Abuse
        Sfstowers
        Member

        I’m working on a way to download “degree-days” and try to correlate with energy usage. The industry seems to use this measure, my electric bill has the degree-days for the month on the bill. It looks like about 2/3 of our energy use is for the HVAC, so getting a better handle on this makes lots of sense.

    • #5735 Report Abuse
      Jim @Emporia
      Emporia Staff

      @jh26, we’ve had a few requests for providing APIs to our customers. This is in our product backlog. We’ll keep you posted. Thanks for your suggestion!

      • #5975 Report Abuse
        jh26
        Member

        Jim, you probably have a technically talented user base that would create all sorts of interesting integrations, automation, and analysis tools if they had an API to work with. Those in turn would help sell more Vues.

    • #5762 Report Abuse
      akifbayram
      Member

      Would love to be able to integrate this into Home Assistant to trigger certain actions based on power usage (washer/dryer finished, abnormal power usage, etc..)

    • #5795 Report Abuse
      miguelr
      Member

      I would love to be able to import the data and use it on my own grafana dashboards. Something like InfluxDB would be amazing, or even some live raw data output from the device that I can access from a web browser (think ADS-B-like)

    • #5830 Report Abuse
      eviloreo
      Member

      I would really like to see an API as well! Might also make getting a web interface easier if it uses the API 😀

      • This reply was modified 7 months, 1 week ago by eviloreo. Reason: Edited after seeing the other request I had; WebUI
    • #5893 Report Abuse
      saltcreep
      Member

      +1 API for HA integration

    • #5895 Report Abuse
      sean_8395
      Member

      I’ll upvote this as a feature I’d like to see. If this was completed it could feed the other highly requested item of a web-based view.

    • #5950 Report Abuse
      magillus
      Member

      I would love to see API access with live and history – almost same data that mobile App does.

       

    • #5951 Report Abuse
      jc523
      Member

      Here’s another vote for an API.

      I’m looking to integrate into home assistant.

    • #5954 Report Abuse
      jbrukardt
      Member

      Just installed my vue yesterday, fantastic hardware and setup for the price.   Even the most basic of APIs would be extremely helpful.   Getting the data into influxDB and then onwards to homeassistant or grafana or numerous other things would allow for power alerts, better analytics, better cost savings calculations, etc.

       

      A lot of this exists for iotawatt already due to its open nature, but the vue hardware is cheaper, and the system overall is more streamlined in my opinion

    • #5964 Report Abuse
      charlie
      Member

      Same here. It would be great to integrate at least basic readings (including solar readings) with Hubitat and HA.

    • #5974 Report Abuse
      jh26
      Member

      @drguns, if I had an API or even just the ability to pull the CSV file automatically instead of manually triggered, I would create a daily usage report emailed with usage and charts for each channel.  This would give me a daily health report on the well, water heater, pool, fridge, and solar system.

      If I could do this, I would also buy a second Vue for my other house.

    • #6055 Report Abuse
      Maddyn
      Member

      +1 for the API. looking at integrating with OpenHAB so I can have all my info in one location. Just any sort of access to the raw data would be better than nothing, then you could either parse, import, log or do whatever you want with it.

    • #6068 Report Abuse
      almarcano
      Member

      I would like to say I will be very happy with an API to integrate with Home Assistant, thanks

    • #6075 Report Abuse
      Marty @Emporia
      Emporia Staff

      Hello Everyone, thanks for all your feedback in regard to an API for our Emporia Vue. As I’m sure many of you are already aware, we are a small team, with limited resources. An open API is a feature that is on our roadmap, but right now we don’t have a specific release date. We appreciate your feedback and hope you understand that we’re working very hard to prioritize the many enhancements that have been requested.

    • #6079 Report Abuse
      jc523
      Member

      thanks for the update!

      MQTT would be a great start.  that would allow me to integrate into home assistant.

       

    • #6098 Report Abuse
      helgew
      Member

      I am also very interested in the option to use my own MQTT server! In the meantime and in the absence of an official API, this project might be of interest to some!

    • #6107 Report Abuse
      dekes1
      Member

      Yes, please consider adding extensibility to the system via APIs!

      Maybe as an even easier and quicker option for your development team would be to open up access to the raw data on your cloud server so we can build our own interfaces (like a local node that polls the cloud server data) so we can build integrations into SmartThings/Home Assistant/Hubitat.

    • #6109 Report Abuse
      Marty @Emporia
      Emporia Staff

      @dekes1 I’ll pass this recommendation on to our developers.   Thanks so much for the idea and feedback.

    • #6110 Report Abuse
      jh26
      Member

      Any sort of access to the raw data will do. It’s clear you have quite a number of technically talented customers. Open it up and we’ll do the work for you.

    • #6113 Report Abuse
      Sfstowers
      Member

      I am new to Emporia, but I’ve been deeply involved in home automation for years.  I am overall very happy with the device but find data analysis very limited.  We have 400 amp service, so I bought 2 devices, one for each incoming main line pair.  The current app does not allow me to combine these 2 as a total usage, so it greatly limits my analysis.  I am writing my own program to accomplish this.  Direct access to data with an API call would be a huge step forward.  My experience has shown that HVAC usage is the prime determinate of our electricity consumption.  Without having concurrent temperature and humidity values, it’s impossible to critically assess and draw meaningful conclusions on our efforts at conservation.  I’m going to build an API interrogation routine in my program to the free api.weather.gov service to retrieve this data and mesh it with my electricity usage.  This would be a fairly simple service that you could build into your app that would greatly increase it’s impact.  Thanks!

    • #6116 Report Abuse
      Marty @Emporia
      Emporia Staff

      Welcome to the forum @sfstowers!  Thank you for your feedback on the availability of data through an API as well as the need to combine multiple Vue units.  As you can see from previous posts and our latest email update these are on our development roadmap.    We are working as fast as we can and will get these enhancements out as soon as possible.

    • #6117 Report Abuse
      helgew
      Member

      I posted a link to my little project above, but I wanted to expand a little on what you can do with my Emporiá Vue Data Downloader: Once installed , the downloader will continuously pull data for all your devices at a customizable frequency and resolution just like the app would. It can also download historical data with the same limitation as the CSV download, obviously. The data can be saved directly to an Influx database for use by your home assistant tools or it can be output in JSON format to a file or to a pipe for your own processing, for example publishing to your own MQTT server.

      Right now, the downloader is run from the command line but works on all platforms. I can provide easier ways to configure and run the tool if there is enough interest. I am also open to suggestions for other data formats to output.


      @marty-emporia
      : I had been emailing about this with Ted and Franz, but have not received a reply as to whether you all are OK with making this project more publicly available. Please let me know.

      • #6136 Report Abuse
        dekes1
        Member

        @helgew, very interested in the work you’ve done. Would/could you create a How-To to explain how to run the command tool from Windows?

      • #6141 Report Abuse
        helgew
        Member

        @dekes1: if you have Java installed on your PC, you should be able to just create a file with all the properties configured, name it ‘config.properties’ and place it in the same folder as the emporia-download jar file. Double-clicking the file will start a background process that downloads your Vue data and either saves them to a JSON file (set the property ‘raw’ to the filename) or puts them into an Influx database (this is probably the best way).

        I will work on creating a real Windows executable with a simple GUI that allows for the configuration of the necessary parameters.

        • This reply was modified 3 months, 3 weeks ago by helgew.
        • This reply was modified 3 months, 3 weeks ago by helgew.
    • #6131 Report Abuse
      zerog2k
      Member

      another +1 for real options on direct access to our data:

      1. also send the data to mqtt server (from local device preferred)

      2. also send the data to influxdb server (from local device preferred)

      3. pollable cloud api (less desirable for me, but still acceptable if it’s high-enough resolution, e.g. 5-10s)

      Overall, I would think giving users option to additional have the device report to local mqtt and/or influxdb could be implemented comparatively quickly and easily, and probably cover 90% of the “home automation” power-users like myself and several others here. (Perhaps the trickiest part could be how to pass  configuration [securely] to device; I’m hand-waving a tad, but seems like much easier than the littany of concerns with architecture, cost, reliability, security, etc around exposing and maintaining a public-facing user api.)

       

      • This reply was modified 3 months, 4 weeks ago by zerog2k.
    • #6144 Report Abuse
      gercodries
      Member

      An API would be great, I won’t buy any products where I don’t have access to my own data in a convenient and automated fashion. I made that mistake with Ring and Nest and won’t make it again, no matter how “convenient” the product may appear to be. Separately from that, I really just want the hardware. No cloud services of any kind.

      If I can disable the cloud integration, apps, etc. and just send the raw data to my MQTT server, I’m a happy camper: instant buy.

    • #6213 Report Abuse
      MP-Ranger
      Member

      IFTTT would be ideal for this as it is possible to integrate different websites and collate the results onto a single spreadsheet like Google Docs.

    • #6269 Report Abuse
      hsteinhauer
      Member

      I just purchased my unit. I am encouraged that there is work being done to pull the data to a local system.

      I look forward to being involved with this project.

    • #6281 Report Abuse
      smitters1501
      Member

      Hey guys, if you still waiting for an API, look at this open source project  to get the data of emporia vue…

      https://pypi.org/project/pyemvue/

Viewing 28 reply threads
  • You must be logged in to reply to this topic.