UtilityAPI.com integration with energy

[karwosts]

You might look at how this works:

Custom Integration to import long term statistics from a file like csv or tsv

After a lot of research, I managed to implement an integration to import long term statistics from a file like csv or tsv (I did not find any existing integration doing this). This custom integration offers a service with some parameters, the most important one being the file name containing the historical data. In this way, you can easily import historical statistic data into a running HA instance, without the need to be familiar with SQL. You can find it here: GitHub - klausj1/homeassistant…

Note the energy panel works off of statistics, not regular history. So you don’t want to insert records into the history table but into the statistics table. A rest sensor is probably the wrong way to go for that.