Solved

Can we get access to the live usage API?



Show first post

204 replies

Userlevel 7

@Tim_OVO @Transparent @TerryE @andsee @SianiAnni 

 

Here is it: The API exe I promised that takes all that HH data and nicely formats it into a consumable Sheet

 

https://drive.google.com/drive/folders/1A7XRov0579O53T8OsIGe3wXCk09jul0F?usp=sharing

 

Download all the files, and read the Readme! (oh, and Enjoy) - now I can start work on ther TOU comparison tool!! 

 

If anyone is willing to send me their export please do!  - It will help me build the tooling.

John (at) QuinlanServices (dot) Com 

 

@Jequinlan and others, should I add this comment (above) to the best answer by @g-de ? Is a combination of these two the best customer created workaround for a lack of API we currently have? Let me know please :blush:

Userlevel 7
Badge +5

Can I point out that the “new” Billing Software, which is the connection point to our Smart Meters, is still undergoing development and bug-eradication. Any script which tries to lift data from the online Usage pages will need to be continually updated to match the current Billing Software version.

To make it even more tricky, it’s becoming apparent that not all customers are running the same software version. See this discussion about the Zero-in option.

My current Online Usage interface has changed further since that discussion. Not only do I not have a Zero-in Option, but there is no longer the ability to choose Yearly or Monthly from the Usage entry on the let menu.

 

I’m afraid we’re chasing a moving target.

Userlevel 1

@Tim_OVO I suspect you should probably hold off on that for now until the source code is published. As others have mentioned, it’s generally not a good idea to run DLLs found on the internet, especially when raw credentials are being used.

@Tim_OVOI suspect you should probably hold off on that for now until the source code is published. As others have mentioned, it’s generally not a good idea to run DLLs found on the internet, especially when raw credentials are being used.


Yes, you should be suspicious, at least when it’s published as Open Source it can be verified that it is not stealing your credentials whether intentionally or accidentally.

As a developer, I have access to tools which can make this as safe as possible before I try something out.

 

/Mike

Reply