Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
levente81
Partner - Contributor III

Odata in Qlik cloud

Hi,

I am expected to fetch data using an Odata connection.

I face an issue due to relatively big data should be fetched: I get an error message: "Connector error: Exception of type 'System.OutOfMemoryException' was thrown."

Is there any way to loop through 'pages' of the Odata report? How can I ensure that certain Odata report offers such option at all?

How could I check what is the maximum limit that works well? I was told that current dataset is 500K records. 

How shall I modify the script to get only first 1000 records?

 

 

 

SELECT *
FROM GetData
WITH PROPERTIES (
oDataResourcePath='Data',
oDataQueryOptions='',
acceptContentType='',
maxResults=''
);

 

 

 

 Thanks in advance,

Levente

Labels (3)
1 Reply
fmarvnnt
Partner - Creator III