WEBSERVICE(url)

Returns the results from a webservice.

urlThe url of the web service.

Remarks

* 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.office.com

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

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

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top