Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to read data from sharepoint list using RPC calls - owssrv.dll. I works perfectly when I read data in Qlikview from a sharepoint site which is within our network. The authentication to the site here is NTLM authentication.
But when I try to read data using the same method on a third party sharepoint site (outsite my own network), it gives me 'Access Denied' message. This sharepoint service uses basic authentication for access to the site. How do I provide this username and password for the RPC call?
Does anyone have any experience with working with (reading from sharepoint)? I seem to be lost here.
Nimish
hi.. can u help me reading sharepoint data to qlik view..
u mentioned as you have developed that for your own domain. using RPC, but i am struck up with that..
Can you upload your qvw file or code u used will be very helpful..!
Hi Ajay,
The basic understanding of how to do it is given here:
http://community.qlik.com/wikis/qlikview-wiki/reading-data-from-sharepoint-lists-into-qlikview.aspx
The way I did it was as follows - (For downloading a list from sharepoint):
My internal sharepoint URL for Extension list is
http://skpsharepoint.skparekh.com/Lists/Extention%20List/AllItems.aspx
I went to veiw source and searched for list=
I get the GUID from there - e3518d6f%2D7f90%2D4a56%2D9b5b%2D9bd97cac1116
In Qlikview, I select the Web Files.. button and provide the following in the Internet File
Notice the curly brackets before and after the list GUID.
In the next dialog box I select Xml.
In the tables tab, if you select xml/data/row, you should be able to see your list in tabular format.
Click Finish.
A lot of script gets written. but basically, three tables are getting loaded
AttributeType:
row:
xml:
I remove the scripts from attributetype and xml tables. We juswt need the row table.
Note:
In case you have sites within the main site, remember to include the full URL till the last site. eg. I have another list which is on the same site but within it there is a subsite called support and within that another subsite called purchase. The URL is
http://skpsharepoint.skparekh.com/SPT/PUR/Lists/Vendor_Contacts/AllItems.aspx
In this case the URL that I will provide will be
I hope this helps. Do let me know if you have any queries.
Nimish
Hi Nimish,
I was also following the same wiki site. But the problem with me is that i am using HTTPS site. whenever i try to do the steps of adding web files->Internet files and the site with LIST and GUIID , its turns up as "You are not authorised to view this site" ..
i think its not getting my credentials for opeing the page. I dont know where i am struck.
Can you help me, is there any way around to get this problem solved..!
I also would want to be able to consume some xlsx files we have stored in sharepoint. I did see the web files option on the load script but i'm at loss as to how we can use it to access a sharepoint document... I understand sharepoint documents are stored in sql server.. had it been just a network drive then i would be using unc path and be done with it.
hi Nimish,
how can you enter the share point outside of your network ?
Hi,
Even I am not sure how to access it outside the network. The problem is with the authentication which qlikview does not seem to provide.
Nimish
Hi all,
I am trying to connect to Sharepoint. The site is within my network, but i get the 'You are not authorised to view this page .. ' error. What permissions I must have in Sharepoint or on server to connect?
Now I have full access to this site from Sharepoint side and a user permissions on server.
Regards,
Andris
edit: I try to open the link in IE, and it opens xml file with data I needed
- I am trying to read data from sharepoint list using RPC calls - owssrv.dll.
-It is not working perfectly when I read data in Qlikview from a sharepoint site which is within our network.
-it gives me 'Access Denied' message.
- When i tried the url path in IE i'm able to get the xml data after giving the Username & Password when i entered into partiular page.
What is the problem? Can you help me plz