WEBSERVICE function - The function returns data from a web service on the Internet or Intranet in Excel

The following article introduces you to the WEBSERVICE function - one of the functions in the Web function group is very popular in Excel.

WEBSERVICE function - The function returns data from a web service on the Internet or Intranet in Excel Picture 1

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:

WEBSERVICE function - The function returns data from a web service on the Internet or Intranet in Excel Picture 2

- In the cell to calculate enter the formula: = WEBSERVICE (C6)

WEBSERVICE function - The function returns data from a web service on the Internet or Intranet in Excel Picture 3

- Press Enter -> return value is:

WEBSERVICE function - The function returns data from a web service on the Internet or Intranet in Excel Picture 4

- Similarly copying the formula for the remaining values ​​results:

WEBSERVICE function - The function returns data from a web service on the Internet or Intranet in Excel Picture 5

- Where url is in ftp: // format or file: // -> the function returns the #VALUE! Error value

WEBSERVICE function - The function returns data from a web service on the Internet or Intranet in Excel Picture 6

Above are instructions and some specific examples when using WEBSERVICE function in Excel.

Good luck!