Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reading data from sharepoint

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?

16 Replies
Not applicable
Author

Does anyone have any experience with working with (reading from sharepoint)? I seem to be lost here.

Nimish

achiever_ajay
Contributor III
Contributor III

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..!

Not applicable
Author

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

http://skpsharepoint.skparekh.com/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={e3518d6...}

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

http://skpsharepoint.skparekh.com/SPT/PUR/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List=...

I hope this helps. Do let me know if you have any queries.

Nimish

achiever_ajay
Contributor III
Contributor III

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..!

Not applicable
Author

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.

Not applicable
Author

hi Nimish,

how can you enter the share point outside of your network ?

Not applicable
Author

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

Not applicable
Author

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

jagannalla
Partner - Specialist III
Partner - Specialist III

- 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