/text/scalc/01/func_webservice.xhp

WEBSERVICE function 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 function 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.