Retrieve more than 20.000 records from OData4 Account table
Hi Community,
In the OData4 protocol the maxTopLimit parameter
defines the limit for the value in the maximum number of rows in the output (which is 20.000 records)
We are retrieving the data from the Accounts table which has around 40.000 records.
What is the workaround or fix for this scenario?
Sasor
Like
You can use the $top and $skip parameters to retrieve the data in pages.
For example:
Page 1 (first 1000)
https://creatiourl/0/odata/contacts?$top=1000&$skip=0
Page 2 (next 1000)
https://creatiourl/0/odata/contacts?$top=1000&$skip=1000
Page 3 (next 1000)
https://creatiourl/0/odata/contacts?$top=1000&$skip=2000
etc
Ryan
You can use the $top and $skip parameters to retrieve the data in pages.
For example:
Page 1 (first 1000)
https://creatiourl/0/odata/contacts?$top=1000&$skip=0
Page 2 (next 1000)
https://creatiourl/0/odata/contacts?$top=1000&$skip=1000
Page 3 (next 1000)
https://creatiourl/0/odata/contacts?$top=1000&$skip=2000
etc
Ryan