Is there a way of retrieving the metamodel of all ORDS-enabled tables for a connection in a single hit? The URL http://<host>:<port>/ords/<user>/metadata-catalog returns the table names but I want their metadata (columns and so on) as I would find in http://<host>:<port>/ords/<user>/metadata-catalog/<table-name>. I could get the table names then fire off seperate URLs for each one but getting all this information in a single HTTP request would be preferable. I couldn't find documentation for supported URLs to access information through ORDS.
One option I explored while researching this leads to my second question. Is it sensible for me to write this as a java plugin for the deployed ords.war file? If so, is there are way of querying for ORDS-enabled tables only? What marks a table as being ORDS enabled? Is there something in the plugin API that shows this?
Many thanks for any help.
The metadata-catalog RESTful service works only for RESTful enabled tables and it has a particular behavior as defined in ORDS product documentation.
NOTE: This feature of ORDS 3.0 is known as AutoREST and is documented as above.
NOTE: This blog post demonstrates how to create JSON with relational data in Oracle DB. You could query table metadata dictionary viz. ALL_TABLES/ALL_TAB_COLUMNS to return what you want. You can use APEX based RESTful Web Service / ORDS based RESTful Web Service.