Integrating Anglia water usage for smart meters (UK)

collse · April 19, 2024, 3:09pm

latest version has fixed it for me @11harveyj - any chance you could enable adding a fixed price to the integration? at the moment it will only track the consumption but with a fixed price being added onc could get an estimate without sewage and standing cost into the dashboard

11harveyj · April 19, 2024, 3:51pm

Awesome. I think I might be able to do something, although I don’t think the API returns much pricing data (at least on my account, I only seem to get the estimated total in May).

collse · April 19, 2024, 6:52pm

I dont think the API provides it but if you configure the energy dashboard at the moment the two bottom options arent available which I think may be an entity definition missing or so

the very last one would allow you to set a fixed price

11harveyj · April 19, 2024, 6:58pm

Yes, the data for the energy dashboard doesn’t actually come from an entity, but is instead added into the recorder using a statistic via an undocumented HA API.

This might be a limitation of HA but I will see

collse · April 20, 2024, 10:29am

is this possibly related?

2024-04-20 11:14:46.783 ERROR (DbWorker_1) [homeassistant.components.recorder.util] Error executing query: 'str' object has no attribute 'discard'
Traceback (most recent call last):
  File "/usr/src/homeassistant/homeassistant/components/recorder/util.py", line 141, in session_scope
    yield session
  File "/usr/src/homeassistant/homeassistant/components/recorder/statistics.py", line 1830, in _get_last_statistics
    metadata_ids = _extract_metadata_and_discard_impossible_columns(metadata, types)
                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/recorder/statistics.py", line 1586, in _extract_metadata_and_discard_impossible_columns
    types.discard("mean")
    ^^^^^^^^^^^^^
AttributeError: 'str' object has no attribute 'discard''

I dont see the error with the component disabled but it appears as soon as I enable it - with my limited knowledge of python I can however see you use “str” in the sensor code which I believe defines the return is a string?

github.com

pantherale0/haanglianwater/blob/a6438f62a7e3fca6593897b090abf45763b9b024/custom_components/anglian_water/sensor.py#L58


      
          def __init__(
              self,
              coordinator: AnglianWaterDataUpdateCoordinator,
              entity_description: SensorEntityDescription,
          ) -> None:
              """Initialize the sensor class."""
              super().__init__(coordinator, entity_description.key)
              self.entity_description = entity_description
          
          @property
          def native_value(self) -> str:
              """Return the native value of the sensor."""
              if self.entity_description.key == "anglian_water_previous_cost":
                  return self.coordinator.client.current_cost
              return self.coordinator.client.current_usage

collse · April 22, 2024, 2:04pm

fixed in latest release

sooty · April 22, 2024, 2:54pm

Finally gotten around to installing this. Thanks for putting the integration together @11harveyj - it works a treat and has even imported historical consumption data too.

At the risk of being fussy… Is it possible to put an Icon on the Integrations page?

11harveyj · April 22, 2024, 2:58pm

Yep, I just need to open a PR to the HA brands repository.

Once I’ve sorted an issue out with the prices, I’m actually going to try and get this into core as it’s a very simple integration and I can re-use a lot of stuff that already exists for other integrations.

thewillwilson · April 27, 2024, 12:43pm

I’ve raised a PR within the repo for logos & icons, just waiting to be merged

Add Anglian Water Logo and Icon by thewillwilson · Pull Request #5403 · home-assistant/brands (github.com)

11harveyj · April 27, 2024, 12:44pm

Perfect thank you

11harveyj · April 27, 2024, 1:15pm

Just for awareness, the repository and module is currently private due to what could be a pretty bad security issue on Anglian Water’s side.

Massive thanks to @collse for identifying. I have reported to AW and will make this public and active again once they have had a chance to resolve.

I don’t want to cause issues for any AW customers and also AW themselves by keeping the code public.

Apologies all and hope you understand why.

collse · April 27, 2024, 1:19pm

was just about to drop you an email to enquire

sooty · May 2, 2024, 7:57am

Hi @11harveyj. Reading updates in this thread I understand why you have pulled the code. I assume, this is now why, having upgraded to HA 2024.5 I am now seeing this?

Any chance you can add me to the private repository so I can continue to use this integration whilst Anglian Water fix their exposure?

11harveyj · May 2, 2024, 1:15pm

Hi,

Repo is public again, although I haven’t made a post yet as AW have pulled their API entirely at this point to fix so integration is currently not working.

Was supposed to be fixed Monday, but not heard anything from their IT team since.

sooty · May 3, 2024, 11:14am

Thanks - It looks like they have pulled the whole mobile application!

11harveyj · May 3, 2024, 11:22am

Yep, was a pretty serious data protection issue.

collse · May 3, 2024, 11:55am

to be fair it was just poorly implemented - way to wide/open - not necessary, could have easily been jailed the query - we’ll see what happens now

collse · May 3, 2024, 6:00pm

Seems its back on my stats are coming through again and this time they are correct

11harveyj · May 3, 2024, 6:06pm

Yep, the mobile app is back now. I will test the latest update properly, but after upgrading to 2024.5.0 the integration will fix all the previous stats (including cost).

sooty · May 4, 2024, 7:00am

I can see their mobile app is back on line as @collse states, however, the integration is still not loading for me. I’ve tried disabling/re-enabling and even trying to add an additional integration - get “Config flow could not be loaded: 500 Internal Server Error Server got itself in trouble”.

Also, here is my log…