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

wizard

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.

thatJeffSmith-Oracle

What more can you say about your service?

I have an AUTOREST enabled table, with more than a thousand records...here's I'm grabbing 1025 in one go.

wizard

Hi Jeff,

Appreciate your response I am aware that limit and offset option but my concern is if table having 2 lakhs records and user want to see fetch all those records how we achieve that.

My concerns is how exactly this limit works suppose how will it fetch next 1000 records again we don't want to specify and hardcoding like limit=1000 etc.?

thatJeffSmith-Oracle

I'm confused, you said you couldn't fetch more than a 1,000 records, and I showed how you can.

No user ever wants more than a few records at a time. It's why paging was invented :)

Explain your use case.

wizard

if user wants to export the whole table data(2 lakh+ rows) not only 1000 rows then how it would be work using rest endpoint ?

paging is this any parameter we can pass in rest url?

thatJeffSmith-Oracle

if you want to export the whole dataset by REST API then write out a file and download it

wizard

how to write out and download it from vbcs ui

thatJeffSmith-Oracle

write some plsql and use owa calls

I have blog posts...

https://www.thatjeffsmith.com/archive/2021/03/downloading-streaming-content-with-ords-file-downloads/

That's for a LOB, your pl/sql code will instead build up a json file using JSON functions in the database.

Once you have the API going, it's up to you and VBCS how to make use of it