I'm working with Qlik Cloud in a testing phase,. I want to create a data connection with Sharepoint. I need to read all files inside a subdirectory, let's say: https://test.sharepoint.com/:f:/r/sites/site1/dir1/dir11/dir111
I guess I can create an Office 365 Sharepoint conection as: base URL (https://test.sharepoint.com) and Site/Subsite Path (:f:/r/sites/site1/dir1/dir11/dir111) to have acces only to that subdirectory. Is there any way to list the files inside this subdirectory an loop through them?
If the answer is no, in order to list the files inside the subdirectory, I guess I need to create another Office 365 Sharepoint Metadata connection. The problem is that I can not specify the Site/Subsite Path, only the base URL. I don't want to have access to all the data inside the Sharepoint account, just the files inside subdirectory. Is this possible?