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=''
);
