Using the api3 with a proxy inside a company network using SAS EG

[Simon Etter]

Hi all, 

I'm trying to geocode adresses from inside the network of my company, which uses a proxy where I need to identify with username and PW. I have the necessary information from our webadmins. I do not have a lot of experience using SASEG but so far I have the code below: 

filename out "filepath\test.txt";

/*options set=SSL_USE_SNI=1*;

options set=SSL_SNI_HOSTNAME="https://api3.geo.admin.ch"; */

proc http

method='GET'

url = "https://api3.geo.admin.ch/rest/services/api/SearchServer?searchText=Bahnhofstrasse 1 Zürich&type=locations"

proxyhost = 'OUR WEBPROXYSERVER'

proxyport = 8080

proxyusername = 'MYUSERNAME'

proxypassword= 'MYPASSWORD'

out= out;

run;

The error message that I get is: 

ERROR: Secure communications error status 807ff019 description "SSL Error: Invalid subject name in partner's certificate. Subject 

       name must match machine name."

ERROR: SSL Error: Invalid subject name in partner's certificate. Subject name must match machine name.

ERROR: Call to tcpSockContinueSSL failed.

The commented lines 2&3 in the code are based on an online resource here https://support.sas.com/kb/64/218.html, which is the only place where I found a potential solution to my problem. It says that I need a SNI, which, as far as I understand should be provided by swisstopo? However, I have not found anything to help me here...

Any help is appreciated!

[Marc Monnerat]

Hello Simon,

I don't know anything about SAS, but maybe try, something like (apparently, the variable is spelt like that)

options set SSLSNIHOSTNAME=api3.geo.admin.ch

Regards,

Marc

--
You received this message because you are subscribed to the Google Groups "GeoAdmin API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to geoadmin-api...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/geoadmin-api/5d5a3bb4-c7ea-413b-a13f-49464cfdb177n%40googlegroups.com.

[Simon Etter]

Hi Marc, thanks that helped a lot! 
Btw: In case anyone is interested about a code example on how to retrieve the data inside a loopy you might be interested in this question on stackoverflow: https://stackoverflow.com/questions/64916718/how-can-i-send-receive-and-collect-data-to-and-from-api-in-a-loop-in-sas-eg