Service for Automated Energy Dashboard Data Export

[myxor]

Describe your core improvement

The current ability to manually download data from the Energy Dashboard (via the "Download data" button) is very useful, but I would like to request a corresponding service call that would allow for automated, scheduled data exports.

Goal: Create a service (e.g., homeassistant.export_statistics) or an exposed functionality that can be used in an automation.

Desired Service Parameters:

• statistic_ids: (List of entities/statistics to export, or empty for all?)
• start_time: (e.g., {{ now().year - 1 }}-01-01T00:00:00+00:00)
• end_time: (e.g., {{ now().year }}-01-01T00:00:00+00:00)
• period: (e.g., yearly, monthly, or hourly)
• filename: (Output filename/path)

Current limitations

Export can only triggered via UI manually by user.

Technical benefits

Use Case:

This would allow users to easily set up an annual automation that exports their full yearly energy usage as a CSV file (e.g., on January 1st), which is essential for end-of-year analysis, tax purposes, or long-term data archival without relying on complex external scripts or direct database manipulation.

Additional context

No response

[karwosts]

You may be able to combine recorder.get_statistics service call with a notify based write to file operation to achieve this.

[myxor]

Thanks @karwosts, good idea.

This approach definitely works and gives the same data as the energy dashboard export but in a very different format.

It would be great to have a way to automate the same functionality as it is available in the UI.