How to fetch the uploaded csv file from a storage account and read the data inside it and execute the sql query using logic app

Pragiri 0 Reputation points
2024-09-27T07:29:15.3833333+00:00

How do I read an uploaded csv file from a storage account and fetch the data and execute the sql query using logic apps

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,814 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,113 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. LeelaRajeshSayana-MSFT 15,071 Reputation points Microsoft Employee
    2024-09-27T21:56:21.1166667+00:00

    Hi @Pragiri Greetings! Welcome to Microsoft Q&A forum. Thank you for posting this question here.

    With the current connectors and actions available in Logic App, there is no direct approach to parse the CSV file. However, you can manipulate the data from the CSV file and break it into line arrays and process them as JSON data using the approach provided in the following similar question

    You can then connect to SQL database and execute SQL queries using the steps provided in the article Connect to an SQL database from workflows in Azure Logic Apps

    I would recommend using an Azure function such as a Azure blob triggered function which provides more capabilities on parsing the CSV file and connecting to SQL database directly.

    Let us know if you have any additional questions on need further assistance.

    If the response helped, please do click Accept Answer and Yes for the answer provided. Doing so would help other community members with similar issue identify the solution. I highly appreciate your contribution to the community.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.