How to read excel document from SharePoint directly dump it in Azure SQL using Azure Logic App ?

Question

I want to access excel document from SharePoint and without downloading that to data lake or blob storage, use Logic App to read the content of it and directly dump it in Azure SQL.

Answer 1

You can use a comination of Azure Logic Apps and Azure function to achieve this.

1. First you copy the file from SharePoint to Azure Blob (You can delete the blob after you copy the data) Refer: https://caiomsouza.medium.com/using-azure-logicapp-to-pull-files-from-microsoft-sharepoint-559dceb905c4
2. Write a Function app to read the data from the excel and write it to database. Refer: https://techmindfactory.com/Extract-Excel-file-content-with-Azure-Logic-Apps-and-Azure-Functions/

Hope this helps