JsonPathOnUrl

=JsonPathOnUrl(Url, JsonPath, XmlHttpSettings) : array

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

• JsonPathOnUrl.xlsx

Guides

• Working with arrays in Excel
• Find the country where a site is hosted

Related Functions

• GetTextOnUrl
• CsQueryOnUrl
• XPathOnUrl
• RegexpFindOnUrl