HTTP response message null when HTTP Status Code >= 300
Subject: HTTP response message null when HTTP Status Code >= 300
From: Mihael Schmidt <mihael@xxxxxxxxxxxxxx>
Date: Tue, 15 Jan 2019 18:06:57 +0100
Arc-authentication-results: i=1; mx.google.com; dkim=pass header.i=@rpgnextgen.com header.s=20140924 header.b=ArR8Oaj3; spf=neutral (google.com: 46.30.212.10 is neither permitted nor denied by best guess record for domain of mihael@xxxxxxxxxxxxxx) smtp.mailfrom=mihael@xxxxxxxxxxxxxx
anybody some experience with the SQL HTTP functions? I am using
SYSTOOLS.HTTPGETCLOBVERBOSE. But how do I get the content of the
response message in an "error" case (f. e. HTTP Status Code 400 - Bad
Request)?
|exec sql SELECT responsemsg, responsehttpheader INTO :responseMessage
:responseMessageNull, :responseHeaderXml FROM TABLE(
SYSTOOLS.HTTPGETCLOBVERBOSE(:wsUrl, :requestHeader)) AS t; |||
Everything works fine if the HTTP response has a status >= 200 and < 300
but else I get null in responsemsg. How do I get the message content
when the HTTP response is not ok (HTTP status code >= 300)?
... and yes, the web service really returns data in the message body. I
made the same request with curl.
Thanks in advance.
Mihael
||
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
