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

REST Data Source Fetching Only 25 Records in Oracle APEX – How to Retrieve All Records?

in Fusion Service

Summary:

I am currently working on building a dashboard in Oracle APEX using a REST Data Source to fetch data from an Oracle Database. However, I am facing an issue where the REST Data Source is returning only 25 records by default.

Due to this limitation, I am unable to retrieve the complete dataset required for creating accurate graphs and visualizations in the dashboard.

Could anyone please guide me on how to configure the REST Data Source or modify the setup to fetch all available records (or increase the record limit)? Are there any pagination settings, parameters, or best practices that need to be followed in this scenario?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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