on 02-05-2022 3:31 PM
Hi Experts,
I am trying to read data from a particular OData entity which is having approx~2 Lakh records. But I am not able to read the data. I have used $top and $skip parameters in the OData read call. I am getting the following error:
{"code":"BadRequestException","message":"The request count exceeds the maximum request count allowed : 180","persistent":false,"targets":["/$batch"],"type":"Error"}] sap.ui.model.odata.ODataMessageParser
I need to read the data in advance so that I can implement some logic as per my requirement. Can you please suggest some solution to overcome this error and read the data.
With Regards,
Partha.
Interesting to learn about the unit of Lakh which seems to stand for 100.000.
This service is telling you that you can request a maximum of 180 records. So you should use $skip and $top to read all the records step by step.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Gregor,
Thanks for the reply.
I have tried using $top and $skip in Url Parameters. I am using $skip=0 and $top= 180 and increasing $skip every time by 180 so as to fetch 180 records at a time by looping over entire records. . But still getting the same error. Is there something I am missing out? Please provide your inputs on this.
With Regards,
Partha.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.