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

Popular posts from this blog

ruby on rails - RuntimeError: Circular dependency detected while autoloading constant - ActiveAdmin.register Role -

c++ - OpenMP unpredictable overhead -

javascript - Wordpress slider, not displayed 100% width -