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 trigger a HTTP POST API using pl/sql in APEX

Vaibhav InamdarJul 26 2022

Hi Team
we are trying to trigger a HTTP post api using pl/sql in an page process
declare
l_var clob;
begin
apex_web_service.g_request_headers (1).name := 'Content-Type';
apex_web_service.g_request_headers(1).value := 'application/json';
l_var := apex_web_service.make_rest_request(
p_url => 'http://152.64.2.31:3443/sendNotification',
p_http_method => 'POST',
p_body =>'{
"botid": "29:1IZFoCAr7zGR8kYgj3v-6fKd3ROl7mikkIPgtHyeq6H2xH1uuNh4_FCXi12HB-4XDI4mF2DI0kVHHPhmcayRslg"
}');
dbms_output.put_line(l_var);
end;

the following code gives an 'ORA-20987: The requested URL has been prohibited. Contact your administrator.' Error
we have also granted the necessary ACL's.
Is there any way to trigger an unsecured API in APEX ?

This post has been answered by Carsten Czarski-Oracle on Jul 27 2022
Jump to Answer
Comments
Post Details
Added on Jul 26 2022
3 comments
2,446 views