Sharepoint

Question

how do you read from sharepoint

Answer 1

@Stig Danielsen - Thanks for the question and using MS Q&A platform.

To read data from SharePoint in Azure Data Factory, you can use the SharePoint Online List connector. Here are the steps to follow:

1. In the Azure portal, create a new data factory or open an existing one.
2. Click on the "Manage" button to open the Data Factory UI.
3. In the left-hand menu, click on "Connections" and then click on "Linked Services" click on the "New" button to create a new connection.
4. Select "SharePoint Online List" as the connector type.
5. Enter the required information for the connection, such as the SharePoint site URL, authentication method, and credentials.
6. Test the connection to make sure it works.
7. Once the connection is created, you can use it in your data factory pipelines to read data from SharePoint.

For more information on how to use the SharePoint Online List connector in Azure Data Factory, you can refer to the official documentation: Copy data from SharePoint Online List by using Azure Data Factory or Azure Synapse Analytics.

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.