Hi
I am attempting to build an APEX app including data from a schema (not the one the app is linked to) that has been REST enabled.
I can POST the service passing sql statements using a "curl" command on the server. I can do the same using a REST client (Insomnia).
This is an example of the URL "http://<host>/<ORDS war file>/EDW/edw_myit_service/_/sql"
Trying now to use this in APEX and have created "REST Enabled SQL" service - using the same URL and using the same credentials used in the tests above that worked. When I test I get the following:
"The URL of this remote server does not point to an REST Enabled SQL Service. Please check the details of your REST Enabled SQL Service definition."
Something I have missed? Any way to debug and see whats causing the problem?
Thanks