Hi, we have local APEX environment hosted on Azure servers. when i try REST API Call from DB using APEX_WEB_SERVICE.MAKE_REST_REQUEST I am getting a response but when I configure the same url through APEX UI using rest data sources i am getting an error. kindly advice on how to resolve the errors.
DB Call:
declare
l_clob CLOB;
l_response_msg CLOB;
BEGIN
l_clob := APEX_WEB_SERVICE.MAKE_REST_REQUEST(
p_url => 'https://server.fa.ocs.oraclecloud.com/fscmRestApi/resources/11.13.18.05/supplyChainPlans/',
p_http_method => 'GET',
p_username => 'SYKDMADMININT',
p_password => 'xxxxxx'
);
dbms_output.put_line(apex_web_service.g_status_code);
dbms_output.put_line(apex_web_service.g_reason_phrase);
dbms\_output.put\_line(dbms\_lob.substr( l\_clob, 4000, 1 ));
END;
response :
200
OK
{
"items" : [ {
"MeasureCatalogForArchival" : 300000006583812,
"MostRecentDaysToKeep" : null,
"ArchiveTimeHierarchy" : 17,
"ArchiveTimeLevel" : 52,
"BasePlanId" : 300000007409619,
"PlanName" : "TX - SYK ……………….
APEX UI:
