Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am very new to QlikSense and my company is rapidly moving to sharepoint file storage and i need to work out how to get my QlikSense to load files directly from SharePoint.
I am trying to load Multiple Files from the same folder. Having looked on various other threads i can't see any solutions. I can load files individually using the 365 connector, however it won't suitable to do this for every individual file. Every file will have the same prefix followed by a different date I.E Data23/Data24/Data25.
I have tried the below:
let vQwcConnectionName = 'lib://SharePoint';
Office365Connector_ListFiles:
LOAD
UniqueId as ListFiles_UniqueId,
Name as ListFiles_Name
FROM [$(vQwcConnectionName)]
(URL IS [https://:xxxxxxxxxxx:5555/data?connectorID=Office365Connector&table=ListFiles&subSite=sites%xxxxxxxx...,
qvx);
// IMPORTANT: If, when loading the above script, you receive a 'Script Error' Dialog box with a 'Field Not Found'
// (or other) error, the first thing you should do is copy and paste the full request URL (i.e. the URL between the square [...]
// brackets IN THE QLIKVIEW / QLIK SENSE SCRIPT ERROR DIALOG) into a browser address bar and check the response.S
FOR Each vUniqueId in FieldValueList('ListFiles_UniqueId')
USAGE:
Load
*,
'$(UniqueId)' AS ListFiles_UniqueId
FROM [$(vQwcConnectionName)]
(URL IS [https://xxxxxxxxxxx:5555/data?connectorID=Office365Connector&table=GetFile&subSite=sitesxxxxxxxx&fil..., utf8, embedded labels, delimiter is ',', msq);
NEXT
CallumB have you see this article: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_QlikAutomation/connector-blo...