JsonPathOnUrl

=JsonPathOnUrl(Url, JsonPath, XmlHttpSettings) : array

Results from the JsonPathOnUrl function inside Excel


Purpose

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

Syntax for JSONPath.

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

This function is cached.


Local files

You can also parse local files using JsonPathOnUrl using either absolute or relative (to spreadsheet) filepaths:

file:///C:\path\to\file.xml
file:///path\relative\workbook.xml
file:///..\..\path\relative\workbook.xml

See: DirectoryList


See

Cookbook

Guides

Related Functions


Get help with this function in the community →