WEBSERVICE

WEBSERVICE(url)

Returns the results from a webservice.

url

The url of the web service.

REMARKS

* This function can be used to call a REST API (GET protocol) and return information.
* 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.
* This funcion works with both "https" and "http".
* If the protocol used is "ftp://", then #VALUE! is returned
* If the protocol used is "file://", then #VALUE! is returned
* This function was added in Excel 2013.
* You can use the ENCODEURL function to return a url encoded string.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=LEFT( WEBSERVICE("https://api.github.com/users/ BetterSolns/followers"),20) = [{"login":"Adrian235
2	=LEFT( WEBSERVICE("https://w3schools.com/ xml/note.xml"),20) = <?xml version="1.0"
3	=LEFT( WEBSERVICE("https://bettersolutions.com/ excel/xml/example.xml"),20) = <?xml version="1.0"?
4	=LEFT( WEBSERVICE("https://www.microsoft.com/ en-gb"),20) = #VALUE!

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