Automatically download zip file, extract and search csv file

Hi Guys & Girls,

Does anyone know how to automatically download and extract a zip file to save the csv file so it can be searched with a value from a sensor?

The purpose is to use a Milesight LPR Camera that is sending a webhook to HA, the automation will then search the csv file for stolen vehicle.

I suspect this would be a very popular feature to get running.

Have the webhook running and a vehicle license plate sensor. Need to be able to download the zip file and save csv and search.

Thank you in advance.

Hi Matt,

This is a recent addition to HA, perhaps it would help you.
Templating - Home Assistant.

That zip() function is for combining (or separating) two or more lists. Unrelated to zip file compression.

You could probably do something with the command line integration and do all the work outside of HA.

1 Like