Get single CSV file from Sharepoint folder

[Mohsen_2020]

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

[lkalawski · Accepted solution]

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! 😀

[Mohsen_2020]

Thanks a lot @lkalawski  for your Help, it's working now.