topic Re: qlikview loading only 1000 rows from the XML file in QlikView

qlikview loading only 1000 rows from the XML file

Mon, 06 Aug 2012 11:05:20 GMT

Hi,

Qlikview is loading only 1000 rows from the XML file. Do we need to set anything to load the complete content?

Re: qlikview loading only 1000 rows from the XML file

Miguel_Angel_Baeyens — Mon, 06 Aug 2012 11:13:22 GMT

Hi,

Can you please elaborate on the script you are using to load the XML files? Did you make sure that if you are pulling from public services as Google there might be a limitation on the number of queries you can perform in a given period of time?

Miguel

Re: qlikview loading only 1000 rows from the XML file

Tue, 07 Aug 2012 08:58:58 GMT

Hi,

We are pulling the data from the project Sharepoint using REST service URL.

Re: qlikview loading only 1000 rows from the XML file

Miguel_Angel_Baeyens — Tue, 07 Aug 2012 09:23:57 GMT

Hi,

That might be then a limitation of the rowLimit or viewFields value, that is set to 1000. You should ask your Sharepoint administrator to allow your computer (or the Server where QlikView is hosted) to download more than that.

Hope that helps.

Miguel

Re: qlikview loading only 1000 rows from the XML file

qlikviewforum — Mon, 20 Aug 2012 14:11:36 GMT

Hi All

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: qlikview loading only 1000 rows from the XML file

Thu, 12 Jun 2014 07:26:57 GMT

Hi shans_bala , great you succeed to load data from share point using REST, I read the post which write by Pauljin Kochupyloth

How to Fetch a Sharepoint 2013 List using REST interface

but I still failed , so can you share you experience.

the link in the article says http://server/site/_api/web/lists/getbytitle(‘Title’)/Items

I don't know which portion should be changed? and how to get 'Title'.

Thank you very much.

David.