topic Reading data from sharepoint in QlikView

Reading data from sharepoint

Wed, 06 Jan 2010 01:02:20 GMT

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?

Reading data from sharepoint

Fri, 22 Jan 2010 22:53:36 GMT

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

Nimish

Reading data from sharepoint

achiever_ajay — Wed, 17 Feb 2010 13:57:34 GMT

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

Reading data from sharepoint

Thu, 18 Feb 2010 00:18:03 GMT

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={e3518d6f%2D7f90%2D4a56%2D9b5b%2D9bd97cac1116}

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={ea03ca66%2De5fc%2D4528%2Daf1d%2D82118192d632}

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

Nimish

Reading data from sharepoint

achiever_ajay — Thu, 18 Feb 2010 05:13:10 GMT

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

Reading data from sharepoint

Thu, 04 Mar 2010 23:24:51 GMT

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.

Reading data from sharepoint

Thu, 04 Mar 2010 23:28:42 GMT

hi Nimish,

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

Reading data from sharepoint

Fri, 05 Mar 2010 04:28:24 GMT

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

Reading data from sharepoint

Wed, 17 Mar 2010 08:34:14 GMT

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

Reading data from sharepoint

jagannalla — Mon, 11 Apr 2011 09:04:41 GMT

- 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

Reading data from sharepoint

Tue, 14 Feb 2012 13:16:33 GMT

HI Guys,

Did you get this working?

Reading data from sharepoint

Tue, 14 Feb 2012 14:54:50 GMT

Hi,

I got this working after I added sharepoint site to trusted sites in IE

Reading data from sharepoint

Thu, 03 May 2012 08:07:52 GMT

Hi,

Hope you can provide sample QVW that connects to Sharepoint server using this method.

Thanks.

~skip

Re: Reading data from sharepoint

qlikviewforum — Mon, 20 Aug 2012 13:49:05 GMT

The particular sharepoint where I am going to fetch the data needs authentication. Could you please let me how that can be done please.

Created the new thread for the same below.

http://community.qlik.com/message/249859#249859

Thanks,

qlikview forum

Re: Reading data from sharepoint

qlikviewforum — Fri, 31 Aug 2012 12:26:21 GMT

Hi All,

I tried my level best but unfortunately couldn't able to succeed yet.

I read some where about QVSource. Is it possible to load the data from secured sharepoint site using the same? Any help please?

Thanks,

qlikviewforum

Re: Reading data from sharepoint

Anonymous — Wed, 01 Oct 2014 15:22:44 GMT

I managed to retrieve the data but only a subset of the data is downloaded. Specifically it is downloading 30 records which is the number of records display in the view. Is there a way to download the full data set and not limited by the view setting ?

Re: Reading data from sharepoint

everest226 — Mon, 20 Mar 2017 19:09:17 GMT

Loading Excel file from Sharepoint into Qlikview.