Hi I am facing issue while fetching ORDS records limit more than 1000

Summary:

Hi , I am trying to fetch all tables records from ATP database using ORDS service but I am only getting 1000 records after setting ?limit=1001&offset=25 when I tried to fetch all records it fails or not fetch all records and gives below error.

Desire Result:

Want all the table data (either 1000 or 50 lakh) using ORDS service and want to show in VBCS table or in postman.

Code Snippet (add any code snippets that support your topic, if applicable):

{
    "fault": {
        "faultstring": "Body buffer overflow",
        "detail": {
            "errorcode": "protocol.http.TooBigBody"
        }
    }
}