Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am currently using a .xlsx file that is posted on a protected SharePoint site for my source data. How do I determine what user name needs to be added to the SharePoint Permissions list to successfully access this file?
Thanks,
Cassandra
I guess you're using a Qlik Server and you want a task on the server to automatically fetch the file?
If that is the case, the Qlik services are usually run as a domain user, the Qlik server would authenticate itself as this user to the sharepoint server.
To find what users the services run as, click start and type: services.msc on the Qlik server and in the following list look for the services starting with Qlik... look at user colunm for the user.
The alternative method you can use, is to embed the credentials in the URL you're calling to get the file: https://user:password@sharepointserver/path/to/xlsxfile
I guess you're using a Qlik Server and you want a task on the server to automatically fetch the file?
If that is the case, the Qlik services are usually run as a domain user, the Qlik server would authenticate itself as this user to the sharepoint server.
To find what users the services run as, click start and type: services.msc on the Qlik server and in the following list look for the services starting with Qlik... look at user colunm for the user.
The alternative method you can use, is to embed the credentials in the URL you're calling to get the file: https://user:password@sharepointserver/path/to/xlsxfile
If you are accessing the file from Qlikview in your machine, you should add your user name to SharePoint permissions.
I am in development but not when the QVW is put into production.
Then you may have to use Qlikview Service account.