Odata in Qlik cloud

levente81 — Wed, 19 Mar 2025 23:04:08 GMT

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

topic Odata in Qlik cloud in Data Movement & Streaming

Odata in Qlik cloud

Re: Odata in Qlik cloud