xml - Get data from geoapi into google spreadsheets -
i'm trying country name given city, here's formula warszawa: =importxml("http://api.geonames.org/search?q=warszawa&maxrows=1&style=full&username=glebvk";"/geonames/geoname[1]/countrycode")
i "error: imported content empty."
change xpath query /geonames/geoname[1]/countrycode
/geonames/geoname[1]/countrycode
. xpath queries case-sensitive.
Comments
Post a Comment