Hi,
i didn't found any documentation / how to trace (tracepath) an apex_web_service.make_rest_request call.
Scenario is: contacting an OPEN_ID Service like MS AZURE.
MS Endpoints are:
login.microsoftonline.com
graph.microsoft.com
certificates and acls are configured.
I'm able to call this:
select apex_web_service.make_rest_request(p_url => 'https://graph.microsoft.com/v1.0/me/',p_http_method => 'GET') from dual;
but this is failing:
select apex_web_service.make_rest_request(p_url => 'https://login.microsoftonline.com/',p_http_method => 'GET') from dual;
error:
ORA-29273: HTTP request failed
ORA-06512: at "APEX_200200.WWV_FLOW_WEB_SERVICES", line 1157
ORA-06512: at "SYS.UTL_HTTP", line 1288
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_HTTP", line 651
ORA-06512: at "SYS.UTL_HTTP", line 1278
ORA-06512: at "APEX_200200.WWV_FLOW_WEB_SERVICES", line 1147
ORA-06512: at "APEX_200200.WWV_FLOW_WEB_SERVICES", line 1346
ORA-06512: at "APEX_200200.WWV_FLOW_WEBSERVICES_API", line 608
ORA-06512: at line 1
29273. 00000 - "HTTP request failed"
*Cause: The UTL_HTTP package failed to execute the HTTP request.
*Action: Use get_detailed_sqlerrm to check the detailed error message.
Fix the error and retry the HTTP request.
=> get_detailed_sqlerrm just says: ORA-24247: network access denied by access control list (ACL)
BUT - as soon as i add *.office.com to the acls - it's working fine.
As *.office.com is not documented as endpoint it was a "wild guess" to add this acl.
The question is - how do i get a grip on these things?
WHY do i need to add *.office.com
HOW can i trace the make_rest_request call to get the information that i need to add *.office.com