WEBSERVICE
Formulas / WEBSERVICERetrieve data from a web service.
WEBSERVICE(url)
- url - required, the url of the web service to call
Examples
=WEBSERVICE("https://www.nasa.gov/rss/dyn/breaking_news.rss")The WEBSERVICE Sourcetable function can be used to get information from web services. It takes a URL as an argument and returns data from the service as a result. This example will return the latest 10 news articles from NASA.
=WEBSERVICE("http://somewebservice.com/endpoint?query=xxxx")The WEBSERVICE Sourcetable function can also be used to call web services with parameters. This example calls a web service and returns the result with the specified query.
Summary
The WEBSERVICE function is a Sourcetable tool available in Excel 2013 and later which allows users to retrieve data from a web service. It requires Windows operating system features and can be found in the Excel for Mac function gallery. It has a maximum characters for GET requests of 2048.
- The WEBSERVICE function is only available in Excel 2013 and later for Windows and Mac, and uses a protocol like HTTP to retrieve data from a web service.
- Once the data is retrieved, the WEBSERVICE function returns it to the worksheet.
Frequently Asked Questions
What is the WEBSERVICE function?
The WEBSERVICE function is a function in Sourcetable that retrieves data from a web service. It is only available in Excel 2013 and later and can be found in the Excel for Mac function gallery.
What is required for the WEBSERVICE function?
The WEBSERVICE function requires a URL argument. The URL should be encoded before including it in the formula using the ENCODEURL function.
How do I use the WEBSERVICE function?
To use the WEBSERVICE function, you will need to:
- Open Excel 2013 or later
- Find the WEBSERVICE function in the Excel for Mac function gallery
- Enter the URL for the web service you wish to retrieve data from
- Encode the URL using the ENCODEURL function
- Include the encoded URL in the formula
- Execute the formula to retrieve the data
