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

If you have previously downloaded the Bright app. 

https://play.google.com/store/apps/details?id=uk.co.hildebrand.brightionic

https://itunes.apple.com/us/app/bright/id1369989022?ls=1&mt=8

Then you can use the same login details on their beta website to download a csv as a workaround. 

http://www.smarttariffsmartcomparison.org/login

It looks like there’s a semi-manual kludge to shift the usage figures by an hour at the start and end of BST. This is only for presentation, though; there are still 48 half-hourly readings for each day as the consumption figures show. Here are my figures for 30 October 2022 as displayed online:
  

So, only 46 readings usage figures displayed, starting at 01:00 GMT. It all comes out in the wash, of course, because the readings sequence is unbroken. Just for comparison, here are the data underlying the displayed figures (for the first 7.5 hours):
 

[Extracted from https://smartpaymapi.ovoenergy.com/usage/api/half-hourly/3198737?date=2022-10-30. To get your own JSON data, substitute your OVO account no. for 3198737 in the URL, and open the page in the same browser session as one where you’re signed in at account.ovoenergy.com so the page can find your access token.] 

@Firedog is this an OVO public API? 

https://smartpaymapi.ovoenergy.com/usage/api/half-hourly/*accountnumber*?date=2022-10-30

Sure. That’s where the data come from to populate the various bits of the account site. Here are a few more sources that work for me:

https://smartpaymapi.ovoenergy.com/usage/api/monthly/{account}?date=2022

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

 https://smartpaymapi.ovoenergy.com/rlc/rac-public-api/api/v5/supplypoints/electricity/{MPAN}/meters/{MSN}/readings?from=2016-09-09

This isn’t real-time; I think the newest data are from the last daily refresh, usually shortly after 01:00 each day. So today’s data won’t ever be available.

[What I’d really like is for an Excel guru to tell me how to include the authentication refresh-token into a query so I could push the JSON data directly into a worksheet.]  

You need to go through the login and cache the cookies to get access to the smart meter API.  I’ve got this all coded in Node-RED Javascript.  I dump data into a MySQL D/B.  Here are the URIs that I use:

https://${MYOVO}/login
https://${MYOVO}/api/v2/auth/login
https://${PAYMAPI}/first-login/api/bootstrap/v2/
https://${PAYMAPI}/orex/api/plans/${msg.account}
https://${PAYMAPI}/rlc/rac-public-api/api/v5/supplypoints/electricity/${msg.mpxn}/meters/${msg.msn}/readings?from=${context.get('dailyStart')}
https://${PAYMAPI}/usage/api/half-hourly/${m.account}?date=${m.start}

Except for the 1st login, these all return a JSON payload that is easy to walk in Javascript.   I use the plans request to get the MSN and MPXN fields as well as current peak, off-peak and standing charges. The readings request gives me daily peak and off-peak usage which can be used to calculate charges.  Looping around the half-hourly request give the daily breakdown.

The API is the same for gas and electricity, though I have an electric-only low energy house so only download electrical data.  

Incidentally we are currently running at 80% off-peak use.

Thanks to you all for taking the time to explain this to me….sadly it’s not a language I’m familiar so it’ll take a few days to work it all out….I’ll persevere though. Thanks again.

@Tim_OVO @g-de Is there a way to parse the balance from the API? I have not seen that in the documentation and I failed by just playing around with random URLs that could potentially show it in my Python script.  

Are you just wanting the “Today’s balance” section from the home page?

Using the network tab of browser dev tools is the simplest way to reverse engineer the API.

Best I can see is that it uses a POST request to:

https://smartpaymapi.ovoenergy.com/bast/api/graphql

With the following body:

{
    "query": "\nfragment FuelFields on BillingFuel {\n  consumption {\n    rates {\n      rate {\n        pence\n      }\n      cost {\n        pounds\n      }\n      kwh\n      openingRead\n      openingReadType\n      intermediateReads {\n        date\n        read\n        readType\n      }\n      closingRead\n      closingReadType\n      startDate\n      endDate\n      friendlyLabel\n    }\n  }\n  standing {\n    netCharge {\n      pounds\n    }\n    rates {\n      rate {\n        pence\n      }\n      startDate\n      endDate\n      days\n    }\n  }\n}\n\nfragment PeriodFields on SelectedPeriod {\n  next\n  previous\n  data {\n    electricity {\n      ...FuelFields\n    }\n    gas {\n      ...FuelFields\n    }\n    upgrades {\n      description\n      grossCharge {\n        pounds\n      }\n      initialGrossCharge {\n        pounds\n      }\n      startDate\n      endDate\n      taxRate\n    }\n    transactions {\n      description\n      netCredit {\n        pounds\n      }\n      taxRate\n    }\n    payments {\n      date\n      description\n      credit {\n        pounds\n      }\n    }\n    start\n    openingBalance {\n      pounds\n    }\n    end\n    closingBalance {\n      pounds\n    }\n    totalCharge {\n      grossCharge {\n        pounds\n      }\n      netCharge {\n        pounds\n      }\n      vatCharge {\n        pounds\n      }\n    }\n    energyCharge {\n      pounds\n    }\n    isStatementAvailable\n  }\n}\n\nquery Period($id: String!, $index: Int!) {\n  billingSummary(id: $id) {\n    lastUpdated\n    billablePeriod(periodIndex: $index) {\n      ...PeriodFields\n    }\n  }\n}\nquery LatestPeriod($id: String!) {\n  billingSummary(id: $id) {\n    lastUpdated\n    latestPeriod {\n      ...PeriodFields\n    }\n  }\n}",
    "operationName": "LatestPeriod",
    "variables": {
        "id": "<account-number>"
    }
}

Remember to insert your account number. The balance should then be at data > billingSummary > latestPeriod > data > closingBalance > pounds. A negative number looks to indicate in debit.

It should be possible to tune the query in the body to only pull back the desired information, but I’m not familiar with graphql.

https://smartpaymapi.ovoenergy.com/bast/api/graphql

That’s great. I ll try that

Just an additional question. I have tried that:

headers = {"Content-Type": "application/graphql"}

body = {
    "query": "\nfragment FuelFields on BillingFuel {\n  consumption {\n    rates {\n      rate {\n        pence\n      }\n      cost {\n        pounds\n      }\n      kwh\n      openingRead\n      openingReadType\n      intermediateReads {\n        date\n        read\n        readType\n      }\n      closingRead\n      closingReadType\n      startDate\n      endDate\n      friendlyLabel\n    }\n  }\n  standing {\n    netCharge {\n      pounds\n    }\n    rates {\n      rate {\n        pence\n      }\n      startDate\n      endDate\n      days\n    }\n  }\n}\n\nfragment PeriodFields on SelectedPeriod {\n  next\n  previous\n  data {\n    electricity {\n      ...FuelFields\n    }\n    gas {\n      ...FuelFields\n    }\n    upgrades {\n      description\n      grossCharge {\n        pounds\n      }\n      initialGrossCharge {\n        pounds\n      }\n      startDate\n      endDate\n      taxRate\n    }\n    transactions {\n      description\n      netCredit {\n        pounds\n      }\n      taxRate\n    }\n    payments {\n      date\n      description\n      credit {\n        pounds\n      }\n    }\n    start\n    openingBalance {\n      pounds\n    }\n    end\n    closingBalance {\n      pounds\n    }\n    totalCharge {\n      grossCharge {\n        pounds\n      }\n      netCharge {\n        pounds\n      }\n      vatCharge {\n        pounds\n      }\n    }\n    energyCharge {\n      pounds\n    }\n    isStatementAvailable\n  }\n}\n\nquery Period($id: String!, $index: Int!) {\n  billingSummary(id: $id) {\n    lastUpdated\n    billablePeriod(periodIndex: $index) {\n      ...PeriodFields\n    }\n  }\n}\nquery LatestPeriod($id: String!) {\n  billingSummary(id: $id) {\n    lastUpdated\n    latestPeriod {\n      ...PeriodFields\n    }\n  }\n}",
    "operationName": "LatestPeriod",
    "variables": {
        "id": accountIds
    }
}

response = requests.post(url, json={'query': body}, headers=headers,cookies=cookies) 

print(response.status_code)
print(response.json())

but I am getting an 401 with a message 

'OAuth plugin - No refresh_token present'

I have tried removing the headers and I am still getting the same error