Hi all,
I’m working on a use case where I need to consume a paginated REST API inside Oracle APEX. The API returns data in chunks (e.g., 50 rows per call) and includes a next URL or a pagination token in the JSON response.
I hav set up a Web Source Module and while the initial page of data loads fine I m not sure how to fetch subsequent pages automatically or on demand.
Here are a few questions I’m hoping the community can help with:
1.Is there a way to handle pagination declaratively using Web Source Modules?
2.If not whats the best pattern to loop through all pages of the API response using PL/SQL?
3.Has anyone successfully combined APEX_WEB_SERVICE.MAKE_REST_REQUEST with token-based or offset-based pagination in a loop?
4.Are there performance concerns or limitations I should keep in mind?
Would really appreciate examples or approaches that worked for others