HTTP_PUT and HTTP_PUT_BLOB
The HTTP_PUT or HTTP_PUT_BLOB scalar function retrieves a text-based resource from the specified URL through an HTTP PUT 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 HTTP_PUT function is CLOB(2G) CCSID 1208 containing the response message. The result of the HTTP_PUT_BLOB function is BLOB(2G) containing the response message.
Notes
For more information about using the HTTP functions see HTTP functions overview.
To return the header information from the HTTP request, use the HTTP_PUT_VERBOSE or HTTP_PUT_BLOB_VERBOSE table function: HTTP_PUT_VERBOSE and HTTP_PUT_BLOB_VERBOSE
Example
- Send a HTTP PUT request to https://www.example.com/users sending 'ABC' and using the certificate
store /home/javaTrustStore/fromJava.KDB and return the result.
VALUES QSYS2.HTTP_PUT('https://www.example.com/users', 'ABC', '{"sslCertificateStoreFile":"/home/javaTrustStore/fromJava.KDB"}');