Integrate Data (different structure) from Blob to Azure SQL db using Logic Apps

Question

Hi,

Let me share the example of scenario.
Let say like we have few files are in Azure Blob Storage in different file format like csv, xlsx,... and different structure like EDI and Non EDI format.

Need to get the data from different file to single formatted file and have to load data to Azure SQL.

Can we achieve this through Azure Logic Apps.

Answer 1

@Vasanthan K Logic app does have Azure Blob and SQL connector that you can leverage in your workflow. You can read the binary content of any file using in storage blob using Get Blob action. If you want to handle the X12 communication then you can refer to this document as there are some prerequisites as mentioned in the document. Once you have formatted data as per your requirement then you can leverage different SQL actions or if you want to insert that data in the SQL table then you can leverage the Insert Row action.