topic Re: Transfer file to sharepoint site from Lakehouse in Data Engineering

Transfer file to sharepoint site from Lakehouse

MarkBurgess — Wed, 18 Sep 2024 12:41:49 GMT

We have csv files in a Fabric lakehouse that we would like to upload to a sharepoint site. We have managed to read from Sharepoint using the API, but I can't write back as neither Sharepoint nor http is a valid sink for a copy activity.

Is there another way of doing this, from a notebook for example?

Thanks

Mark

Re: Transfer file to sharepoint site from Lakehouse

NandanHegde — Wed, 18 Sep 2024 15:09:38 GMT

Yes, unfortunately Data pipelines doesnt support sharepoint or REST/HTTP as sink because of which you have to wirte your own custom code.

You can refer the below stackoverflow link:

https://stackoverflow.com/questions/61603107/upload-a-file-to-a-sharepoint-folder-using-python

Re: Transfer file to sharepoint site from Lakehouse

MarkBurgess — Wed, 18 Sep 2024 16:19:26 GMT

Thanks. I ended up going down this route instead, but good to see both options.

Microsoft SharePoint Data Transfer Using Python | by Warda Rahim | Medium