Hello,
What are the options to change Base URL for the “Workspace Utilities/Remote Servers” definition programmatically? APEX_APPLICATION_INSTALL.SET_REMOTE_SERVER api will allow needed functionality only during installation. But I am looking for the same during the use of the app. The requirement is for each tenant to provide their base URL for predefined rest sources (note: each tenant would get their workspace – no collision there). Tenants may decide to change their source server from A to B at any time + provide new credentials;
Note: APEX_WEB_SERVICE.MAKE_REST_REQUEST is not an option, due to heavy reliance on table synchronization + direct reports. Most calls are either done via APEX_REST_SOURCE_SYNC or EXECUTE_REST_SOURCE. The latter ones do not provide the ability to pass in the base url.
Any thoughts on implementing this requirement would be appreciated. Thank you.
Environment
Apex on OCI v22.1