Automatically download zip file, extract and search csv file

[wifiguys (Matt)]

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.

[Sir_Goodenough ((SG) WhatAreWeFixing.Today)]

Hi Matt,

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

[mekaneck (Rick Auch)]

@Sir_Goodenough

This is a recent addition to HA, perhaps it would help you.

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

@wifiguys

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?

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