WEBSERVICE

WEBSERVICE(url)

Returns the results from a webservice.

urlThe url of the web service.

REMARKS
* 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
* This function was added in Excel 2013.
* 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

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