Categories
Does Oracle Analytics DV 7.6 Support Pagination for REST API Data Sources?
I am trying to connect Oracle Analytics DV to ServiceNow data using a REST API connection. However, the data volume is too large to retrieve in a single load. Does Oracle Analytics DV support pagination for REST API data sources? If so, how can I configure it to handle paginated responses from the API?
Any guidance or documentation references would be greatly appreciated.
Answers
-
As far as I know there isn't any setting for pagination of REST calls, and I doubt it does magically handle it (if it was the case, you wouldn't be asking).
The REST connector is still defined as "preview", therefore it's possible that support for pagination could be added in the future.
The best you can do for now is to search in to see if an idea to support pagination already exists and upvote it. If none exists, then post the idea.
1 -
Thanks @Gianni Ceresa. I just posted an idea on the Idea lab
Add Native Support for REST API Pagination in Oracle Analytics DV (OAS/OAC) — Oracle Analytics
0 -
The timing is maybe going to play against you: the OAS 2025 release is probably being packaged right now, therefore even if they do implement the feature, you will not have it in OAS before 2026. But at least it's there.
I imagine support for pagination can be handled by some attributes of each end point, because every REST API could have decided to handle it slightly differently. Therefore, technically possible, all a matter of priorities…
0 -
True! :-( Till then, I can use some other workaround of using an Oracle Database (or another staging area) to fetch paginated API data before loading it into DV
0
