Skip to main content
Solved

Can we get access to the OVO energy online account API to download our smart meter usage data?

  • March 9, 2017
  • 214 replies
  • 35550 views

Show first post

214 replies

  • November 7, 2024

Log file lines from last Uri are as follows:

2024-11-06 17:20:52 - Uri: https://smartpaymapi.ovoenergy.com/usage/api/monthly/nnnnnnn?date=2020
2024-11-06 17:20:52 - System.NullReferenceException: Object reference not set to an instance of an object.
   at OvoData.Helpers.SqliteHelper.UpsertMonthly(String fuelType, List`1 items) in C:\Dev\Mike\GitHub\My-Ovo-Data\Helpers\SqliteHelper.cs:line 114
   at OvoData.MainWindow.OnClick_Read(Object sender, RoutedEventArgs e) in C:\Dev\Mike\GitHub\My-Ovo-Data\MainWindow.xaml.cs:line 189
 

Let me know if you need more.

 


  • November 7, 2024

Posted the requested information but apparently it needs to be revewed by the moderators. In case that takes time, the exception line was:

2024-11-06 17:20:52 - System.NullReferenceException: Object reference not set to an instance of an object.
   at OvoData.Helpers.SqliteHelper.UpsertMonthly(String fuelType, List`1 items) in C:\Dev\Mike\GitHub\My-Ovo-Data\Helpers\SqliteHelper.cs:line 114
   at OvoData.MainWindow.OnClick_Read(Object sender, RoutedEventArgs e) in C:\Dev\Mike\GitHub\My-Ovo-Data\MainWindow.xaml.cs:line 189

That was preceded in the log by the Uri line which was https: slash slash smartpaymapi.ovoenergy.com slash usage slash api slash monthly slash accountNo?date=2020

No other lines in the log between those two entries. Let me know if you need more.


MikeWilliams
Newcomer
Forum|alt.badge.img
  • Newcomer
  • November 7, 2024

That is interesting in that the URL ends 2020.

Is that year significant?

Can you PM me the whole log file please?


  • November 7, 2024

The year isn’t significant to me, as far as I can see. The whole log file (4554 lines, 342k) is being sent to you in a PM, but it seems to be taking a while … having clicked “send” the button is just being highlighted continually with three white dots. This is the first time I’ve used PM so I may have done something wrong?

Edit: Just checked my online account. The last bill I can see online is for May-Jun 2020. I have been an OVO customer since 2013. Interestingly, I can see Usage data going back to 2013, but not the bills!


MikeWilliams
Newcomer
Forum|alt.badge.img
  • Newcomer
  • November 12, 2024

With the kind assistance of @HexhamUser I have been able to solve the issue with his data for 2020.

My code could not cope with him having “free” 😁 electricity prior to May.

The data segments were missing, causing my code to error.

This is now fixed and I intend to release this later this week.

/Mike Williams


MikeWilliams
Newcomer
Forum|alt.badge.img
  • Newcomer
  • November 14, 2024

I have just released V1.0.3 of my app to GitHub, this fixes the issue found by @HexhamUser when you have electricity with missing cost data.

Just download the zip file from https://github.com/MikeWilliams-UK/My-Ovo-Data/releases and unzip it’s contents to any folder, then run OvoData.exe

If you like my work, please consider donating at https://www.buymeacoffee.com/mikewilliamsuk

/Mike Williams


Those who just want to dump half-hourly usage for archival purposes (JSON, CSV) might find this script helpful: https://github.com/nickcmaynard/ovo-energy-usage-scripts


MikeWilliams
Newcomer
Forum|alt.badge.img

Those who just want to dump half-hourly usage for archival purposes (JSON, CSV) might find this script helpful: https://github.com/nickcmaynard/ovo-energy-usage-scripts

@nickcmaynard you have exposed your OVO custumer ID to the whole world in your script.


MikeWilliams
Newcomer
Forum|alt.badge.img

Hi All,

I have been informed by ​@HexhamUser that my program is not retreiving any data.

I have investigated this using postman and I can see that the API is working but retriving empty data sets for anything in 2025.

This tallys exactly with the OVO website, so I think we will just have to wait for them to fix the API.

Daily
Monthly

 


MikeWilliams
Newcomer
Forum|alt.badge.img

Just tried to chat with someone at OVO, but the chat bot failed to connect me with a real person.

Maybe it will all stat to work again tomorrow when their system has at least two days daya from 2025 (fingers crossed)


Blastoise186
Super User
Forum|alt.badge.img+8
  • Super User
  • January 2, 2025

