Question Re: http:get username password in Technology Q&A

http:get username password

Former Member — Thu, 09 Nov 2017 15:35:57 GMT

I have a function to get data from a webservice. It seems to reach out for http, but for https it is throwing an error.

SET @CMD = STRING('https://username:password@website.com/jsoncmd?timeRange=11/06/2017%2000:05~11/06/2017%2000:09')

SET @RET = f_dans_web_client_function(@cmd)

error is The URI https://username:password@website.com/jsoncmd?timeRange=11/06/2017%2000:05~11/06/2017%2000:09 is invalid SQLCODE=-980, ODBC 3 State="HY000"

But I can do this http to other sites. And my URL works if I put it into a browser

Re: http:get username password

MarkCulp — Fri, 10 Nov 2017 13:04:57 GMT

I think more context is needed in order to answer your question. For example, what is the definition of f_dans_web_client_function()?

Re: http:get username password

Former Member — Mon, 13 Nov 2017 11:13:39 GMT

Here is the definition of the function:

ALTER FUNCTION "TM38"."f_dans_web_client_function"( in iScriptName varchar(500) ) 
returns long varchar
url '!iScriptName' type
'HTTP:GET'

Re: http:get username password

justin_willey — Mon, 13 Nov 2017 13:01:08 GMT

That function doesn't look complete

Re: http:get username password

Former Member — Mon, 13 Nov 2017 14:32:58 GMT

Well it does not for non HTTPS request, but seems to have trouble for SSL, not sure what else I need to do, thanks

Re: http:get username password

Vlad — Mon, 13 Nov 2017 14:50:18 GMT

Typical problems with these web services is that SA doesn't trust the CA certificate, that signed your present certificate. But I just suspect this.

What I'd like to mention here is that these errors are really meaningless. Read useless. E.g. -980 means that "URI %1 is invalid" (http://dcx.sap.com/index.html#sqla170/en/html/80ee43166ce21014869afb4a5e70a0ea.html). What does it mean invalid?! It might be that it doesn't fit into RFC 3986, or the username/password contain wrong characters, the certificate is wrong, the URL is not encoded... everything!

I remember I used another DB that showed the error "Invalid View". What does it mean?! Is it really difficult to write a proper error message?!

Sorry guys, but I think the error message are the most important things in the software.

Re: http:get username password

VolkerBarth — Tue, 14 Nov 2017 03:23:39 GMT

Your https call is missing a CERTIFICATE clause, cf. that question.

In contrast to your browser, SA web client functions need to explicitly specify the certificate of the according web server.