SOLVED

Excel WEBSERVICE #Value Error

%3CLINGO-SUB%20id%3D%22lingo-sub-1027854%22%20slang%3D%22en-US%22%3EExcel%20WEBSERVICE%20%23Value%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1027854%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20the%20WEBSERVICE(%22%3CA%20href%3D%22http%3A%2F%2Fapi.openweathermap.org%2Fdata%2F2.5%2Fweather%3Flat%3D34.82%26amp%3Blon%3D-87.99%26amp%3BAPPID%3Dkey%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttp%3A%2F%2Fapi.openweathermap.org%2Fdata%2F2.5%2Fweather%3Flat%3D34.82%26amp%3Blon%3D-87.99%26amp%3BAPPID%3Dkey%3C%2FA%3E%22)%20%3B%20I%20want%20to%20use%20lat%20and%20lon%20values%20from%20cells%20like%20H4%2Cetc.%20How%20can%20I%20do%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1027854%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAPI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFilterxml%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EWebservice%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1028374%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20WEBSERVICE%20%23Value%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1028374%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F466286%22%20target%3D%22_blank%22%3E%40rutul96%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAssuming%20your%20URL%20correctly%20works%20in%20browser%2C%20you%20may%20generate%20URL%20string%20as%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DWEBSERVICE(%22%3CA%20href%3D%22http%3A%2F%2Fapi.openweathermap.org%2Fdata%2F2.5%2Fweather%3Flat%3D%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fapi.openweathermap.org%2Fdata%2F2.5%2Fweather%3Flat%3D%3C%2FA%3E%22%20%26amp%3B%20TEXT(H4%2C%22%23%23.%23%23%22)%20%26amp%3B%20%22%26amp%3Blon%3D%22%20%26amp%3B%20TEXT(H5%2C%22%23%23.%23%23%22)%20%26amp%3B%20%22%26amp%3BAPPID%3Dkey%22)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 (Occasional Visitor)
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")