RE: HTTP response message null when HTTP Status Code >= 300

Does this give anything useful?
EXEC SQL GET DIAGNOSTICS EXCEPTION 1 :Msg = MESSAGE_TEXT;



-----Original Message-----
From: Mihael Schmidt [mailto:mihael@xxxxxxxxxxxxxx]
Sent: Tuesday, January 15, 2019 11:07 AM
To: RPG programming on the IBM i (AS/400 and iSeries) <rpg400-l@xxxxxxxxxxxx>
Subject: HTTP response message null when HTTP Status Code >= 300

Hi folks,

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

||