Exporting Homey Insight variable history with high resolution

Questions & Help
1

Hi all,

I’m trying to access historical data from a Homey variable in HomeyScript. I need to know exact timestamps when a variable changed to a certain value, but as far as I understand, HomeyScript and Flows only allow access to the current value, not historical data.

I know Insight stores the history, but I can’t export it with high enough precision for longer periods (per-minute or per-second data). I’ve read about unofficial API workarounds, but I’m not sure how to implement them.

Are there any reliable ways to export or access per-minute/second variable history from Insight, or do I need to start logging changes externally to get that level of detail?

Thanks for any advice!

2

Search app store for ‘export’, ‘insights’ and for ‘mysql’.

After 1 hour the data already starts to get averaged. So you’d start the export tool at least each hour.

Data Age / View Period Aggregation Interval Resulting Granularity
Last Hour 5 Seconds Highest resolution (closest to raw data)
Past Hours (up to 6 hours) 60 Seconds (1 Minute) Slightly reduced resolution
Past 24 Hours 300 Seconds (5 Minutes) Still good for daily trends
Past Week 3600 Seconds (1 Hour) Good for viewing daily patterns
Past Month 21,600 Seconds (6 Hours) Shows larger, slower trends
Year and Older 604,800 Seconds (1 Week) or 1 Day