Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to trace apex_web_service.make_rest_request?

Andi77Jan 19 2022

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

Comments
Post Details
Added on Jan 19 2022
0 comments
454 views