This method of extraction always required a GUID to fetch a list or a specific view. This posed difficulties in automating some of the extraction tasks.
With the launch of Sharepoint 2013 Microsoft provided REST(Representational State Transfer) interface which is a data service that allows you to use construct HTTP requests to query SharePoint list data. The main advantage here is that WCF Data Services uses the OData protocol for fetching the data. The data is returned using a well known XML format called ATOM. As a Qlikview developer you don't have to learn entire technical aspects of this new feature. All you have to do is to understand some of the very useful methods.
Some of the main advantages are given below.
1. GUID is no longer required to fetch a list. Now we can fetch a list by the Title
I encountered the same error when I was deploying my application to server. So the following might fix the issue.
This error message is usually found where there is security access issues.
1.. Check whether the ID by which you are executing the qlikview publisher has proper sharepoint access.
Log into the server with the user id and password . Launch the sharepoint server . If you are asked to enter user name and password chances are that Qlikview is not getting the user authentication info.
2. If your id has access , you need to do one more configuration in Internet explorer in the server. Apparently microsoft is storing this setting as part of internet explorer security settings.
Go to internet explorer > internet options> Security .
Click on trusted sites and add the sharepoint site into list of custom sites .
Then click on the 'Custom level' button under security level area.
This will open up a list of options . Scroll all the way do and find option
By default it will be selected to 'Automatic logon only in intranet zone' change it to
'Automatic logon with current usename and password'
This is what I have done to get things working. Ironically this falls in between admin and developer and sometimes none of us know what is going on.
We have to do it every server using the ID. For example if you move the app to prod , you have to do it there too. I guess you get the idea,
Try it out and let me know whether it helped you..
Thank you for the information. I found something similar to this and it also worked. Instead of trusted sites, we go to Local Intranet, then Advanced Settings, then add the SP site to trusted site and had to check the box for secure HTML.. and it worked!
thank you for sharing this information. It works fine for me as long as I only use the fields ID, title, modified and created. As soon as I try to read details from fields like description with multiple lines I get no values. How can I read from fields with blank in the field description like 'Assignd to' and how can I extract date from the field 'Created by' or 'Modified by'? Thank you in advance.