http json-lookup(a,b,c,d,e,f,g,h,i,j)
|
Group |
With this function, you can read in a JSON file via HTTP. You can either read in the complete file as a JSON object, which you then can query later. Alternatively, they can read a value directly with an XPath expression (see function execute json xpath(key a, expression b, array as text c, ignore exception d) for an example).
Parameter Description
|
Parameter |
Description |
|
a |
The URL from which the JSON file is to be requested. |
|
b |
If true, the HTTP request is executed through the DMZ server (if it exists). Default: false. |
|
c |
Key name of the JSON object to be created in the cache. |
|
d |
The XPath expression. See https://github.com/json-path/JsonPath. |
|
e |
The HTTP method to be used. Allowed values: PUT, POST, PATCH, HEAD, DELETE, GET. Default: GET. |
|
f |
If the ID of an HTTP(S) channel is specified here, the HTTP request is made using the connection parameters of this channel. This might be necessary if authentication is required. Note: You can select a channel with the button with the three dots and then receive the ID directly. |
|
g |
If you want to use additional HTTP headers in the HTTP request (or overwrite existing ones), the name of a map containing those headers can be specified here. The key of an entry in this map must be the name of the HTTP header and the value of the entry then is the value for this HTTP header. |
|
h |
If you send the HTTP request via POST (see parameter e), you can enter the payload here. Note: See also section Method GET/Method POST. |
|
i |
If true, an occurring exception is ignored and an empty string is returned. Default: <empty> (== false). |
|
j |
(optional) The encoding. Default: UTF-8. |