Forum Discussion
Get single CSV file from Sharepoint folder
Hello All,
I need to get only one single file from shared folder on MS sharepoint and make it in one query, please advise.
Regards,
Mohsen
Hi Mohsen_2020 ,
You should use a Sharepoint folder connector.
In the SiteURL enter root URL to your Sharepoint site, e.g. [domain].com/sites/[your site name]. Then click Transform and from the list filter column FolderPath to select your proper folder and file.
If you see you file on the list and then on the Binary hyperlink (the first column) and choose Tabel hyperlink for the proper Sheet.
_______________
If I helped, please accept the solution and give kudos! 😀
2 Replies
Hi Mohsen_2020 ,
You should use a Sharepoint folder connector.
In the SiteURL enter root URL to your Sharepoint site, e.g. [domain].com/sites/[your site name]. Then click Transform and from the list filter column FolderPath to select your proper folder and file.
If you see you file on the list and then on the Binary hyperlink (the first column) and choose Tabel hyperlink for the proper Sheet.
_______________
If I helped, please accept the solution and give kudos! 😀Thanks a lot lkalawski for your Help, it's working now.
