Here is a way to expose most of the Glow Display MQTT information to home assistant through templates. Please make sure you ask Hildebrand support to enable your account for MQTT access before setting everything up.
The first step is to connect Home Assistant to MQTT. If you don't have your own broker hooked up yet, go ahead and set it up (I would suggest using the Integrations UI) and specify your Glow username and password as well as glowmqtt.energyhive.com as the server and 8883 as the port to make sure we're establishing a secure SSL connection.
If you already have your own MQTT server hooked up to Home Assistant, like I do, you will have to set up a bridge between your MQTT server and the Glow one, after that your server will mirror the MQTT messages from the Glow server. You have to do this because Home Assistant does not support connecting to more than one MQTT server.
I will assume you are using Mosquitto as an MQTT server. Start by creating a file named /etc/mosquitto/conf.d/glow.conf with the following content (replace GLOW_USERNAME, GLOW_PASSWORD and GLOW_DEVICE_ID with your relevant information):
connection glowmqtt
address glowmqtt.energyhive.com:8883
remote_username GLOW_USERNAME
remote_password GLOW_PASSWORD
bridge_capath /etc/ssl/certs/
topic SMART/HILD/GLOW_DEVICE_ID in 0
Once that is done, just restart Mosquitto to reload its configuration:
sudo systemctl restart mosquitto
Now you should be able to see your Glow messages over MQTT by using your client of choice.
If that works all right, you can open the Home Assistant configuration.yaml file (for me it is located at /home/homeassistant/.homeassistant/configuration.yaml) and add these new sensors under the sensor section (replace GLOW_DEVICE_ID with the relevant information for your device):
sensor:
- platform: mqtt
name: "Home Instant Electricity"
state_topic: "SMART/HILD/GLOW_DEVICE_ID"
unit_of_measurement: 'W'
value_template: "{{ value_json['elecMtr']['0702']['04']['00']|int(base=16) }}"
icon: 'mdi:flash'
- platform: mqtt
name: "Home Electricity"
state_topic: "SMART/HILD/GLOW_DEVICE_ID"
unit_of_measurement: 'kWh'
value_template: "{{ value_json['elecMtr']['0702']['00']['00']|int(base=16) * value_json['elecMtr']['0702']['03']['01']|int(base=16) / value_json['elecMtr']['0702']['03']['02']|int(base=16) }}"
icon: 'mdi:flash'
- platform: mqtt
name: "Home Daily Electricity"
state_topic: "SMART/HILD/GLOW_DEVICE_ID"
unit_of_measurement: 'kWh'
value_template: "{{ value_json['elecMtr']['0702']['04']['01']|int(base=16) * value_json['elecMtr']['0702']['03']['01']|int(base=16) / value_json['elecMtr']['0702']['03']['02']|int(base=16) }}"
icon: 'mdi:flash'
- platform: mqtt
name: "Home Weekly Electricity"
state_topic: "SMART/HILD/GLOW_DEVICE_ID"
unit_of_measurement: 'kWh'
value_template: "{{ value_json['elecMtr']['0702']['04']['30']|int(base=16) * value_json['elecMtr']['0702']['03']['01']|int(base=16) / value_json['elecMtr']['0702']['03']['02']|int(base=16) }}"
icon: 'mdi:flash'
- platform: mqtt
name: "Home Monthly Electricity"
state_topic: "SMART/HILD/GLOW_DEVICE_ID"
unit_of_measurement: 'kWh'
value_template: "{{ value_json['elecMtr']['0702']['04']['40']|int(base=16) * value_json['elecMtr']['0702']['03']['01']|int(base=16) / value_json['elecMtr']['0702']['03']['02']|int(base=16) }}"
icon: 'mdi:flash'
- platform: mqtt
name: "Home Gas"
state_topic: "SMART/HILD/GLOW_DEVICE_ID"
unit_of_measurement: 'm3'
value_template: "{{ value_json['gasMtr']['0702']['00']['00']|int(base=16) * value_json['gasMtr']['0702']['03']['01']|int(base=16) / value_json['gasMtr']['0702']['03']['02']|int(base=16) }}"
icon: 'mdi:flash'
- platform: mqtt
name: "Home Daily Gas"
state_topic: "SMART/HILD/GLOW_DEVICE_ID"
unit_of_measurement: 'kWh'
value_template: "{{ value_json['gasMtr']['0702']['0C']['01']|int(base=16) * value_json['gasMtr']['0702']['03']['01']|int(base=16) / value_json['gasMtr']['0702']['03']['02']|int(base=16) }}"
icon: 'mdi:flash'
- platform: mqtt
name: "Home Weekly Gas"
state_topic: "SMART/HILD/GLOW_DEVICE_ID"
unit_of_measurement: 'kWh'
value_template: "{{ value_json['gasMtr']['0702']['0C']['30']|int(base=16) * value_json['gasMtr']['0702']['03']['01']|int(base=16) / value_json['gasMtr']['0702']['03']['02']|int(base=16) }}"
icon: 'mdi:flash'
- platform: mqtt
name: "Home Monthly Gas"
state_topic: "SMART/HILD/GLOW_DEVICE_ID"
unit_of_measurement: 'kWh'
value_template: "{{ value_json['gasMtr']['0702']['0C']['40']|int(base=16) * value_json['gasMtr']['0702']['03']['01']|int(base=16) / value_json['gasMtr']['0702']['03']['02']|int(base=16) }}"
icon: 'mdi:flash'
Now restart your Home Assistant instance, and you should be good to go! All the sensors should appear in the developer tools menu, for instance sensor.home_instant_energy, and update in real time.
If you'd like to play with the MQTT API, you can also check out my python code to connect and fetch data directly from the MQTT server.