Hi,
First of all I would like to say that the “Similar Posts” feature is awesome, I guess it saved many users from creating a new post!
Unfortunately it did not find a similar post for my issue:
- We are using APEX 23.2 so I can luckily use the new ODATA data source type to connect to our internal API market place.
- I was told that the specific REST source uses ODATA v2.
- Tests with Postman showed that the $skip and $top work fine which is expected since there is no difference between v2 and v4 in regards to these operations
- Therefore I checked the “Results pagination” :
- but I only get the first 180 rows shown in the sync log details: https://….CICCTREntitySet?$skip=0&$top=180
- if the solution lies in the steps feature the docu is unfortunately not very detailed: https://docs.oracle.com/en/database/oracle/apex/23.2/htmdb/managing-data-synchronization.html#HTMDB-GUID-A6E59B18-A41A-4604-9C15-5426C8732E18
- so the question is how can you use the pagination for an ODATA source to get all the 125k rows of this service
- important to mention: if I configure the same webservice as simple http and use this pagination setting it works fine and fetches all rows successfully!
- for the ODATA data sync I use HTTP request limit 1000 and tried with and without simple rate limiting
Any hint is highly appreciated!!
Thanks a lot in advance.
Regards,
Stefan