Nov 22 2019 05:56 PM
In the WEBSERVICE("http://api.openweathermap.org/data/2.5/weather?lat=34.82&lon=-87.99&APPID=key") ; I want to use lat and lon values from cells like H4,etc. How can I do it?
Nov 23 2019 05:37 AM
SolutionAssuming your URL correctly works in browser, you may generate URL string as
=WEBSERVICE("http://api.openweathermap.org/data/2.5/weather?lat=" & TEXT(H4,"##.##") & "&lon=" & TEXT(H5,"##.##") & "&APPID=key")
Nov 23 2019 05:37 AM
SolutionAssuming your URL correctly works in browser, you may generate URL string as
=WEBSERVICE("http://api.openweathermap.org/data/2.5/weather?lat=" & TEXT(H4,"##.##") & "&lon=" & TEXT(H5,"##.##") & "&APPID=key")