Sharepoint File Read

[Akhand_Singh]

Hi,

I'm trying to read all .xlsx files saved under different folder(s) in Sharepoint sites. I have tried using Sharepoint Input Tool but it is not dynamic with respect to folders. We have also tried API that too helps to get list of files in a sharepoint site. Any other alternative that we can use to read all files at once from sharepoint.

[Warcry]

You can use onedrive to link the folder from sharepoint. 

Go to sharepoint and to the specific folder and link it. Now you can use that folder to crawl in and retrieve your files. You'll see the folder (directory) linked through onedrive and not your C drive.