Historic API integration

[old ocean]

Hello,
I’m new to this server and I have an issue with the Home Assistant API.

I have outdoor scales that weigh my beehives every hour.
I can retrieve this data from my provider via an API.

The problem is that the data can only be updated twice a day. So even though the measurements are taken every hour, they are only made available/updated twice per day.

I would therefore like to import this data via a Node.js / Python script or something similar.

The issue is that when using the Home Assistant API, only the data at the time of import is stored. I can’t insert historical data.

Has anyone already encountered this issue?

[dim sparrow]

A triggered template sensor that checks every hour, maybe?

[dry ivy]

This kind of thing crops up where people get delayed access to power usage stats from a utility provider. there are probably some solutions in that space that you could adapt for a beehive weight sensor...

[dry ivy]

example from the energy side - https://github.com/patrickvorgers/Home-Assistant-Import-Energy-Data
It adds the information to the database directly.

you could also build a new scale that works locally then you could track the weight at whatever interval you like. someone did something similar HERE maybe worth a look at.