Hello,
I'm using a local installation of APEX 24.2, which I have set up to invoke other local APIs through ORDs. I'm now working on an APEX application, specifically one page, where I want to invoke one of my endpoints (resources) from my RESTful services.
When developing this endpoint (let's call it GetAllUsers), I tested it through Postman with no problem - it returned the 3 instances that I have in my local DB. I then created a REST Data Source to be able to call it within my application, and, once again, the test operation ran successfully, showing 3 instances.
I created an Interactive Grid region in my application (with a Blank with Attributes (No Grid) template), selected Rest Source and the correct corresponding Rest Data Source, and wrote this script for my post-processing:
select
ID,
NAME,
CREATEDAT,
STATUS
from #APEX$SOURCE_DATA#
where STATUS = 2
FETCH FIRST 5 ROWS ONLY
I defined ID as my PK, and made it a hidden value.
When I load my page, the interactive grid repeats the 3 instances I have in my DB in a constant loop - if I select the scroll type pagination, the grid will continually load the same instances over and over again. If I select the page type pagination, I have the same issue.
I've been searching for some way to solve this, with no luck so far. Is there some other configuration I'm missing? I also tried to populate the interactive grid by creating a collection through a process upon loading the page, but the page wouldn't even load - it was stuck in an infinite loop.
Thank you!