Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.2K SQL Developer
- 295.4K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.1K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 27 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 391 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
Hi I am facing issue while fetching ORDS records limit more than 1000

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.
Answers
-
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.
-
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.?
-
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.
-
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?
-
if you want to export the whole dataset by REST API then write out a file and download it