Excel functions

The Excel function: WEBSERVICE

Returns data from a web service.

More information: support.microsoft.com/en-us/office/webservice-function-0546a35a-ecc6-4739-aed7-c0b7ce1562c4

Other functions
ENCODEURL
Returns a URL-encoded string
FILTERXML
Returns specific data from the XML content by using the specified XPath