Support for RESTful Services via APEX interface?

[GeorgDangl]

I'd like to ask you if it is somehow possible to use Thoth Gateway to access RESTful Services that are created via the SQL Builder interface in APEX when no ORDS instance is running?
When trying that currently, it just returns a Thoth Gateway error stating that the URL is not found.

Is this a configuration issue on my side (I did not configure anything more but the database connection) or does it not work without ORDS?

[mortenbra]

Support for REST is on the roadmap for the Thoth Gateway version 2.0.

This will basically involve having the gateway read the REST definitions from the Apex (or ORDS) schema, and try to match the requested URL against any of the defined templates. If there is a match, the gateway needs to execute the specified SQL or PL/SQL code, and return the results as JSON (or whatever format is specified in the endpoint definition).

I've been thinking of using the (nonstandard) "InvocationProtocol" parameter in the DAD configuration for this, as this currently supports "CGI" for the normal gateway (OWA) operation, and "SOAP" for automatic web services. Having REST services served via a separate DAD means that REST urls cannot be served on the same base path as Apex apps, but I don't see a problem with this in practice.

Thoughts and comments appreciated.