Forum Discussion
Webservice function
Hello. I want to use the WEBSERVICE function to geolocate an IP address. The address is in cell A1, and the function is in A2. The function looks like this: =WEBSERVICE("https://ip-api.com/csv/" & ...
Can you try this formula and see if it works? The API can work without an API key.
=WEBSERVICE("https://api.ip2location.io?ip=" & A1)