Skip to Main Content

APEX

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Apex web service REST call returning null

User_8849SFeb 18 2022

Hi,
I'm calling Fusion REST API using apex web service but it's returning null in the response.
Can u pls provide the solution for this? But it's working POST MAN
Code:
declare
l_clob clob;
L_RESCLOB CLOB;
begin
L_RESCLOB:='{
"OperationName":"uploadFileToUCM",
"DocumentContent":"UEsDBBQAAAAIABCInEgIHJSKCgAAAAgAAAAIAAAAdGVzdC50eHRzTEpWCEktLgEAUEsBAh8AFAAAAAgAEIicSAgclIoKAAAACAAAAAgAJAAAAAAAAAAgAAAAAAAAAHRlc3QudHh0CgAgAAAAAAABABgAW4FRYEGh0QEBIE9gQaHRAckeCWBBodEBUEsFBgAAAAABAAEAWgAAADAAAAAAAA==",
"DocumentAccount":"fin$/payables$/import$",
"ContentType":"zip",
"FileName":"Testtt.zip",
"DocumentId":null
}';
l_clob := apex_web_service.make_rest_request(
p_http_method => 'POST',
p_username => *given the user name*,
p_password =>*given the pwd *
p_url => *HOST*||'/fscmRestApi/resources/11.13.18.05/erpintegrations',
--p_http_method => 'POST',
p_body =>L_RESCLOB,
p_wallet_path =>*given then path*
);
EXCEPTION WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('ERROR- '||SQLERRM);
end;

Comments
Post Details
Added on Feb 18 2022
2 comments
182 views