Connect to SharePoint folder files using an activity in Data Pipeline

[supriyapandey19]

Hi,

Does anybody have any idea on how to pull the SharePoint files from a folder using any activity in data pipeline? I can only see SharePoint Online List as the connector but that will not be useful for pulling the files from SharePoint.

[v-cboorla-msft]

Hi @supriyapandey19 

Thanks for uisng Microsoft Fabric Community.

Apologies for the delay in response.

The SharePoint Online List connector in Microsoft Fabric data pipelines isn't suitable for directly pulling files from folders.

For more details please refer: Supported capabilities

I hope this information helps. Please do let us know if you have any further questions.

Thanks.

[v-cboorla-msft]

Hi @supriyapandey19 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond back with the more details and we will try to help.

Thanks.

[v-cboorla-msft]

Hi @supriyapandey19 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread.

Thanks.

[NandanHegde · Accepted solution]

Hey,

You can use sharepoint rest api as the source in copy activity to copy files from sharepoint .

below blog provides the details for the same:

https://www.syntera.ch/blog/2022/10/10/copy-files-from-sharepoint-to-blob-storage-using-azure-data-f...

Note : the blog is w.r.t ADF but the concept across fabric data pipeline remains the same