I’m looking to create an integration for Florida Power and Light that retrieves the historical data every day. My question is on how to store the data when retrieved. Everything that I’ve seen is a real-time sensor, so the recording functions take care of everything. If I do that, everything will be off by 24hr+. Is there a way to store historical data in Home Assistant so that when I graph information it will overlay correctly? I know I could dump it directly into a database and query it with grafana, but I’d rather have it integrated with HA if possible.
Yeah, I think the only way is going to be to store it in the database manually. If I ever get around to it, I’ll probably just put it in InnoDB and not worry about HA.