XML open table returns no data - because XML doesn't say 'encoding="UTF-8"' ?


I'm developing a table that's based on the 'secret' Google weather API:

use "http://github.com/vicmortelmans/yql-tables/raw/master/weather/weather.frost.xml" as weather.frost;select * from weather.frost where location = "Ringsaker"

It works fine, as long as no non-ASCII characters are returned byt he API. As soon as you start making queries for French locations, no data is returned by the XML open table; e.g.:

select * from xml where url='http://www.google.com/ig/api?weather=paris'

The Google API is not providing encoding information:

<?xml version="1.0"?>

Based on an octal dump, I'd say it's UTF8:

0000300 s - C 303 264 t e d & # 3 9 ; A z

Can someone confirm that the XML open table is failing on this kind of xml-data? Or should I be looking somewhere else?


2 Replies

Recent Posts

in YQL