=JsonPathOnUrl(string url, string jsonPath, [string xmlHttpSettings]) : array

Fetches url and returns the (array) result from JSONPath expression.

This function is cached.

You can control the HTTP request (such as header and form variables) using the xmlHttpSettings. See HttpSettings.

See Working with arrays in Excel

See cookbook/JsonPathOnUrl.xsl for JSONPath examples.


comments powered by Disqus