Calling external web service https

[former_SQLA_member1694881]

Hi All,

SQL Anywhere server 12.0.1. There is a third-party (external) web service that is called via the https protocol https://xxx.xxx.xxx.xxx/Test

To begin with, I am making a simpler version - nttp

CREATE PROCEDURE "DBA"."WebTest2"(in nID integer ,in cDocDate char(10)) 
result (cAttribute long varchar, cValue long varchar) 
dynamic result sets 1
url 'http://xxx.xxx.xxx.xxx/Test?pID=!nID&pDocDate=!cDocDate' 
type 'HTTP:POST'

Here everything is working fine.

Now I need to call this service using the https protocol.

As for https - there is a keyword CERTIFICATE, it can specify a file with a certificate or a certificate key. But https://xxx.xxx.xxx.xxx/Test is a third-party web-service and I accordingly do not have its file with the certificate or the key of its certificate.

Question: What should I do ?

[VolkerBarth]

See that question, it applies to the newer 12.0.1 EBFs, as well, starting with 12.0.1.3994, IIRC.

In short: You need to trust the root certificate of the web server's certificate chain.