Source: Geonames.org


Name Description Inputs
(ordered)
Output
(only one)

This function returns country information given a two letter country code, from geonames.org.

Example:
=Ignite("geonames.org","countryInfo","countryName","DE")
country

countryCode countryName isoNumeric isoAlpha3 fipsCode continent continentName capital areaInSqKm population currencyCode languages postalCodeFormat ALL

This function returns location information given a two letter country code and a zip code, from geonames.org.

Example:
=Ignite("geonames.org","postalCode","placeName","US", "61101")
country

postalcode

placeName lng lat adminName1 adminCode1 adminCode2 adminName2 adminCode3 adminName3 postalcode countryCode ALL
Required Optional Output

Examples:

 AB (Forumla)C (Output)
1 DE =Ignite("geonames.org","countryInfo","countryCode",A1) DE
2 DE =Ignite("geonames.org","countryInfo","countryName",A2) Germany
3 DE =Ignite("geonames.org","countryInfo","isoNumeric",A3) 276
4 DE =Ignite("geonames.org","countryInfo","isoAlpha3",A4) DEU
5 DE =Ignite("geonames.org","countryInfo","fipsCode",A5) GM
6 DE =Ignite("geonames.org","countryInfo","continent",A6) EU
7 DE =Ignite("geonames.org","countryInfo","continentName",A7) Europe
8 DE =Ignite("geonames.org","countryInfo","capital",A8) Berlin
9 DE =Ignite("geonames.org","countryInfo","areaInSqKm",A9) 357021
10 DE =Ignite("geonames.org","countryInfo","population",A10) 81802257
11 DE =Ignite("geonames.org","countryInfo","currencyCode",A11) EUR
12 DE =Ignite("geonames.org","countryInfo","languages",A12) de
13 DE =Ignite("geonames.org","countryInfo","postalCodeFormat",A13) #####


 ABC (Forumla)D (Output)
1 US61101 =Ignite("geonames.org","postalCode","placeName",A1,B1) Rockford
2 US61101 =Ignite("geonames.org","postalCode","lng",A2,B2) -89.116118
3 US61101 =Ignite("geonames.org","postalCode","lat",A3, B3) 42.292233
4 US61101 =Ignite("geonames.org","postalCode","adminName1",A4, B4) Illinois
5 US61101 =Ignite("geonames.org","postalCode","adminCode1",A5, B5) IL
6 US61101 =Ignite("geonames.org","postalCode","adminName2",A6, B6) Winnebago
7 US61101 =Ignite("geonames.org","postalCode","adminCode2",A7, B7) 201
8 US61101 =Ignite("geonames.org","postalCode","postalcode",A8, B8) 61101
6 GBne616yf =Ignite("geonames.org","postalCode","adminName3",A9, B9) Northumberland
7 GBne616yf =Ignite("geonames.org","postalCode","adminCode3",A10, B10) E06000048