HTTP_POST_VERBOSE and HTTP_POST_BLOB_VERBOSE
The HTTP_POST_VERBOSE or HTTP_POST_BLOB_VERBOSE table function updates a text-based resource under the specified URL through an HTTP POST request. It returns a one row table that contains the normal HTTP response for the request and the header information returned from the HTTP request.
- url
- An expression that returns a built-in character string or graphic string data type that specifies the URL of the resource being accessed.
- request-message
- An expression that specifies the data to update at the specified URL.
- options
- An expression that returns a built-in character string or graphic string data type. This string must be formatted as a JSON object containing the options, including headers, for the request. See HTTP options for the list of options.
The result of the function is table containing a single row with the format shown in the following table.
Column name | Data type | Description |
---|---|---|
RESPONSE_MESSAGE |
CLOB(2G) CCSID 1208 for
HTTP_POST_VERBOSE or BLOB(2G) for HTTP_POST_BLOB_VERBOSE |
The HTTP response for the request. |
RESPONSE_HTTP_HEADER | CLOB(2G) CCSID 1208 | Header information returned from the HTTP request, formatted as specified by the verboseResponseHeaderFormat option. |
Notes
For more information about using the HTTP functions see HTTP functions overview.
Example
- Send a HTTP POST request to https://www.example.com/users sending 'ABC' and using the
certificate store /home/javaTrustStore/fromJava.KDB. Return the result and header
information.
SELECT * FROM TABLE(QSYS2.HTTP_POST_VERBOSE( 'https://www.example.com/users', 'ABC', '{"sslCertificateStoreFile":"/home/javaTrustStore/fromJava.KDB"}'));