Calling google weather API error

Wed, 25 Nov 2020 16:16:04 GMT

Hi there,

I am relatively new to Qlikview and am totally unsure on how to call google weather API..

I have searched a few QVD examples, however when i click on reload, errors keep popping up "Declaration has an invalid name".

Please help!

Declaration has an invalid name.

On line number: 1. On column number: 3. System ID: http://www.google.com/ig/api?weather=Singapore.

Weather:

LOAD [condition/data],

[high/data],

[low/data],

([high/data]-32)/1.8 AS HighC,

([low/data]-32)/1.8 AS LowC,

[day_of_week/data] AS Day

FROM [http://www.google.com/ig/api?weather=Singapore] (XmlSimple, Table is [xml_api_reply/weather/forecast_conditions])

topic Calling google weather API error in QlikView