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. 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.

• What Is REST?
  Representational State Transfer (REST) introduces the concepts of REST and discusses the difference between publishing and consuming REST services.
• About Oracle RESTful Services
  Discusses Oracle’s implementation of REST and the terminology used to describe the various components of RESTful services.
• RESTful Service Requirements
  Outlines the requirements for exposing RESTful services to external systems.
• How to Enable REST Objects from the Object Browser
  Access Object Browser from the Workspace home page by clicking SQL Workshop and then Object Browser.
• 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