WEBSERVICE function
Summary
Returns data from a web service. This function is not available in Excel for the web.
Syntax
WEBSERVICE(url)
The WEBSERVICE function syntax has the following argument.
url Required | The URL of the web service to be called
Notes:
If arguments are unable to return the data, WEBSERVICE returns a #VALUE! error.
If arguments result in a string that is not valid or that contains more than the allowable cell limit of 32767 characters, WEBSERVICE returns a #VALUE! error.
If url is a string that contains more than the 2048 characters that are allowed for a GET request, WEBSERVICE returns a #VALUE! error.
For protocols that aren’t supported, such as ftp:// or file://, WEBSERVICE returns a #VALUE! error.
url Required | The URL of the web service to be called
Notes:
If arguments are unable to return the data, WEBSERVICE returns a #VALUE! error.
If arguments result in a string that is not valid or that contains more than the allowable cell limit of 32767 characters, WEBSERVICE returns a #VALUE! error.
If url is a string that contains more than the 2048 characters that are allowed for a GET request, WEBSERVICE returns a #VALUE! error.
For protocols that aren’t supported, such as ftp:// or file://, WEBSERVICE returns a #VALUE! error.
Example
=WEBSERVICE(“http://mywebservice.com/serviceEndpoint?searchString=Excel”)