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

qlikview loading only 1000 rows from the XML file

Hi,

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

5 Replies
Miguel_Angel_Baeyens

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

Not applicable
Author

Hi,

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

Miguel_Angel_Baeyens

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

qlikviewforum
Creator II
Creator II

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

Not applicable
Author

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.