Forum Discussion

Mohsen_2020's avatar
Mohsen_2020
Icon for Helper III rankHelper III
6 years ago
Solved

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
Need Help
  • lkalawski's avatar
    lkalawski
    6 years ago

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

lkalawski's avatar
lkalawski
Icon for Resident Rockstar rankResident Rockstar
6 years ago

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's avatar
    Mohsen_2020
    Icon for Helper III rankHelper III
    6 years ago

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