I'm currently working with data that I receive every 1st of the month. This data is delivered in my email as an excel file but it's protected with a password. I use Azure Logic App to move the attachment (excel file) to a blob storage. This file is then used within Azure Data Factory to copy it into my database table.
To automate this process I need a solution to enter this password automatically when I want to copy it into my database with ADF.
Is there someone that encountered the same problem and has found a solution?