HTTPGETBLOBVERBOSE and HTTPGETCLOBVERBOSE table functions

The HTTPGETBLOBVERBOSE and HTTPGETCLOBVERBOSE REST table functions retrieve a binary or text-based resource from the specified URL through an HTTP GET request. They return a one row table that contains the normal HTTP response for the request and the header information returned from the HTTP request.

The schema is SYSTOOLS.

url: Specifies the URL at which to complete the request. This argument is defined as a VARCHAR(2048) CCSID 1208 value.
httpHeader: Specifies an optional header XML document. To use the default HTTP header, specify NULL or the empty string. This parameter is a CLOB(10K) CCSID 1208 or an XML value.; See Foundational HTTP functions for a description of the header content.

The result of the function is a table containing the following two columns.

Table 1. HTTPGETBLOBVERBOSE and HTTPGETCLOBVERBOSE result table
Column name	Data type	Description
RESPONSEMSG	BLOB(2G) or CLOB(2G) CCSID 1208 depending on which function is used	The normal HTTP response for the request.
RESPONSEHTTPHEADER	CLOB(1M) CCSID 1208 or XML based on the data type of the httpHeader argument.	Header information returned from the HTTP request.