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!

apex_web_service.make_rest_request not always working....

Geert01Jan 2 2023

Happy new year!!!
My new year started with a problem that only arrises when trying to execute a web service with a parameter with some special characters. The service works fine in 95% of the cases but only with speciale characters I run into problems I cannot solve.
image.png
I am using an API to test the existance of a the above shown record.
Both using Postman and Curl I get the result I need:
image.pngimage.png
But only when I call the Api with
l_clob := apex_web_service.make_rest_request
( p_url => l_url
, p_http_method => 'GET'
, p_body => NULL
);
using the exact same url, I get:
"data": []

The url I use is:
https://eu.spm.varicent.com/api/v1/customtables/spCPCChannel/inputforms/0/data?fields=ChannelName,StartDate&filter=ChannelName%3DÉÉN%3BStartDate%3D01%2F01%2F2017
I tried using apex_util.url_encode but this does not have an effect on the string:
image.png
What could cause this?

This post has been answered by Geert01 on Jan 24 2023
Jump to Answer
Comments
Post Details
Added on Jan 2 2023
5 comments
990 views