I want to import Text file(CSV) data to Azure SQL by using logic-App

Question

I tried using HTTP request I am able to send the data from HTTP request to azure SQL but I am manually Send the data through postman but that is not my requirement

Requirement:I need to use a scheduler and a particular time the data from the text file need to be read and to be stored into Azure-SqlDB

if you have any resource or examples please let me know

Answer 1

About how import Text file(CSV) data to Azure SQL by using logic-App, you could reference this tutorial: Quick, easy and cheap way to automate data loading from CSV file into Azure SQL:

• Check out how to leverage Azure Blob Storage and Logic Apps for simple scenario of data loading from CSV into Azure SQL in less than 30 minutes and with almost no coding.
• About any developer out there at some point or another had to automate ETL process for data loading. This article will present a fast and convinient way to create data loading workflow for CSVs using Azure SQL and blob storage.

It also introduced other ways you could reference:

1. How import Text file(CSV) data to Azure SQL by using Data Factory.
2. How import Text file(CSV) data from Blob stroage to Azure SQL by using T-SQL.

You also could reference:

1. Upload Flat File on Azure SQL Database using Azure Logic App
2. Using Azure Logic Apps to Import CSV to SQL Server

I'm agree with @Mandar Dharmadhikari, Logic app is not the best way to do it.

If your csv file with large data, I also suggest you to use Data Factory，when the copy active pipeline created, you could trigger the pipeline executing in schedule.

Hope this helps.