Loads data in JSON format from an http(s) request and converts the result into a table. The result should be an object or an array of objects. Only primitive-typed values will be included in the resulting table, but all of the property names from the first object will be included as column names.
= IMPORT.JSON(url[, parameters][, jmespath_expression])
url - The URL to load the JSON from when evaluated. A url with parameters must be in the following format: "https://url.com?param1=${param1}¶m2=${param2}"
parameters - (Optional) The parameter to pass to the url (Use this rather than adding strings together to make the URL). To use jmes but not parameters, use 0 here.
The parameter values must be given in this format: {"param1", 3; "param2", "abc"}. For example, =IMPORT.JSON("https://url.com?param1=${param1}¶m2=${param2}", {"param1", 3; "param2", "abc"})
jmespath_expression - (Optional) A JMESPath expression to evaluate against the raw data (see https://jmespath.org).
For more information, refer to IMPORT.JSON examples.
Do not use IMPORT.JSON with j5 Applications.