Extarct data from Sharepoint Online List using Azure Data Factory

Copper Contributor

Hello,

I am trying to extarct the data from sharepoint online list.. but it gives empty file. I have followed the setup based on the below link.

 

https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list?tabs=data-fact...

 

Linkedservice - success

Dataset: success and able to see the site and select, however when i map the schema it shows nothing

 

Thanks

Thiru

2 Replies

@thiru1981 One possible reason for this issue could be that the SharePoint list you are trying to extract data from is empty. If true, you will not see any data when you map the schema. You can verify if the list is empty by navigating to the list in SharePoint Online and checking if there are any items in the list.

 

If the list is not empty and you are still unable to see any data when you map the schema, there could be an issue with the configuration of your dataset. You may want to double-check that you have selected the correct site and list when configuring the dataset.

 

 Let me know if this works for you. @ me in replies, or I'll lose your thread!!!  
Note: 

If this post helps, please consider Accepting it as the solution to help others find it more quickly. OR
If my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!
 
Best Regards,
Dallas.

@BabatundeDallas thanks for your response. Yes, i have re verified LS and DS configuration. everything looks correct and also site and list all are valid and i have the data in the list.