topic Re: Read Sharepoint List into Qlikview in QlikView

Read Sharepoint List into Qlikview

Mon, 02 Jun 2014 18:36:11 GMT

Dear all,

I want to read data from a Sharepoint List into Qlikview. Please, anyone can you help me?

Best Regards

Nancy

Re: Read Sharepoint List into Qlikview

Mon, 02 Jun 2014 20:30:51 GMT

Hello Nancy,

This works for our environment:

SharePoint data must be in a list (not Excel).

Go to the SharePoint list:

Right-click on any white space and then click on “View Source”:

Press Control F and search for “&List”:

Copy the WebQuerySourceHref value, located before “&List”:

Paste the value into QlikView as a comment:

Place your cursor on a new blank line and click on “Web Files…”:

Paste the address in the “Internet File” field and then click Next:

Choose “Xml” and “xml/Schema/ElementType/AttributeType” and then click Finish:

In this example, delete lines 5-13. This table is not the one we want.

Fix up the “xml” table by renaming it, remove excess columns, reorder the columns, and rename the columns.

Re: Read Sharepoint List into Qlikview

MarcoWedel — Mon, 02 Jun 2014 20:57:23 GMT

Hi Nacy,

you could try to import the table using the web files wizard in the script editor:

LOAD
     F1,
     F2,
     F3
FROM [http://yourdomain.com/yoursharepointsite.aspx]
(html, codepage is 1252, embedded labels, table is @1);

hope this helps

regards

Marco

Re: Read Sharepoint List into Qlikview

Mon, 02 Jun 2014 21:15:41 GMT

Thanks Kim, but I'm not sure that this is what I need.

Let me show you the script which sent me from Sharepoint for apply in Qv...

select

(select cod.nvarchar1

from alluserdata cod

where 1=1

and cod.tp_listid='A415F72D-7D0B-464A-B9AD-DBEA5C5C8C30'

and cod.tp_IsCurrent='1'

and cod.tp_RowOrdinal='0'

and cod.tp_ID=gapd.tp_ID

int2 as Status,

nvarchar4 as GAP,

nvarchar1 as Title,

sql_variant6 as KPI1,

float7 as KPI2,

sql_variant1 as KPI3,

sql_variant2 as KPI4

From alluserdata gapd

Where 1=1

and tp_listid='928F60EB-3A9B-41A2-BFE7-E21D6DD608ED'

and tp_IsCurrent='1'

and tp_RowOrdinal='0'

and tp_Created>='20140301'

and int8='2';

Obviously, I have the correct ODBC connection, but this query does not run correctly in Qv.

Can you Help me?

Thanks

Nancy

Re: Read Sharepoint List into Qlikview

Mon, 02 Jun 2014 21:27:53 GMT

Hi Nancy,

I believe there are a few different ways to get SharePoint data into QlikView. We use the non-SQL way. Here are some screen shots to go along with the text, if you want to try using the non-SQL way:

SharePoint data must be in a list (not Excel).

Go to the SharePoint list:

Right-click on any white space and then click on “View Source”:

Press Control F and search for “&List”:

Copy the WebQuerySourceHref value, located before “&List”:

Paste the value into QlikView as a comment:

Place your cursor on a new blank line and click on “Web Files…”:

Paste the address in the “Internet File” field and then click Next:

Choose “Xml” and “xml/Schema/ElementType/AttributeType” and then click Finish:

QlikView will insert code similar to the following:

In this example, delete lines 5-13. This table is not the one we want.

Fix up the “xml” table by renaming it, remove excess columns, reorder the columns, and rename the columns. Carefully make it look like this:

Re: Read Sharepoint List into Qlikview

jagan — Tue, 03 Jun 2014 02:13:09 GMT

HI,

Sharepoint Lists is not accessed like normal SQL tables, it should be accessed by using Webservices or Rest serices links for the list.

Please refer the following links

Integrating Sharepoint with Qlikview

Reading Data from Sharepoint lists into QlikView

How Qlikview read data from Sharepoint?

Re: How to Fetch a Sharepoint 2013 List using REST interface

Regards,

Jagan.

Re: Read Sharepoint List into Qlikview

Tue, 03 Jun 2014 16:20:18 GMT

Thanks Marco,

Finally I used a excel file imported from Sharepoint which is refreshed every time I open it. Then, in Qlikview, I use "LOAD FROM excel"

Best Regards

Re: Read Sharepoint List into Qlikview

Tue, 03 Jun 2014 16:20:36 GMT

Thanks Jagan,

Finally I used a excel file imported from Sharepoint which is refreshed every time I open it. Then, in Qlikview, I use "LOAD FROM excel"

Best Regards

Re: Read Sharepoint List into Qlikview

Tue, 03 Jun 2014 16:20:52 GMT

Thanks Kim,

Finally I used a excel file imported from Sharepoint which is refreshed every time I open it. Then, in Qlikview, I use "LOAD FROM excel"

Best Regards

Re: Read Sharepoint List into Qlikview

mikkeltaylor — Tue, 03 Jun 2014 16:34:40 GMT

Hi Marco, I tried this and I found it wasn't bringing through all the data. There were a lot of @'s to choose, but seemed to related to other parts of the page. any ideas?

Re: Read Sharepoint List into Qlikview

Thu, 07 Aug 2014 17:24:00 GMT

Please help. I have posted a question at a different sharepoint thread.

http://www.qlikcommunity.com/thread/73567

Re: Read Sharepoint List into Qlikview

Fri, 08 Aug 2014 14:19:31 GMT

I'm sorry,

Finally I used a excel file imported from Sharepoint which is refreshed every time I open it. Then, in Qlikview, I use "LOAD FROM excel"

Best Regards

Re: Read Sharepoint List into Qlikview

Tue, 23 Feb 2016 11:56:51 GMT

Hi Nancy,

Can you please briefly explain me how you have done that.

I'm also checking for a solution to get a excel file from sharepoint and to get the data in qlikview.

Re: Read Sharepoint List into Qlikview

everest226 — Wed, 30 Nov 2016 00:47:18 GMT

what are the step , i also have excel file that i want to get data from.

it says SharePoint data must be in a list (not Excel).

Re: Read Sharepoint List into Qlikview

dunnalahk123 — Mon, 21 Oct 2019 15:45:14 GMT

Hi, You got any solution to your Question.