today, I am looking for a solution to load a document from sharpoint. The problem is the autentification/log-in. Unfortunately we are currently forced to operate our QV-Server under a local account, so an automatic use of the AD-credentials is not possible.
The exact questions are
a) Is there a way to hand over the login credentials to SharePoint during automatic load by the QV-Server/publisher?
b) Can we use was well wildcards ( *_document.csv) to allow the documents on SharePoint to e.g. contain a timestamp in the name?
AFAIK loading from SharePoint means website-access and the possible protocols don't support wildcards or other file-functions and only restricted possibilities to authenticate an user (per header might be possible but probably not allowed/enabled).
Alternatives might be to map the SharePoint to a local drive on the server or to read the Lists from the SharePoint and then looping through them: Reading Data from Sharepoint lists into QlikView.
