You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Received Response
edited Apr 14, 2022 5:53AM in Visual Builder 3 comments


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 to fetch 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"

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!