Add Native Support for REST API Pagination in Oracle Analytics DV (OAS/OAC)

Dhaval Parikh Stantec

Oracle Analytics DV currently allows users to connect to REST APIs as data sources. However, it lacks built-in support for handling paginated responses.

Currently, users must rely on external databases, ETL processes, or scripting to retrieve all paginated data before loading it into DV. This workaround increases complexity and limits real-time API connectivity.

I would like to propose enhancing the functionalities of Oracle Analytics DV by adding native support for pagination when connecting to REST API data sources. This could include:

• Support for common pagination methods: offset/limit, cursor-based, and page/size.
• Dynamic URL parameter handling: Allow users to specify pagination parameters dynamically.
• Automated multi-page fetching: Fetch and merge paginated data automatically within DV.
• User-configurable options: Define max records per request, total records to retrieve, and stopping conditions.