idea Json API to pull usage data in "My Account" Ideas

Json API to pull usage data

IT_Guy — Fri, 28 Apr 2023 03:47:52 GMT

Hi Agl

Is there an API available so i can pull my usage data ( same data found in the downloadable scv at https://myaccount.agl.com.au/usage ) from my agl account to a database i'm creating to analyse my solar generation across multiple system and my power usage

Re: Json API to pull usage data

David_AGL — Fri, 10 Jan 2020 02:24:46 GMT

hi @IT_Guy, good question. I'm not aware of such an API existing, but I can check in with the My Account team. This actually sounds like a similar project to what another of our community users (@NeilC) was attempting to put together.

What's the end goal you had in mind?

Re: Json API to pull usage data

Dim — Sun, 09 Feb 2020 00:01:40 GMT

Hi David,

I'm not sure of @IT_Guy plans, but I've used data pulled from a previous providers API ( Mojo power ) to a home automation system.

I was able to estimate bills and display usage data on a display in the house.

If an API was available for AGL I'd love to be able to do the same again 🙂

Re: Json API to pull usage data

Sydmd — Mon, 23 Mar 2020 05:24:42 GMT

@David_AGLI too would like access to an API key in an effort to make a HomeBridge plugin.

Is this something AGL is working on?

Thanks in advance.

Re: Json API to pull usage data

vidgen13 — Mon, 30 Mar 2020 00:19:32 GMT

I want a REST API too.

Re: Json API to pull usage data - Status changed to: Good Idea, Vote!

David_AGL — Mon, 30 Mar 2020 00:48:23 GMT

I've moved this across to the My Account ideas page to get it more visibility. Definitely seems there is some support for this feature. Please Like it and let us know what you'd like to accomplish with the access.

Re: Json API to pull usage data

john_loyola — Sat, 04 Apr 2020 04:54:51 GMT

Hi @David_AGL ,

Good day.

I would be very interested to consume the usage data via a REST API (JSON payload) be it daily / weekly / monthly / for a specific time period if there is a provision from AGL to provide it. As @IT_Guy mentioned, its the same data that is available in MyAccount -> Usage as a CSV download. Not sure what is the API enablement strategy in AGL, but the step towards it would be really benefit the customers as well as the enterprise.

Thanks,

Johnny.

Re: Json API to pull usage data

David_AGL — Mon, 06 Apr 2020 01:29:21 GMT

Hi @john_loyola thanks for the input.

I really like the idea, but can you help me understand what the benefits would be to having direct access as opposed to utilizing the current CSV download? Creating and maintaining any access like this would probably have some developer effort associated with it, so to help make the case I would need to know what solutions it could provide.

Re: Json API to pull usage data

vidgen13 — Mon, 06 Apr 2020 12:45:19 GMT

I can link it to my homeassistant app. Instead of downloading and parsing csv files. Its Its easier if it has a rest api.

Re: Json API to pull usage data

RyanQLD — Thu, 09 Apr 2020 13:48:46 GMT

Hi @David_AGL

I'm yet another person who would appreciate an API for usage data.

I really like the idea, but can you help me understand what the benefits would be to having direct access as opposed to utilizing the current CSV download? Creating and maintaining any access like this would probably have some developer effort associated with it, so to help make the case I would need to know what solutions it could provide.

The current CSV download is difficult to automate because it requires creating a scraper that handles your authentication process, which is quite complicated as it involves several redirects and steps. Ideally there would be an endpoint where we could send our AGL username and password in an Authorization header and get the usage data back. Bonus points if there was a way to filter it by time but that's not necessary. More bonus points if it's in JSON format rather than CSV.

The benefits to customers are that we can automate our usage, display it on dashboards, analyse it and so on.

The benefits to AGL are in customer acquisition and retention. By not having the API, you risk having customers leave in search of a provider who does. And by having the API, you encourage customers to leave other providers and join AGL.

-Ryan

Re: Json API to pull usage data

David_AGL — Tue, 14 Apr 2020 00:47:50 GMT

Cheers @RyanQLD , that's very helpful.

Re: Json API to pull usage data - Status changed to: Under Consideration

David_AGL — Tue, 14 Apr 2020 00:48:18 GMT

Re: Json API to pull usage data

FrankAu — Fri, 17 Apr 2020 22:12:45 GMT

@RyanQLD sums it up nicely!

Once the api is there and people start using you can anticipate an open source effect where the community will generate even more interest by showing the art of possible. This in turn creates its own wind and much stickier customers ... especially if there is marginal financial difference to any other energy supplier.

Re: Json API to pull usage data

mgmolnar — Tue, 28 Apr 2020 13:44:31 GMT

I would like to see if i can pull the amount of KW my solar is generating so that i can use IFTTT to turn my pool pump on/off during the day.

Re: Json API to pull usage data

Gareth — Mon, 04 May 2020 02:52:27 GMT

I would like to see an API please as well, even if you don't have a smart meter.

Re: Json API to pull usage data

kylieI — Thu, 21 May 2020 07:24:59 GMT

I too would appreciate an API to access usage data. My interest is in the recent meter reads (ie the running kWh accumulators, not the incremental usage). I would be making a request every 30 mins. Thanks!

Re: Json API to pull usage data

Bashface — Wed, 27 May 2020 07:10:28 GMT

This Would Be Great!!, A REST API to use in home automation systems such as home assistant, That would definitely make me switch back to AGL.

Re: Json API to pull usage data

fhratul — Mon, 29 Jun 2020 23:51:43 GMT

+1 for a JSON API. My current process is:

- Use a cron to submit request for usage data every Saturday for the last week.

- A script checks for email and extracts the attachment, puts it in Google Drive

- A second script pulls from Google Drive and formats the CSV in a more digestible format.

- A third script reads it and displays it in my Home Automation dashboard.

It doesnt work in real time and its getting annoying and can be the only reason I switch to a different provider. I have been in touch with AGL re: this before and doesnt look like there has been any progress at all. Happy to help with the development/test if needed (I am a software engineer).

Re: Json API to pull usage data

David_AGL — Tue, 30 Jun 2020 00:41:44 GMT

Thanks for the feedback everyone, keep it coming. I can confirm that this access is under serious consideration, it's just a question of timing, and at this stage I can't give any firm timeframe.

Re: Json API to pull usage data

AlBrough — Wed, 01 Jul 2020 13:16:10 GMT

Hi,

I’d appreciate an api to call usage stats - this will help tremendously with my power billing estimates for work and neat feature to add to my home assistant dashboard that no other supplier offers currently (as far as I know)