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],
'http://www.google.com'&[icon/data] AS IconUrl,
[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])