HTTP_PATCH
The HTTP_PATCH scalar function updates a text-based resource under the specified URL through an HTTP PATCH 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 returns a built-in character string or graphic string data type 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 a CLOB(2G) CCSID 1208 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_PATCH_VERBOSE table function: HTTP_PATCH_VERBOSE
Example
- Send a HTTP PATCH 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_PATCH('https://www.example.com/users', 'ABC', '{"sslCertificateStoreFile":"/home/javaTrustStore/fromJava.KDB"}');