COPY excel files into /Files directory in a lakehouse

[amaaiia]

I want to create a Data Pipeline that allows me to COPY some excel files that I have in a Sharepoint directory to my /Files path in my lakehouse A_LH.

How can I do it? With COPY activity there's the Sharepoint online list connector, but it's not useful to do this.

[NandanHegde · Accepted solution]

You can use the web activity to get the files from sharepoint.

The below blog porvides details to do the same :

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

You need to replace the blob with the lakehouse