SpreadJS 14
Formula Reference / Formula Functions / Web Functions / WEBSERVICE
In This Topic
    WEBSERVICE
    In This Topic

    This function returns data from a web service on the Internet or Intranet.

    Syntax

    WEBSERVICE(url)

    Arguments

    This function has the following argument:

    Argument Description
    url [required] The URL of the web service to be called.

    Remarks

    The function supports HTTP (http and https) protocol. SpreadJS return "" as default value before the result is returned from the service. The correct result is displayed only when the response result is string type. If other formats like images, audio, video are used, it returns unreadable code.

    The function returns a #VALUE! error in following scenarios:

    Data Types

    This function accepts and returns string data.

    Examples

    WEBSERVICE("https://restcountries.eu/rest/v2/all")

    WEBSERVICE("https://jsonplaceholder.typicode.com/users")

    WEBSERVICE("https://www.google.com")