In Ireland, we have a ESB Smart Meter which returns the In and Out usage of power by a home every 30mins. There is an API which returns this csv format data.
I’d like to create a HA integration/add-on which gets the data and then records the values into a format which HA can leverage.
This is an existing repo which has the steps for the login and downloading of the csv data
and I’d hope to reuse/integrate this with the Restful API/Scraper functions from HA.
The format of the csv data is shown below
MPRN,Meter Serial Number,Read Value,Read Type,Read Date and End Time
100012XYZ,33831590,0.006000,Active Import Interval (kW),07-06-2024 01:00
100012XYZ,33831590,0.008000,Active Export Interval (kW),07-06-2024 01:00
100012XYZ,33831590,0.009000,Active Export Interval (kW),07-06-2024 00:30
100012XYZ,33831590,0.006000,Active Import Interval (kW),07-06-2024 00:30
My question is how should i transpose this data feed and what sdk/api from HA should i call so i can track the kW In and Out usage.
Any advise/pointers would be appreciated.
Thanks