Transfer file to sharepoint site from Lakehouse

[MarkBurgess]

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

[NandanHegde · Accepted solution]

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

[MarkBurgess]

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