
Partner - Contributor III
2023-05-16
05:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
648 Views
1 Reply


Partner - Creator III
2023-05-16
09:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I guess there's a possible solution on this post: https://community.qlik.com/t5/Qlik-Cloud-Data-Integration/quot-System-OutofMemoryException-quot-appe...
FMa
FMa
628 Views
