Oracle APEX stores REST Data Source server information (for example, REST APIs) as a Remote Server object. Remote Servers can be shared among multiple REST Data Sources. Changing Remote Server properties affects all REST Sources referencing that object. For example, you can change a Remote Server's Base URL to move all associated REST Sources from a test to a production system. Since Remote Servers are stored at the workspace-level, Remote Servers are visible in all applications in a workspace.

When you create a Remote Server you select one of the following Sever Types:

• REST Data Source - A Remote Server for consuming a remote REST API.

• Authentication - A Remote Server used for authentication.

• Print Server - A Remote Server for an external print server. You can create a Print Server in your workspace and use it in an application. By default, the print server configuration at instance level is used.

• File Server - A Remote Server for remote file storage.

Flexible Remote Server works as follows:

• When the REST Data Source is invoked, the APEX Engine evaluates the Remote Server, Configuration Procedure attribute.
• If the Configuration Procedure attribute has a value, either stored in the database or in an anonymous block in the PL/SQL Code attribute, the APEX Engine executes the procedure to fetch a collection of substitution parameters that are then used to change the Endpoint URL.

Flexible Remote Server Use Cases

Common use cases for using a Flexible Remote Server include:

• Environment dependencies - A Flexible Remote Server is a good choice when the environment is dependent upon where the server or application is deployed (for example, in production, test or development instances). Instead of manually changing the Endpoint URL attribute on the Edit Remote Server page for each environment, you can use an API to change it dynamically.

  Tip:

  You can also use APPLICATION_ADMIN.SET_REMOTE_SERVER procedure to change the Endpoint URL in a deployment script. See SET_REMOTE_SERVER Procedure in Oracle APEX API Reference

• Application data or the application user dependencies - A Flexible Remote Server enables you to use the Configuration Procedure attribute to change the Endpoint URL at runtime depending on dynamic parameters. These dynamic parameters are flexible and can be based on a configuration table, items in Session State, Application Items or Substitution Items.

  The results of the Configuration Procedure are cached and reused within the same request (page view or page processing).

Configuring a Flexible Remote Server

To configure a Flexible Remote Server, edit the Remote Server and enter a procedure name in the Configuration Procedure attribute. This procedure can be the name of a procedure stored in the database, stored in a database package procedure, or a procedure stored in the PL/SQL Code attribute.

This signature of the procedure must have two parameters of type:

• p_info in apex_plugin.t_remote_server_info
• p_config in out apex_plugin.t_remote_server_config

The parameter p_config has two optional attributes which can be changed in the configuration procedure:

• p_config.base_url - base_url changes the Endpoint URL.
• p_config.substitutions - substitutions assigns name/value pairs using apex_t_varchar2. Oracle APEX substitutes each #NAME# in the base url or Endpoint URL.

Together these two attributes determine the actual Endpoint URL the Remote Server uses.

The following example changes the base URL if the application ID is 100:

procedure my_server_config(
  p_info    in  apex_plugin.t_remote_server_info,
  p_config  out apex_plugin.t_remote_server_config )
is
begin
  if v('APP_ID') = 100 then
    p_config.base_url := 'http://example100.com';
  else
    p_config.base_url := 'http://example.com';
  end if;
end;

You can also can use placeholders by enclosing the "name" with the number symbol (#) and use substitutions to replace the value in those placeholders. Consider the following example:

procedure my_server_config(
  p_info in apex_plugin.t_remote_server_info,
  p_config out apex_plugin.t_remote_server_config )
is
begin
  p_config.base_url := 'http://example#app_id#/#tenant#.com';
  p_config.substitutions := apex_t_varchar2();
  apex_string.plist_put( p_config.substitutions, 'app_id', v('APP_ID') );
  apex_string.plist_put( p_config.substitutions, 'tenant', v('TENANT') );
end;