APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Duplicate data and other strange behaviors of report regions based on REST data source

Eslam_ElbyalyMay 21 2023

Hi. I am using APEX 22.2.4.

I've created a rest data source for the following endpoint https://ipapi.co/json with https://ipapi.co set as the remote server and “/json” as the path prefix.

When creating a classic report based on that data source, it shows error ORA-20999: REST Data Source returned an HTTP error: APEX.WEBSRC.HTTP415.

When basing on Interactive Report, it gets duplicated data.

When debugging, it sends 51 GET requests like the following one https://ipapi.co/json?offset=50&limit=51.

Every request has the limit parameter minus 1 i.e https://ipapi.co/json?offset=50&limit=50

https://ipapi.co/json?offset=50&limit=49

and so on.

2- When changing default pagination of IR to x to y of z, it does not show the z(the total of rows).

Added on May 21 2023

14 comments

1,460 views

1 mention