WEBSERVICE

WEBSERVICE(url)

Returns the results from a webservice.

url

The url of the web service.

REMARKS

* This function was added in Excel 2013.
* If "url" > 2048 characters, then #VALUE is returned.
* If there is no internet access, then #VALUE! is returned.
* If you are working with a proxy server, then #VALUE! is returned
* If the "url" is not valid, then #VALUE! is returned
* If the result is not valid, then #VALUE! is returned.
* If the result contains more than 32,767 characters, #VALUE! is returned.
* If the protocol used is "ftp://", then #VALUE! is returned
* If the protocol used is "file://", then #VALUE! is returned
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=LEFT(WEBSERVICE("https://w3schools.com/xml/note.xml"),20) =
2	=LEFT(WEBSERVICE("https://bettersolutions.com/excel/xml/example.xml"),20) =
3	=LEFT(WEBSERVICE("https://www.microsoft.com/en-gb"),20) = #VALUE!

1 - This works
2 - This works
3 - This does not work