Please see https://docs.github.com/en/authentication/keeping-your-account-and-data-secure/removing-sensitive-data-from-a-repository for instructions on how to remove sensitive data from a GitHub repository. I would strongly recommend doing so in this case.


@nickcmaynard you have exposed your OVO custumer ID to the whole world in your script.

Ho hum, thanks folks - should be fixed now!


MikeWilliams
Newcomer
Forum|alt.badge.img

Hi All, ​@HexhamUser 

Just checked on the OVO web site and the page for viewing “Your enery use” is now working (for me).

My app is also working again (for me), please remember to chose “This month & Last month” to ensure that December’s data is retrieved.

/Mike


Emmanuelle_OVO
Community Manager
Forum|alt.badge.img+4
  • Community Manager
  • January 3, 2025

Great news ​@MikeWilliams thanks for the update! 🙂


  • Newcomer
  • July 3, 2025

Has the API stopped working? Haven’t been able to get data for the last couple of days. I am Gas only.

 


Blastoise186
Super User
Forum|alt.badge.img+8
  • Super User
  • July 3, 2025

If the API is completely dead, you wouldn’t be able to see anything in MyOVO either.

Worth remembering however that OVO doesn’t make any promises it’ll work for anything but MyOVO.


MikeWilliams
Newcomer
Forum|alt.badge.img

Hi ​@maxihertz - I have just checked the debug output for my own account and I can see that there are Half Hour records for the 1st July, but not the 2nd July.

June is showing as having all Half Hour records.

I am Electric & Gas customer.


  • Newcomer
  • July 3, 2025

I can’t get the half-hourly usage for 1 July on the official page (doesn’t seem to be called MyOVO anymore). It gives a reasonable looking total, but not the details.

 


Blastoise186
Super User
Forum|alt.badge.img+8
  • Super User
  • July 3, 2025

Usage data for the 2nd July probably isn’t ready yet - it generally starts to become available in the afternoon from around 1pm onwards.


BPLightlog
Super User
Forum|alt.badge.img+9
  • Super User
  • July 3, 2025

The other thing to consider ​@maxihertz is that due to all the additional processing that takes place when prices change (as they did on 1st July), that often delays readings being made available 


  • Newcomer
  • July 3, 2025

hah, just check again and all the data is there for 1 July.


Firedog
Super User
Forum|alt.badge.img+7
  • Super User
  • July 3, 2025

Has the API stopped working? Haven’t been able to get data for the last couple of days. I am Gas only.
 

I wasn’t able to retrieve Hh data for 1 July, neither via the API nor the website, until a few moments ago (09:15 BST on 03 July). Meter index readings for 2 July turned up at about the same time. It looks like there has been a delay in collecting data from meters via DCC since the start of the new quarter, but the API can only return data that has already been retrieved. 

I find it less stressful to collect my Hh data from n3rgy.com, but I still have to wait until 10:00 BST before n3rgy will get them for me.     


MikeWilliams
Newcomer
Forum|alt.badge.img
  • Newcomer
  • September 22, 2025

Hi All,

Just a quick heads up OVO have changed their API.

My program will not work until I have had time to fix it.

 

Sorry about that folks, but when we use an undocumented API which is probably designed to be internal to OVO we are always at the mercy of when they decide to change their API.

 

Thanks ​@HexhamUser for notifying me.

 

Regards

Mike Williams


Firedog
Super User
Forum|alt.badge.img+7
  • Super User
  • October 3, 2025

OVO changes the authorization method for the Smart PAYM API 

  

People may have noticed that utilities like the ones described in this thread aren’t working these days. It looks like there was a fundamental change in the way that authorization works for the API. This sort of stuff sadly goes right over my head, but apparently it’s no longer enough to have the browser cache an access token; it actually has to be sent with each request. Developers out there will hopefully know how to deal with this, so over to ​@MikeWilliams, ​@Tron Burgundy, ​@nickcmaynard, ​@knight, ​@TerryE , ​@g-de and anyone else I’ve omitted, just in case they can be bothered to address this insofar as it affects their various code.

 


Tron Burgundy
Rank 4

@Firedog I just tested it now and yup, Axios error in the console log.

I won’t be able to fix it either as I changed to Fuse on the 30th of September because they had me at 41p a day standing charge for electricity and every other thing cheaper than the fixed deals Ovo offered.  £150 cheaper a year, no direct debit “estimates” and no power move nonsense.

If I find a way of fixing it I’d have a go but I don’t know if I’ll be able to test it.


Feedback