Using Function Apss Can I read data from Sharepoint and load it into Azure SQL Server?

Anusha Rudra 1 Reputation point
2021-11-30T06:16:29.147+00:00

I need Run ETL process to load SharePoint data daily to SQL Server Table. Even Reading the data through Function Apps and storing it into BLOB Storage will work, from Blob I can run Databricks activity to read and write data to SQL server.
I know it can be done through ADF but I would like to do it with Azure Function Apps as we already use it for other Processes.

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,261 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,917 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MayankBargali-MSFT 68,471 Reputation points
    2021-12-01T04:09:22.113+00:00

    @Anusha Rudra I do see Sharepoint does have the client library for the basic operation and for Azure SQL I can see Azure SQL Database APIs for .NET which you can explore and see if it can help you with your scenario/use case. If not you can check if there are any REST APIs or any other service SDK that you can leverage to perform the operations.

    From the function perspective, we don't have any Sharepoint trigger function but you can leverage any of the existing triggers (HTTP or Timmer) to execute your function app. Your function app code leverages any existing SDKs or the service REST APIs to perform the operation. Your function app will only have the input binding with no output bindings as you will be using Azure SQL Database APIs for .NET to write the data.

    0 comments