Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
I would like to read multiple files from Sharepoint into QlikSense.
All the data files are having the same format and I am using the SharePoint Connector.
One file looks straight forward (here), but I couldn't find the solution to do it for ALL files in a specific folder.
Hope you can help! Thanks a lot in advance.
Hi @Ray123 ,
Not sure if it is still relevant for you, but I had the same challenge today and came across your post here. In case you still need a solution: you can use the following piece of script to overwrite the URL on your library connection:
let vQwcConnectionName = 'lib://Qlik Webconnector';
Office365Connector_CanAuthenticate:
LOAD
authenticated as CanAuthenticate_authenticated,
error_message as CanAuthenticate_error_message
FROM [$(vQwcConnectionName)]
(URL IS [http://yourhost:5555/data?connectorID=Office365Connector&table=CanAuthenticate&appID=], qvx);
Office365Connector_GetFileXLS:
LOAD
header1,
header2
FROM [$(vQwcConnectionName)]
(URL IS [http://yourhost:5555/data?connectorID=Office365Connector&table=GetFile&subSite=%2fsites%2fyourfolder...], ooxml, embedded labels, table is Sheet1);
Note that you need to specify the correct file read instructions, so in the above case the ooxml part for Excel files. You can use the listfolders and listfiles endpoints to find out a list of files and then use the above script to iterate over that list and load them all.
Hope this helps you or anyone else struggling with the same!