6 Enabling Data Exchange with RESTful Services
RESTful Services enable the declarative specification of RESTful services used to access the database.
RESTful Services enable the creation of a set of standards-based API’s on top of database objects available for a workspace. Without connecting directly to the underlying data source, these API’s allow external systems to interact securely with the data by querying, inserting, updating or deleting.
Prior to release 18.1, the definitions of RESTful services created within Oracle Application Express were stored within the metadata tables of the core Application Express schema. Starting with release 18.1, Oracle recommends migrating of all RESTful services to the Oracle REST Data Services (ORDS) repository. This migration makes it easier to manage RESTful services in a single place using a multitude of tools, including Application Express, SQL Developer, SQL Plus, SQLcl, and so on.
This section introduces you to the concepts of RESTful services and describes how to create, edit and delete RESTful Services using Application Express.
Note:
Your workspace administrator controls whether RESTful services are enabled. If disabled, the RESTful Services icon does not display.
- About Oracle RESTful Services in Application Express
This section introduces RESTful Services as implemented by Oracle REST Data Services (ORDS) and provides clarification on the terminology used within Application Express and other Oracle tools to reference the different components that make up a RESTful Service. - Enabling REST Objects from the Object Browser
Enable REST objects from Object Browser with the REST tab. - Enabling Authorization for REST Enabled Objects
Restrict access for REST enabled objects on the REST tab in Object Browser. Use the resulting Authorization Role information to configure user roles in ORDS. - How to Access RESTful Services
Access RESTful Services from SQL Workshop. - How to Create the ORDS Based RESTful Services Module Example
Learn how to create the ORDS Based RESTful Services module example. - Managing RESTful Service Modules
Learn how to install sample RESTful service module, You can create ,edit, and delete an ORDS RESTful service module. - Managing Resource Templates
Resource templates are a means of grouping URIs and associating them with a particular RESTful Service Module. - Managing Resource Handlers
A resource handler is a query or an anonymous PL/SQL block responsible for handling a particular HTTP method.
See Also:
"Controlling RESTful Services for a Workspace" in Oracle Application Express Administration Guide