Forum Documentation Showcase Pricing Learn more

World {country,region, city Api


#1

hello am a novice
please i am trying to use this plugging from this api “http://battuta.medunes.net” that displays world country, region and city but cant seem to able to properly use it.I ve only been able to make it display list of country, but not with region and city. Can someone kindly guide me on how to use it with the bubble api connector


#2

what are you trying to do exactly? maybe this plugin could help,


#3

thanks jarrad. I want to have a displayed list of world countries, regions in each country and cities found in each of the regions. i found an api from here “http://battuta.medunes.net” that gives me that but its like i dont know how to properly use it with the bubble api connector. so far i ve been able to get it to display only the countries but i dont understand the parameters to use for itto display the regions and cities found in each country.


#4

geonames does what your after, here are the results (what bubble would let me max post) of 1 “country info” api call leaving the parameters blank -

{
“geonames”: [
{
“continent”: “EU”,
“capital”: “Andorra la Vella”,
“languages”: “ca”,
“geonameId”: 3041565,
“south”: 42.42849259876837,
“isoAlpha3”: “AND”,
“north”: 42.65604389629997,
“fipsCode”: “AN”,
“population”: “84000”,
“east”: 1.7865427778319827,
“isoNumeric”: “020”,
“areaInSqKm”: “468.0”,
“countryCode”: “AD”,
“west”: 1.4071867141112762,
“countryName”: “Andorra”,
“continentName”: “Europe”,
“currencyCode”: “EUR”
},
{
“continent”: “AS”,
“capital”: “Abu Dhabi”,
“languages”: “ar-AE,fa,en,hi,ur”,
“geonameId”: 290557,
“south”: 22.633329391479492,
“isoAlpha3”: “ARE”,
“north”: 26.08415985107422,
“fipsCode”: “AE”,
“population”: “4975593”,
“east”: 56.38166046142578,
“isoNumeric”: “784”,
“areaInSqKm”: “82880.0”,
“countryCode”: “AE”,
“west”: 51.58332824707031,
“countryName”: “United Arab Emirates”,
“continentName”: “Asia”,
“currencyCode”: “AED”
},
{
“continent”: “AS”,
“capital”: “Kabul”,
“languages”: “fa-AF,ps,uz-AF,tk”,
“geonameId”: 1149361,
“south”: 29.377472,
“isoAlpha3”: “AFG”,
“north”: 38.483418,
“fipsCode”: “AF”,
“population”: “29121286”,
“east”: 74.879448,
“isoNumeric”: “004”,
“areaInSqKm”: “647500.0”,
“countryCode”: “AF”,
“west”: 60.478443,
“countryName”: “Afghanistan”,
“continentName”: “Asia”,
“currencyCode”: “AFN”
},
{
“continent”: “NA”,
“capital”: “St. John’s”,
“languages”: “en-AG”,
“geonameId”: 3576396,
“south”: 16.996979,
“isoAlpha3”: “ATG”,
“north”: 17.729387,
“fipsCode”: “AC”,
“population”: “86754”,
“east”: -61.672421,
“isoNumeric”: “028”,
“areaInSqKm”: “443.0”,
“countryCode”: “AG”,
“west”: -61.906425,
“countryName”: “Antigua and Barbuda”,
“continentName”: “North America”,
“currencyCode”: “XCD”
},
{
“continent”: “NA”,
“capital”: “The Valley”,
“languages”: “en-AI”,
“geonameId”: 3573511,
“south”: 18.160292974311673,
“isoAlpha3”: “AIA”,
“north”: 18.276901971658063,
“fipsCode”: “AV”,
“population”: “13254”,
“east”: -62.96655544577948,
“isoNumeric”: “660”,
“areaInSqKm”: “102.0”,
“countryCode”: “AI”,
“west”: -63.16808989603879,
“countryName”: “Anguilla”,
“continentName”: “North America”,
“currencyCode”: “XCD”
},
{
“continent”: “EU”,
“capital”: “Tirana”,
“languages”: “sq,el”,
“geonameId”: 783754,
“south”: 39.6448624829142,
“isoAlpha3”: “ALB”,
“north”: 42.6611669383269,
“fipsCode”: “AL”,
“population”: “2986952”,
“east”: 21.0574334835312,
“isoNumeric”: “008”,
“areaInSqKm”: “28748.0”,
“countryCode”: “AL”,
“west”: 19.2639112711741,
“countryName”: “Albania”,
“continentName”: “Europe”,
“currencyCode”: “ALL”
},
{
“continent”: “AS”,
“capital”: “Yerevan”,
“languages”: “hy”,
“geonameId”: 174982,
“south”: 38.830528,
“isoAlpha3”: “ARM”,
“north”: 41.301834,
“fipsCode”: “AM”,
“population”: “2968000”,
“east”: 46.772435045159995,
“isoNumeric”: “051”,
“areaInSqKm”: “29800.0”,
“countryCode”: “AM”,
“west”: 43.44978,
“countryName”: “Armenia”,
“continentName”: “Asia”,
“currencyCode”: “AMD”
},
{
“continent”: “AF”,
“capital”: “Luanda”,
“languages”: “pt-AO”,
“geonameId”: 3351879,
“south”: -18.042076,
“isoAlpha3”: “AGO”,
“north”: -4.376826,
“fipsCode”: “AO”,
“population”: “13068161”,
“east”: 24.082119,
“isoNumeric”: “024”,
“areaInSqKm”: “1246700.0”,
“countryCode”: “AO”,
“west”: 11.679219,
“countryName”: “Angola”,
“continentName”: “Africa”,
“currencyCode”: “AOA”
},
{
“continent”: “AN”,
“capital”: “”,
“languages”: “”,
“geonameId”: 6697173,
“south”: -89.9999,
“isoAlpha3”: “ATA”,
“north”: -60.515533,
“fipsCode”: “AY”,
“population”: “0”,
“east”: 179.9999,
“isoNumeric”: “010”,
“areaInSqKm”: “1.4E7”,
“countryCode”: “AQ”,
“west”: -179.9999,
“countryName”: “Antarctica”,
“continentName”: “Antarctica”,
“currencyCode”: “”
},
{
“continent”: “SA”,
“capital”: “Buenos Aires”,
“languages”: “es-AR,en,it,de,fr,gn”,
“geonameId”: 3865483,
“south”: -55.061314,
“isoAlpha3”: “ARG”,
“north”: -21.781277,
“fipsCode”: “AR”,
“population”: “41343201”,
“east”: -53.591835,
“isoNumeric”: “032”,
“areaInSqKm”: “2766890.0”,
“countryCode”: “AR”,
“west”: -73.58297,
“countryName”: “Argentina”,
“continentName”: “South America”,
“currencyCode”: “ARS”
},
{
“continent”: “OC”,
“capital”: “Pago Pago”,
“languages”: “en-AS,sm,to”,
“geonameId”: 5880801,
“south”: -14.382478,
“isoAlpha3”: “ASM”,
“north”: -11.0497,
“fipsCode”: “AQ”,
“population”: “57881”,
“east”: -169.416077,
“isoNumeric”: “016”,
“areaInSqKm”: “199.0”,
“countryCode”: “AS”,
“west”: -171.091888,
“countryName”: “American Samoa”,
“continentName”: “Oceania”,
“currencyCode”: “USD”
},
{
“continent”: “EU”,
“capital”: “Vienna”,
“languages”: “de-AT,hr,hu,sl”,
“geonameId”: 2782113,
“south”: 46.3726520216244,
“isoAlpha3”: “AUT”,
“north”: 49.0211627691393,
“fipsCode”: “AU”,
“population”: “8205000”,
“east”: 17.1620685652599,
“isoNumeric”: “040”,
“areaInSqKm”: “83858.0”,
“countryCode”: “AT”,
“west”: 9.53095237240833,
“countryName”: “Austria”,
“continentName”: “Europe”,
“currencyCode”: “EUR”
},
{
“continent”: “OC”,
“capital”: “Canberra”,
“languages”: “en-AU”,
“geonameId”: 2077456,
“south”: -43.64397,
“isoAlpha3”: “AUS”,
“north”: -10.062805,
“fipsCode”: “AS”,
“population”: “21515754”,
“east”: 153.639252,
“isoNumeric”: “036”,
“areaInSqKm”: “7686850.0”,
“countryCode”: “AU”,
“west”: 112.911057,
“countryName”: “Australia”,
“continentName”: “Oceania”,
“currencyCode”: “AUD”
},
{
“continent”: “NA”,
“capital”: “Oranjestad”,
“languages”: “nl-AW,pap,es,en”,
“geonameId”: 3577279,
“south”: 12.411707706190716,
“isoAlpha3”: “ABW”,
“north”: 12.623718127152925,
“fipsCode”: “AA”,
“population”: “71566”,
“east”: -69.86575120104982,
“isoNumeric”: “533”,
“areaInSqKm”: “193.0”,
“countryCode”: “AW”,
“west”: -70.0644737196045,
“countryName”: “Aruba”,
“continentName”: “North America”,
“currencyCode”: “AWG”
},
{
“continent”: “EU”,
“capital”: “Mariehamn”,
“languages”: “sv-AX”,
“geonameId”: 661882,
“south”: 59.90675,
“isoAlpha3”: “ALA”,
“north”: 60.488861,
“fipsCode”: “”,
“population”: “26711”,
“east”: 21.011862,
“isoNumeric”: “248”,
“areaInSqKm”: “1580.0”,
“countryCode”: “AX”,
“west”: 19.317694,
“countryName”: “Åland”,
“continentName”: “Europe”,
“currencyCode”: “EUR”
},
{
“continent”: “AS”,
“capital”: “Baku”,
“languages”: “az,ru,hy”,
“geonameId”: 587116,
“south”: 38.38915252685547,
“isoAlpha3”: “AZE”,
“north”: 41.90564,
“fipsCode”: “AJ”,
“population”: “8303512”,
“east”: 50.370083,
“isoNumeric”: “031”,
“areaInSqKm”: “86600.0”,
“countryCode”: “AZ”,
“west”: 44.774113,
“countryName”: “Azerbaijan”,
“continentName”: “Asia”,
“currencyCode”: “AZN”
},
{
“continent”: “EU”,
“capital”: “Sarajevo”,
“languages”: “bs,hr-BA,sr-BA”,
“geonameId”: 3277605,
“south”: 42.546112,
“isoAlpha3”: “BIH”,
“north”: 45.239193,
“fipsCode”: “BK”,
“population”: “4590000”,
“east”: 19.622223,
“isoNumeric”: “070”,
“areaInSqKm”: “51129.0”,
“countryCode”: “BA”,
“west”: 15.718945,
“countryName”: “Bosnia and Herzegovina”,
“continentName”: “Europe”,
“currencyCode”: “BAM”
},
{
“continent”: “NA”,
“capital”: “Bridgetown”,
“languages”: “en-BB”,
“geonameId”: 3374084,
“south”: 13.039844,
“isoAlpha3”: “BRB”,
“north”: 13.327257,
“fipsCode”: “BB”,
“population”: “285653”,
“east”: -59.420376,
“isoNumeric”: “052”,
“areaInSqKm”: “431.0”,
“countryCode”: “BB”,
“west”: -59.648922,
“countryName”: “Barbados”,
“continentName”: “North America”,
“currencyCode”: “BBD”
},
{
“continent”: “AS”,
“capital”: “Dhaka”,
“languages”: “bn-BD,en”,
“geonameId”: 1210997,
“south”: 20.743334,
“isoAlpha3”: “BGD”,
“north”: 26.631945,
“fipsCode”: “BG”,
“population”: “156118464”,
“east”: 92.673668,
“isoNumeric”: “050”,
“areaInSqKm”: “144000.0”,
“countryCode”: “BD”,
“west”: 88.028336,
“countryName”: “Bangladesh”,
“continentName”: “Asia”,
“currencyCode”: “BDT”
},
{
“continent”: “EU”,
“capital”: “Brussels”,
“languages”: “nl-BE,fr-BE,de-BE”,
“geonameId”: 2802361,
“south”: 49.4975573880965,
“isoAlpha3”: “BEL”,
“north”: 51.5056400261465,
“fipsCode”: “BE”,
“population”: “10403000”,
“east”: 6.40662259579998,
“isoNumeric”: “056”,
“areaInSqKm”: “30510.0”,
“countryCode”: “BE”,
“west”: 2.54011191097637,
“countryName”: “Belgium”,
“continentName”: “Europe”,
“currencyCode”: “EUR”
},
{
“continent”: “AF”,
“capital”: “Ouagadougou”,
“languages”: “fr-BF,mos”,
“geonameId”: 2361809,
“south”: 9.401108,
“isoAlpha3”: “BFA”,
“north”: 15.082593,
“fipsCode”: “UV”,
“population”: “16241811”,
“east”: 2.405395,
“isoNumeric”: “854”,
“areaInSqKm”: “274200.0”,
“countryCode”: “BF”,
“west”: -5.518916,
“countryName”: “Burkina Faso”,
“continentName”: “Africa”,
“currencyCode”: “XOF”
},
{
“continent”: “EU”,
“capital”: “Sofia”,
“languages”: “bg,tr-BG,rom”,
“geonameId”: 732800,
“south”: 41.242084,
“isoAlpha3”: “BGR”,
“north”: 44.21764,
“fipsCode”: “BU”,
“population”: “7148785”,
“east”: 28.612167,
“isoNumeric”: “100”,
“areaInSqKm”: “110910.0”,
“countryCode”: “BG”,
“west”: 22.371166,
“countryName”: “Bulgaria”,
“continentName”: “Europe”,
“currencyCode”: “BGN”
},
{
“continent”: “AS”,
“capital”: “Manama”,
“languages”: “ar-BH,en,fa,ur”,
“geonameId”: 290291,
“south”: 25.796862,
“isoAlpha3”: “BHR”,
“north”: 26.282583,
“fipsCode”: “BA”,
“population”: “738004”,
“east”: 50.664471,
“isoNumeric”: “048”,
“areaInSqKm”: “665.0”,
“countryCode”: “BH”,
“west”: 50.45414,
“countryName”: “Bahrain”,
“continentName”: “Asia”,
“currencyCode”: “BHD”
},
{
“continent”: “AF”,
“capital”: “Bujumbura”,
“languages”: “fr-BI,rn”,
“geonameId”: 433561,
“south”: -4.465713,
“isoAlpha3”: “BDI”,
“north”: -2.310123,
“fipsCode”: “BY”,
“population”: “9863117”,
“east”: 30.847729,
“isoNumeric”: “108”,
“areaInSqKm”: “27830.0”,
“countryCode”: “BI”,
“west”: 28.993061,
“countryName”: “Burundi”,
“continentName”: “Africa”,
“currencyCode”: “BIF”
},
{
“continent”: “AF”,
“capital”: “Porto-Novo”,
“languages”: “fr-BJ”,
“geonameId”: 2395170,
“south”: 6.225748,
“isoAlpha3”: “BEN”,
“north”: 12.418347,
“fipsCode”: “BN”,
“population”: “9056010”,
“east”: 3.851701,
“isoNumeric”: “204”,
“areaInSqKm”: “112620.0”,
“countryCode”: “BJ”,
“west”: 0.774575,
“countryName”: “Benin”,
“continentName”: “Africa”,
“currencyCode”: “XOF”
},
{
“continent”: “NA”,
“capital”: “Gustavia”,
“languages”: “fr”,
“geonameId”: 3578476,
“south”: 17.878183227405575,
“isoAlpha3”: “BLM”,
“north”: 17.928808791949283,
“fipsCode”: “TB”,
“population”: “8450”,
“east”: -62.788983372985854,
“isoNumeric”: “652”,
“areaInSqKm”: “21.0”,
“countryCode”: “BL”,
“west”: -62.8739118253784,
“countryName”: “Saint Barthélemy”,
“continentName”: “North America”,
“currencyCode”: “EUR”
},
{
“continent”: “NA”,
“capital”: “Hamilton”,
“languages”: “en-BM,pt”,
“geonameId”: 3573345,
“south”: 32.247551,
“isoAlpha3”: “BMU”,
“north”: 32.39122351646162,
“fipsCode”: “BD”,
“population”: “65365”,
“east”: -64.64718648144532,
“isoNumeric”: “060”,
“areaInSqKm”: “53.0”,
“countryCode”: “BM”,
“west”: -64.88723800000002,
“countryName”: “Bermuda”,
“continentName”: “North America”,
“currencyCode”: “BMD”
},
{
“continent”: “AS”,
“capital”: “Bandar Seri Begawan”,
“languages”: “ms-BN,en-BN”,
“geonameId”: 1820814,
“south”: 4.003083,
“isoAlpha3”: “BRN”,
“north”: 5.047167,
“fipsCode”: “BX”,
“population”: “395027”,
“east”: 115.359444,
“isoNumeric”: “096”,
“areaInSqKm”: “5770.0”,
“countryCode”: “BN”,
“west”: 114.071442,
“countryName”: “Brunei”,
“continentName”: “Asia”,
“currencyCode”: “BND”
},

  ive also just added subdivisions for you.

#5

thank you so much jarrad for ur response.
I had tried using geonames but it seems it doesnt showcase all the regions in a country, as well as list of cities in the region.and thats what am really after>list of all the regions/state in countries not just capital city, as well as cities in a particular region/state


#6

you pull the lat & lng from this returned data to feed the subdivision call that uses the lat & lng to grab the region stats… you can even define a range (distance) for that data.


#7

wow!!!:open_mouth: let me try playing around that then.
REALLY APPRECIATE JARRAD


#8

hello jarrad. sent u a dm


#9

how do you get geonames to work? i am trying to get placename info.

did you use bubble’s search box with geographic addresses?

i have not been able to get geonames to work for me at all.