Execute Python script as a part of logic app

Question

Hello,
To give some context to our problem we have a pipeline that needs to run on Azure Data Factory to create a CSV file(with a dynamic name Problem_1.csv, Problem_2.csv, etc). This CSV file then needs to be read by a Python script that executes and creates another output file. How do I execute this as part of the logic app workflow as well as passing input to the python script?
I did a search online and the options seem to be Azure WebApps or Azure Container Instances. Since we don't need this script to be running all the time but just run when the rest of the pipeline runs what would be our best option?

Answer 1

Hello @Siddhanth Shetty , According to me a Azure Function App running on a consumption plan will be better suited for the task as they offer serverless solution. Based on the scenario mentioned above I can think following steps for implementation.

1. You can upload the csv file in Azure storage and which will trigger the function App containing your Python script which will generate the required file and upload it back to blob storage in a different container.
2. For you Logic App, you can use the blob storage trigger to monitor the container above and create actions as required.

Please let me know if there are any concerns.