How to use WEBSERVICE in Excel online

[Shijie]

Hello, 

I built a Green House Gas calculator on Excel 365 desktop. I use WEBSERVICE to pull commuting distance information from Google Map API, and it is working perfectly.

I want to host the calculator (excel sheet) online, but it seems all WEBSERVICE formulas turn into #VALUE!, does anyone know how to fix it? Thank you. 

[#2]

@Shijie 

Excel functions (alphabetical) - Office Support (microsoft.com)

[#3]

@Sergei Baklan  Thank you!

[#4]

@Shijie Is there any way to use an API call in Excel Online?