18.4.2 Creating a REST Data Source

Create a REST Data Source from Shared Components.

To create a REST Data Source:

  1. Navigate to the REST Data Sources page:
    1. On the Workspace home page, click App Builder.
    2. Select an application.
    3. On the Application home page, click Shared Components in the center of the page.
    4. Under Data Sources, select REST Data Sources.
  2. On the REST Data Sources page, click Create.
  3. For Method - Select From Scratch and click Next.


    If you select, As copy of an existing REST Data Source select the application to copy from and follow the on-screen instructions.
  4. For General:
    1. REST Data Source Type - Select one of the following:
      • Simple HTTP - Denotes a simple HTTP data feed. Application Express assumes that all data is returned with the first request and that the server does not support server-side filtering, ordering or other advanced REST service feature. All invocation details and parameters must be configured manually. Use this type if the REST service is neither an ORDS or Oracle Cloud SaaS service (see below).
      • Oracle REST Data Services - Denotes ORDS (Oracle REST Data Services) REST Services. These REST services follow the Oracle REST standard, which means that GET, POST, PUT or DELETE operations are standardized. Server-side filtering and ordering are supported. Application Express can leverage these features by delegating report order-bys and filters to the REST service.
      • Oracle Cloud Applications (SaaS) REST Service - Denotes RESTful web services provided by Oracle Cloud SaaS Applications. Use this web service type to integrate Oracle SaaS REST Services into your Application Express Application. Application Express supports pagination for these Services.
      • Oracle Cloud Infrastructure (OCI) REST Service - Denotes RESTful web services provided by Oracle Cloud Infrastructure. Use this web service type to integrate OCI REST Services (for example, accessing the Object Store) into your Application Express application. Application Express supports pagination for these Services. This Type requires Oracle Application Express is installed in Oracle Database 18c or later.
    2. Name - Enter a descriptive name for this REST Data Source.
    3. URL Endpoint - Enter the Endpoint URL (starting with http:// or https://) for this REST Data Source.


      Do not add query string parameters by appending ?name1=value&name2=value. These are configured on the Advanced wizard page after you configure Authentication.

    4. HTTPS Host Name - The host name to be matched against the common name (CN) of the remote server's certificate for an HTTPS request. It can also be a domain name like *.example.com. If NULL, the host name in the given URL is used.
    5. Click Next.
  5. Remote Server:
    1. Remote Server - Choose an existing Remote Server object. The HTTP Endpoint URL of a REST Data Source consists of the remote server (Base URL) and the service specific part. Remote Servers are stored as separate Entities. When multiple REST Data Sources share the same remote server, they can easily be redirected to another physical location (for example, from test to production) by just changing the base URL within the Remote Server definition..
    2. Base URL - This is the Base URL of the chosen Remote Server object. The HTTP Endpoint URL of this REST Data Source is made up from the Base URL and the service-specific path suffix below..
    3. Service URL Path - Enter the service-specific URL Path for this REST Data Source. The HTTP Endpoint URL is built by appending this to the Base URL specified in the Remote Server object.

      For example:

      • /services/customers/

      • /products/4711/details

    4. Click Next.
  6. For Authentication Required, choose whether the new REST Data Source requires Authentication.


    To learn more about authentication, see "About Supported Authentication Types" in "About Credentials"

  7. To proceed, select one of the following:
    • Create REST Source Manually - This option does not include Discovery mode. Based on the previously entered information, a REST Data Source is created with a few sample operations and a sample data profile. This option creates an incomplete REST Data Source that is unusable with an Oracle Application Express component. To correctly reflect the external web service, you will need to edit the operations and the data profile.
    • Advanced - Presents advanced parameters for the Data Profile. Use Response Sample to upload a sample JSON (or XML) response. Once a file is uploaded, Oracle Application Express performs a Data Profile Discovery on the uploaded file.
    • Discover - Starts Discovery mode. Oracle Application Express executes multiple HTTP requests in order to get information about the external Web service. Application Express samples the data (JSON or XML) returned by the Web service and derives a Data Profile (consisting of metadata about the JSON attributes). Discovery results then display and confirms whether to create the REST Data Source.
  8. If you click Advanced, the Parameter page appears.
    Use the Parameters page to configure initial REST Data Source parameters which might be required for discovery. Some REST Data Sources may require you set specific HTTP Headers (for example, User-Agent). After setting advanced parameters, select either Create REST Source Manually or Discover.
  9. If you select Discover, Application Express invokes the REST service URL and a Preview appears. From the JSON response, Application Express derives attributes and their data types and uses this to create a Data Profile.

    The information that displays depends upon the complexity of the target service. For simple HTTP services or ORDS services which do not provide metadata about their JSON response attributes, Application Express investigates the JSON or XML response, samples the data, and creates a proposal for a data profile. The Data tab displays the sample response data, formatted as a report.

    The columns tab shows information about the data profile columns Application Express has found during discovery. Use this tab to verify whether the column data types are correct.

    Click Server Response to view additional detailed information about the REST Data Source response, such as the response body, response headers and the REST Data Source operations.

  10. Click Create REST Data Source.
    The REST Data Source is created.