HTTPS integration using UTL_HTTP

Hi Daab,  Hope you are doing good :)

Open the wallet using wallet manager and check all the certificates in the chain are imported. Probably the error due to certificate chain is not completely imported.

Cheers!

Damith

Hi DJ,

Its good to hear from you. Hope you are dong good and safe.

Yes I have created all the entries. Please see below screen.

Do you see any other issue on this? This is how I set the wallet.

UTL_HTTP.set_wallet('file:' || 'C:\\Wallet', 'Wallet123');

http_req_ := utl_http.begin_request(url_, 'POST', 'HTTP/1.1');
 UTL_HTTP.set_authentication(http_req_, 'xxx', 'xxxx');
 utl_http.set_header(http_req_, 'Content-Type', 'application/x-www-form-urlencoded');
 utl_http.set_header(http_req_, 'Content-Length', length(soap_request_));
 utl_http.write_text(http_req_, soap_request_);

The request is working through Postman.

Appreciate if you could share some thought on this.

thanks !

HI DJ,

Thanks for this. Now I can connect. 

I am getting below error as the response. 

HTTP Status 401 – Unauthorized

The request has not been applied because it lacks valid authentication credentials for the target resource.

Below is the code.

url_                  VARCHAR2(30000):= 'https://qa-tinsight.mercurygate.net/MercuryGate/common/remoteService.jsp';

UTL_HTTP.set_wallet('file:' || 'C:/Wallet', 'Wallet123');

http_req_ := utl_http.begin_request(url_, 'POST', 'HTTP/1.1');
 UTL_HTTP.set_authentication(http_req_, 'xxx', 'xxxx');
 utl_http.set_header(http_req_, 'Content-Type', 'application/x-www-form-urlencoded');
 utl_http.set_header(http_req_, 'Content-Length', length(soap_request_));
 utl_http.write_text(http_req_, soap_request_);

The request is working through Postman with valid credentials.

Is there a specific way to pass the credentials?

/DAAB

Nice to here that the certificate problem is solved :)

Does your API needs basic authentication or something else (like api key)?

As I know UTL_HTTP.set_authentication sets the basic authentication header.

Best thing is to check the request headers in Postman code snippet and add them in the request with utl_http.set_header

Eg:

Cheers!

Damith