Is there a limit on how many rows LoopbackJS/Oracle can retrieve using the REST API?

Question

I am using LoopbackJS and Oracle Database. In the GET APIs, I am able to retrieve a maximum of 3000 results as Array in response. Is there any way to increase the fetch size?

Answer 1

In the loopback, the server/datasources.json file has a db object, in which the maxRows property is for defining the maximum limit to retrieve from the database(using oracledb npm). The default value is 3000. Refer here