WEBSERVICE

Get some web content from a URI.

Синтаксис

WEBSERVICE(URI)

URI: URI text of the web service.

Пример

=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.

Синтаксис

FILTERXML(XML Document; XPath expression)

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

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

Пример

=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.