Read sharepoint list data and convert to csv using ADF

Question

Is it possible to read sharepoint list data using ADF with having 60 sites and 100+ list items and automate XML response to CSV files ?

We already did POC using databricks, its working fine, but want to know whether ADF can handle without reading/creating schema and can create CSV files like dbx.

we already know the answer, but wanted to ask here.

Answer 1

Based on my understanding the current SPList connector is only for SP online and not for sharepoint hosted on On Prem.

So you would anyhow have to write your own custom logic to extract data from on Prem SPlists.

Also Service principals are present in your Entra ID (cloud AD) and since your SPlist is hosted on On-Prem, the Service principals cannot be reveres synced into on Prem AD hence you cannot grant SP access on On-Prem SP

Answer 2

Thanks for posting your question in the Microsoft Q&A forum.

• ADF has a built-in SharePoint Online List connector that can read data from SharePoint lists, it supports both SharePoint Online and SharePoint Serve.
• You can create multiple datasets, one for each SharePoint list, alternatively, use parameters in your dataset to dynamically point to different sites and lists.
• ADF typically requires schema definition for structured data operations. however, you can use dynamic schemas in some scenarios, especially with Mapping Data Flows.

---

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful