connection with sharepoint/share drive- appending the data on addition of new file.
Hello,
once the connection is established with share point and share drive . Can a script be written to schedule to append the data when new file is added in the share drive /share point .
So basically the upload should happen automatically when there is new file in share drive or share point.
You need to have Qlik Web Connectors installed, either on the Enterprise Sense server or another in the same domain (there is more config if you go for another machine).
You need to follow the installation instructions carefully. Two easily missed gotchas are ensuring you unblock the zip file and that you run the service installation batch file using "run as Administrator".
Go to https://servername:5555/ to get to the QWC web interface. You will need to accept the licence agreements and go to the Licence section and enter your Qlik Sense Enterprise licence details. Note that this requires that this doesn't work with the old token based licences and you may need to get your licence converted to do this bit.
Find the Office 365 Sharepoint connector under the premium connectors.
Here you have a number of different ways of connecting. First you need to authenticate with your SharePoint site though.
Once that is done you should be able to use ListFolders, ListFiles and GetFile to retrieve files from the server. Do this manually at first, entering all of the required parameters into the web form.
Once you have this working you can go to the Qlik Sense (Standard Mode) to get the code to run, there are important instructions on this sheet on how to set this up.
You will need to do a List Files into a table and then enumerate around it to get each of the IDs to pass into the Get File function. The loop will be something like:
for iFile = 0 to NoOfRows('FileList') -1 sFileID = peek('FileID', iFile, 'FileList');
