"Export to csv" feature for usage data of the online account

As a workaround. 

If you have already signed up to the Bright app, they have a website where you can download the data to a csv file. Same login. 

http://www.smarttariffsmartcomparison.org/home

To convert the date stamp field use the following formula and format the cell as appropriate. 

=((A2/1000)/86400)+DATE(1970,1,1)

@ajr @Emmanuelle_OVO 

there is a similar idea already open, perhaps combine and take the best bits from both?

Most of the data visualized on the website are available as JSON. If you can work out how to use these data in Excel, say, they’re all at your fingertips, e.g.:

Meter readings for the past 400 days: https://smartpaymapi.ovoenergy.com/rlc/rac-public-api/api/v5/supplypoints/electricity/{MPAN}/meters/{MSN}/readings
where {MPAN} and {MSN} are your specific MPAN and meter serial number. This is the basis for almost all the rest.

Direct Debit suggestions: https://smartpaymapi.ovoenergy.com/pace/recommended-dds/v1/{account}/projected-costs?limitNextYear=true

where {account} is your OVO account number, e.g. 3123456

There are plenty more data available.

PS: You may come across authentication faults. Just make sure you’re signed into your My Ovo account in the same browser session before trying to access the smartpaymapi pages. 

This is the same crossed wire as on the “Power Move” thread. That request is about separating “power export” data (e.g. solar panel) from “usage” data. I am just wanting a “file export”. Different uses of the word “export”, so they are quite different requests/ideas, actually!

They sound very similar to me actually! 

There’s been a delay to getting this idea, sorry about that, @ajr!

We’ll convert this into a ‘Open for votes’ idea now, which will ping it across to the online account team to come back to us on. 

In the meantime, @Firedog can you explain to us simpler folk, if this is a public API? People have been asking for such a thing for years…

From the glowmarkt.com website if you already have the free Bright app. 

[Not sure how I missed this - it was Jeff’s post just now that brought it to my attention.]

I haven’t found out how to automate this yet, but since the data are available all the time anyway, it’s fairly simple. Here’s how I just downloaded my meter readings for the past 400 days (the ‘13 months’ worth’ that the regulations require):

1. Open a browser tab (I use Edge; it should work in others, too), visit account.ovoenergy.com and sign in.
2. Open another tab and go to
   https://smartpaymapi.ovoenergy.com/orex/api/meter-readings/3198692
   putting your own account number at the end instead of mine.
   This produces for me a wall of JSON data. 
3. Copy the whole page (in Windows, Ctrl-A C to select All and Copy it)
4. Open yet another tab and go to
   JSON To CSV Converter (convertcsv.com).
   It’s a very cluttered page, but the steps are fairly well labelled and it works well. 
5. At Step 1, paste into the box. The defaults at Step 2 worked fine for me.
6. At Step 3, click Convert JSON to CSV. 
   The box below should fill up with data.
7. Scroll down a bit to see Save your result. Type a new file name if you wish, then Download result.
   QED

There’s quite a bit of superfluous data - the MSN on each row, for example - but that’s simple enough to remove in a spreadsheet. You’ll see that the data are sorted new>old.
I don’t have any gas readings, but I expect them to appear below those for electricity. 

There is another API that looks as if it exposes either one or the other:
https://smartpaymapi.ovoenergy.com/rlc/rac-public-api/api/v5/supplypoints/electricity/1100001493019/meters/16P0907174/readings 

You’d have to play with this URL to get the data you want: electricity|gas, MPXN and MSN (the ones I’m showing are bogus, BTW).

It would be good to hear if these work for you, and whether one of the URLs is better than the other in your view.
 

@Jeffus From the glowmarkt.com website if you already have the free Bright app. 

And so it does! The consumption figures for each time period in nice CSV. Looks ideal.

Couple of questions in case anyone knows here:

• my data (downloaded or in the Bright app) only seems to start when I registered for Bright. The SmartMeter was installed years ago - any idea if I can get historical data? Other apps seem to manage it (but no download!).
• My Electric & Gas meters are listed - can my new Electric Export MPAN be added? That would be most useful.