Load Multiple files from Sharepoint into qliksense using 365 Connector

[CallumB]

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

[Luis_Arocho-LLantin]

CallumB have you see this article: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_QlikAutomation/connector-blo...