Hi there!
I am relatively new to api coding and for some reason, i keep getting this error as below.
Can anyone help me? What does this error mean? and how do i resolve it?
Thanks!
Declaration has an invalid name.
On line number: 1. On column number: 3. System ID: http://www.google.com/ig/api?weather=Copenhagen&hl=en.
xml_api_reply:
LOAD version,
[weather/module_id] as module_id,
[weather/tab_id] as tab_id,
[weather/mobile_row] as mobile_row,
[weather/mobile_zipped] as mobile_zipped,
[weather/row] as row,
[weather/section] as section,
[weather/current_conditions/wind_condition/data] as [wind_condition/data],
[weather/current_conditions/icon/data] as [current_conditions/icon/data],
[weather/current_conditions/humidity/data] as [humidity/data],
[weather/current_conditions/temp_c/data] as [temp_c/data],
[weather/current_conditions/temp_f/data] as [temp_f/data],
[weather/current_conditions/condition/data] as [current_conditions/condition/data],
[weather/forecast_information/unit_system/data] as [unit_system/data],
[weather/forecast_information/current_date_time/data] as [current_date_time/data],
[weather/forecast_information/forecast_date/data] as [forecast_date/data],
[weather/forecast_information/postal_code/data] as [postal_code/data],
[weather/forecast_information/city/data] as [city/data],
%Key_xml_api_reply_5B90566A772C5AA3
FROM [http://www.google.com/ig/api?weather=Copenhagen&hl=en] (XmlSimple, Table is [xml_api_reply])