The following article introduces you to the WEBSERVICE function - one of the functions in the Web function group is very popular in Excel.
Description: The function returns data from a web service on the Internet or Intranet. Support functions from Excel 2013 onwards.
Syntax: WEBSERVICE (url)
Inside:
- url: The URL of the web service, is a required parameter.
Attention:
- If arguments cannot return data -> the function returns the #VALUE! Error value
- If arguments are invalid or contain more than 32676 characters -> the function returns the #VALUE! Error value
- If url is a string containing more than 2048 characters allowed by the Get request -> the function returns the #VALUE! Error value
- With unsupported protocols such as ftp: //, file: // -> the function returns the #VALUE! Error value
For example:
Determining the return value from the web service in the URL string is described in the table below:
- In the cell to calculate enter the formula: = WEBSERVICE (C6)
- Press Enter -> return value is:
- Similarly copying the formula for the remaining values results:
- Where url is in ftp: // format or file: // -> the function returns the #VALUE! Error value
Above are instructions and some specific examples when using WEBSERVICE function in Excel.
Good luck!