WEBSERVICE

Get some web content from a URI.

Syntax

WEBSERVICE(URI)

URI: URI text of the web service.

Example

=WEBSERVICE("http://api.openweathermap.org/data/2.5/forecast?q=Copenhagen,dk&mode=xml&units=metric")

Returns the web page content of "http://api.openweathermap.org/data/2.5/forecast?q=Copenhagen,dk&mode=xml&units=metric"

FILTERXML

Apply a XPath expression to a XML document.

Syntax

FILTERXML(XML Document; XPath expression)

XML Document (required): String containing a valid XML stream.

XPath expression (required): String containing a valid XPath expression.

Example

=FILTERXML(WEBSERVICE("http://api.openweathermap.org/data/2.5/forecast?q=Copenhagen,dk&mode=xml&units=metric");"number(/weatherdata/forecast/time[2]/temperature/@value)")

Returns information on Copenhagen weather temperature.