Solved

Can we get access to the live usage API?



Show first post

204 replies

Userlevel 1

Just make an official API already. Sorry to get short but people hacking their way to relevant data shows there is a need for it and you’re an energy company, I doubt you’re getting rich cos of your apps... 

https://segment.com/blog/why-we-re-transitioning-to-api-first/

Userlevel 7

Update: I’m still looking into this, @TerryE  - what we can offer, what we can’t and why. It would be good for everyone interested to get some clarity. Leave this with me!

Userlevel 3

I’ve just spent another 4 fours re-engineering the Smart Meter API, and updated my python automatic script.

Anyone that is interested can use this python script; just update the user name and password.  This queries against the new API and unlike the previous version which output to a MySQL schema, this simply produces a CSV so users can also paste the O/P into Excel, Calc or whatever.  I run this as a cmd from NodeRED and parse the response in a NodeRED function.  Enjoy.  :relaxed:

@Eva_OVO this is unlicensed Open Source and my original work.

Userlevel 6

We’ll take that away, @TerryE, and get a response from our dev team. We’ll be in touch when we have more info! :)

Userlevel 3

Further to @ErTnEc's git contribution, I have updated this to do the V2 API for historic consumption. I run the following script daily to download the previous day's half-hourly consumption into the MySQL DB that underpins my NodeRED installation: load_readings.py.
 

 

The new online interface has broken this unofficialt API :(  @Tim_OVO , any traction with the dev team.   Under the old scheme, the cookies were generated server-side, so you could simply script the logon, plus the API request. Now some of the session cookies are generated in obfuscated JS code client-side.  I can log on with the browser and capture these session cookies to part automate this, but this is a total PITA. 

Any chance of opening a dialogue with one of the dev team?  There is no reason why OVO could publish a Python script to make this API easily accessible to advanced users.

+1 for the API trial please.

Userlevel 1
Version one of the python library for the Hildebrand API. May well be a bit sketchy.

https://github.com/ghostseven/Hildebrand-Glow-Python-Library
Great, keep us updated on the python code please.
Userlevel 1
Think its 0330 303 5063
OK, will give them a call, don't really want to purchase another Zigbee hub and have two running if I can get away with one. Thanks for the info.

Do you still have their number please ?
Userlevel 1
Hi jdenver, I am not sure, I can only comment on the Hildebrand one, I purchased it from them and they have an agreement with OVO to be able to white list the devices on the HAN network. They did this from their end and the device connected automatically.

However prior to this I did talk to a rep over the phone at OVO and they were prepared to unlock the HAN to allow me to pair. I did not need to in the end but they were able to, they did ask what device I had so its worth a call. Dont use twitter / social media as via that method I was told it was not possible due to 'security' reasons.
Interesting 'blakedrayson' I have a ConBee II usb Zigbee stick, can't that be used?
Userlevel 1
You can work around this now, I have just done it. You can buy and pair a third party HAN very easily. In fact the Hildebrand Glow HAN can be paired by them without you having to ask OVO to unlock your smart meters.

There is access to an app and an API for getting real time data and historical data. The API is ok (it falls down in places but can be worked around). I am in the process of writing a Python class interface with the API that sorts out some of the oddness.

Hildebrand as a company appear to be quite responsive and helpful and the setup was a doddle.

Will post back here when I have the Python code up on GitHub.

**UPDATE**
Version one of the python library for the Hildebrand API. May well be a bit sketchy.

https://github.com/ghostseven/Hildebrand-Glow-Python-Library
Count me in! I’d love to get access to the API to build a component for HomeAssistant.
Me too, I'm looking for Home Assistant integration. Come on OVO....
Userlevel 6
As soon as we hear more we'll let you know, @technogeoff, @resoai! ☺️
Count me in! I’d love to get access to the API to build a component for HomeAssistant.
Count me in also for any trials of a csv/xls download utility for usage and payment data.
Userlevel 6
No movement yet I'm afraid, @r3m0dul8
Any chance we've moved on and now have API access or we still waiting?

Thanks
Userlevel 5
Hi @CloudCircus I've moved you're comment over to this topic, as you should be able to get a bit more info here!

Cheers,
Ed
Hi, please could you add my location to the API, for a geolocation based energy consumption use case.

Ta.

John
Userlevel 6
Hi @AlanN51 - I've moved your post over here where you can find more information about this!
I swapped from OVO to E-On and then back again. When I was with E-ON they installed a Liberty Smart Meter and everything worked no problems even when swapping back to OVO. Recently though the real time usage indicator has stopped working, why is this??? I still get accurate bills so the meter is obviously working but no display which is really annoying when you have solar panels and the meter is monitoring both usage and export.
Hope this feature has not been disabled!!
Userlevel 6
Hi @Ajk - I've moved your post here where you can find more information.
Userlevel 1
Hey Tim, I am the creator of MyZoe.UK and an EV Driver I'de love this information to combine with my EV Tracking.

I'll PM you in the hopes of too being added to this list.

Reply