SOLVED

Excel WEBSERVICE #Value Error

Copper Contributor

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?

1 Reply
best response confirmed by rutul96 (Copper Contributor)
Solution

@rutul96 

Assuming 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")

 

1 best response

Accepted Solutions
best response confirmed by rutul96 (Copper Contributor)
Solution

@rutul96 

Assuming 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")

 

View solution in original post