Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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 ?

asked 28 Sep '17, 14:03

Stalker's gravatar image

Stalker
515293151
accept rate: 11%


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.

permanent link

answered 28 Sep '17, 17:00

Volker%20Barth's gravatar image

Volker Barth
40.2k361550822
accept rate: 34%

edited 28 Sep '17, 17:04

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×438
×65

question asked: 28 Sep '17, 14:03

question was seen: 2,154 times

last updated: 28 Sep '17, 17:04