Hello i would like to populate different list box of my form with data from API.
For example i have a listBox Country and my API send this, i would like this data populate all country in the listbox
[{"id":75,"text":"France","textEN":"France"},{"id":3,"text":"Afghanistan","textEN":"Afghanistan"},{"id":247,"text":"Afrique du Sud","textEN":"South Africa"},{"id":6,"text":"Albanie","textEN":"Albania"},{"id":62,"text":"Alg\u00e9rie","textEN":"Algeria"},{"id":57,"text":"Allemagne","textEN":"Germany"},{"id":1,"text":"Andorre","textEN":"Andorra"},{"id":8,"text":"Angola","textEN":"Angola"},{"id":5,"text":"Anguilla","textEN":"Anguilla"},{"id":9,"text":"Antarctique","textEN":"Antarctica"},{"id":4,"text":"Antigua-et-Barbuda","textEN":"Antigua and Barbuda"},{"id":193,"text":"Arabie saoudite","textEN":"Saudi Arabia"},{"id":10,"text":"Argentine","textEN":"Argentina"},{"id":7,"text":"Arm\u00e9nie","textEN":"Armenia"},{"id":14,"text":"Aruba","textEN":"Aruba"},{"id":13,"text":"Australie","textEN":"Australia"},{"id":12,"text":"Autriche","textEN":"Austria"},{"id":16,"text":"Azerba\u00efdjan","textEN":"Azerbaijan"},{"id":32,"text":"Bahamas","textEN":"Bahamas"},{"id":23,"text":"Bahre\u00efn","textEN":"Bahrain"},{"id":19,"text":"Bangladesh","textEN":"Bangladesh"},{"id":18,"text":"Barbade","textEN":"Barbados"},{"id":36,"text":"B\u00e9larus","textEN":"Belarus"},{"id":20,"text":"Belgique","textEN":"Belgium"},{"id":37,"text":"Belize","textEN":"Belize"},{"id":25,"text":"B\u00e9nin","textEN":"Benin"},{"id":27,"text":"Bermudes","textEN":"Bermuda"},{"id":33,"text":"Bhoutan","textEN":"Bhutan"},{"id":29,"text":"Bolivie","textEN":"Bolivia"},{"id":17,"text":"Bosnie-Herz\u00e9govine","textEN":"Bosnia and Herzegovina"},{"id":35,"text":"Botswana","textEN":"Botswana"},{"id":31,"text":"Br\u00e9sil","textEN":"Brazil"},{"id":28,"text":"Brunei Darussalam","textEN":"Brunei Darussalam"},{"id":22,"text":"Bulgarie","textEN":"Bulgaria"},{"id":21,"text":"Burkina Faso","textEN":"Burkina Faso"},{"id":24,"text":"Burundi","textEN":"Burundi"},{"id":117,"text":"Cambodge","textEN":"Cambodia"},{"id":47,"text":"Cameroun","textEN":"Cameroon"},{"id":38,"text":"Canada","textEN":"Canada"},{"id":52,"text":"Cap-Vert","textEN":"Cape Verde"},{"id":46,"text":"Chili","textEN":"Chile"},{"id":48,"text":"Chine","textEN":"China"},{"id":55,"text":"Chypre","textEN":"Cyprus"},{"id":49,"text":"Colombie","textEN":"Colombia"},{"id":119,"text":"Comores","textEN":"Comoros"},{"id":42,"text":"Congo","textEN":"Congo"},{"id":40,"text":"Congo, R\u00e9publique d\u00e9mocratique du","textEN":"Congo, Democratic Republic of"},{"id":121,"text":"Cor\u00e9e du Nord","textEN":"North Korea"},{"id":122,"text":"Cor\u00e9e du Sud","textEN":"South Korea"},{"id":50,"text":"Costa Rica","textEN":"Costa Rica"},{"id":44,"text":"C\u00f4te d'Ivoire","textEN":"C\u00f4te d'Ivoire"},{"id":98,"text":"Croatie","textEN":"Croatia"},{"id":51,"text":"Cuba","textEN":"Cuba"},{"id":53,"text":"Cura\u00e7ao","textEN":"Cura\u00e7ao"},{"id":59,"text":"Danemark","textEN":"Denmark"},{"id":58,"text":"Djibouti","textEN":"Djibouti"},{"id":60,"text":"Dominique","textEN":"Dominica"},{"id":65,"text":"\u00c9gypte","textEN":"Egypt"},{"id":210,"text":"El Salvador","textEN":"El Salvador"},{"id":2,"text":"\u00c9mirats arabes unis","textEN":"United Arab Emirates"},{"id":63,"text":"\u00c9quateur","textEN":"Ecuador"},{"id":67,"text":"\u00c9rythr\u00e9e","textEN":"Eritrea"},{"id":68,"text":"Espagne","textEN":"Spain"},{"id":64,"text":"Estonie","textEN":"Estonia"},{"id":233,"text":"\u00c9tats-Unis","textEN":"United States"},{"id":69,"text":"\u00c9thiopie","textEN":"Ethiopia"},{"id":71,"text":"Fidji","textEN":"Fiji"},{"id":70,"text":"Finlande","textEN":"Finland"},{"id":76,"text":"Gabon","textEN":"Gabon"},{"id":85,"text":"Gambie","textEN":"Gambia"},{"id":79,"text":"G\u00e9orgie","textEN":"Georgia"},{"id":90,"text":"G\u00e9orgie du Sud et les \u00eeles Sandwich du Sud","textEN":"South Georgia and the South Sandwich Islands"},{"id":82,"text":"Ghana","textEN":"Ghana"},{"id":83,"text":"Gibraltar","textEN":"Gibraltar"},{"id":89,"text":"Gr\u00e8ce","textEN":"Greece"},{"id":78,"text":"Grenade","textEN":"Grenada"},{"id":84,"text":"Groenland","textEN":"Greenland"},{"id":87,"text":"Guadeloupe","textEN":"Guadeloupe"},{"id":92,"text":"Guam","textEN":"Guam"},{"id":91,"text":"Guatemala","textEN":"Guatemala"},{"id":81,"text":"Guernesey","textEN":"Guernsey"},{"id":86,"text":"Guin\u00e9e","textEN":"Guinea"},{"id":88,"text":"Guin\u00e9e \u00e9quatoriale","textEN":"Equatorial Guinea"},{"id":93,"text":"Guin\u00e9e-Bissau","textEN":"Guinea-Bissau"},{"id":94,"text":"Guyana","textEN":"Guyana"},{"id":80,"text":"Guyane fran\u00e7aise","textEN":"French Guiana"},{"id":99,"text":"Ha\u00efti","textEN":"Haiti"},{"id":97,"text":"Honduras","textEN":"Honduras"},{"id":95,"text":"Hong Kong","textEN":"Hong Kong"},{"id":100,"text":"Hongrie","textEN":"Hungary"},{"id":34,"text":"\u00cele Bouvet","textEN":"Bouvet Island"},{"id":54,"text":"\u00cele Christmas","textEN":"Christmas Island"},{"id":104,"text":"\u00cele de Man","textEN":"Isle of Man"},{"id":163,"text":"\u00cele Norfolk","textEN":"Norfolk Island"},{"id":124,"text":"\u00celes Ca\u00efmans","textEN":"Cayman Islands"},{"id":39,"text":"\u00celes Cocos (Keeling)","textEN":"Cocos (Keeling) Islands"},{"id":45,"text":"\u00celes Cook","textEN":"Cook Islands"},{"id":15,"text":"\u00celes d'\u00c5land","textEN":"\u00c5land Islands"},{"id":74,"text":"\u00celes F\u00e9ro\u00e9","textEN":"Faroe Islands"},{"id":96,"text":"\u00celes Heard et McDonald","textEN":"Heard and McDonald Islands"},{"id":72,"text":"\u00celes Malouines","textEN":"Falkland Islands"},{"id":143,"text":"\u00celes Marshall","textEN":"Marshall Islands"},{"id":232,"text":"\u00celes mineures \u00e9loign\u00e9es des \u00c9tats-Unis","textEN":"United States Minor Outlying Islands"},{"id":194,"text":"\u00celes Salomon","textEN":"Solomon Islands"},{"id":214,"text":"\u00celes Turks et Caicos","textEN":"Turks and Caicos Islands"},{"id":240,"text":"\u00celes Vierges am\u00e9ricaines","textEN":"Virgin Islands (U.S.)"},{"id":239,"text":"\u00celes Vierges britanniques","textEN":"Virgin Islands (British)"},{"id":243,"text":"\u00celes Wallis-et-Futuna","textEN":"Wallis and Futuna Islands"},{"id":105,"text":"Inde","textEN":"India"},{"id":101,"text":"Indon\u00e9sie","textEN":"Indonesia"},{"id":107,"text":"Irak","textEN":"Iraq"},{"id":108,"text":"Iran","textEN":"Iran"},{"id":102,"text":"Irlande","textEN":"Ireland"},{"id":109,"text":"Islande","textEN":"Iceland"},{"id":103,"text":"Isra\u00ebl","textEN":"Israel"},{"id":110,"text":"Italie","textEN":"Italy"},{"id":112,"text":"Jama\u00efque","textEN":"Jamaica"},{"id":114,"text":"Japon","textEN":"Japan"},{"id":111,"text":"Jersey","textEN":"Jersey"},{"id":113,"text":"Jordanie","textEN":"Jordan"},{"id":125,"text":"Kazakhstan","textEN":"Kazakhstan"},{"id":115,"text":"Kenya","textEN":"Kenya"},{"id":116,"text":"Kirghizistan","textEN":"Kyrgyzstan"},{"id":118,"text":"Kiribati","textEN":"Kiribati"},{"id":123,"text":"Kowe\u00eft","textEN":"Kuwait"},{"id":126,"text":"Laos","textEN":"Lao People's Democratic Republic"},{"id":132,"text":"Lesotho","textEN":"Lesotho"},{"id":135,"text":"Lettonie","textEN":"Latvia"},{"id":127,"text":"Liban","textEN":"Lebanon"},{"id":131,"text":"Lib\u00e9ria","textEN":"Liberia"},{"id":136,"text":"Libye","textEN":"Libya"},{"id":129,"text":"Liechtenstein","textEN":"Liechtenstein"},{"id":133,"text":"Lituanie","textEN":"Lithuania"},{"id":134,"text":"Luxembourg","textEN":"Luxembourg"},{"id":148,"text":"Macao","textEN":"Macau"},{"id":144,"text":"Mac\u00e9doine","textEN":"Macedonia"},{"id":142,"text":"Madagascar","textEN":"Madagascar"},{"id":158,"text":"Malaisie","textEN":"Malaysia"},{"id":156,"text":"Malawi","textEN":"Malawi"},{"id":155,"text":"Maldives","textEN":"Maldives"},{"id":145,"text":"Mali","textEN":"Mali"},{"id":153,"text":"Malte","textEN":"Malta"},{"id":149,"text":"Mariannes du Nord","textEN":"Northern Mariana Islands"},{"id":137,"text":"Maroc","textEN":"Morocco"},{"id":150,"text":"Martinique","textEN":"Martinique"},{"id":154,"text":"Maurice","textEN":"Mauritius"},{"id":151,"text":"Mauritanie","textEN":"Mauritania"},{"id":246,"text":"Mayotte","textEN":"Mayotte"},{"id":157,"text":"Mexique","textEN":"Mexico"},{"id":73,"text":"Micron\u00e9sie, \u00c9tats f\u00e9d\u00e9r\u00e9s de","textEN":"Micronesia, Federated States of"},{"id":139,"text":"Moldavie","textEN":"Moldova"},{"id":138,"text":"Monaco","textEN":"Monaco"},{"id":147,"text":"Mongolie","textEN":"Mongolia"},{"id":140,"text":"Mont\u00e9n\u00e9gro","textEN":"Montenegro"},{"id":152,"text":"Montserrat","textEN":"Montserrat"},{"id":159,"text":"Mozambique","textEN":"Mozambique"},{"id":146,"text":"Myanmar","textEN":"Myanmar"},{"id":160,"text":"Namibie","textEN":"Namibia"},{"id":169,"text":"Nauru","textEN":"Nauru"},{"id":168,"text":"N\u00e9pal","textEN":"Nepal"},{"id":165,"text":"Nicaragua","textEN":"Nicaragua"},{"id":162,"text":"Niger","textEN":"Niger"},{"id":164,"text":"Nigeria","textEN":"Nigeria"},{"id":170,"text":"Niue","textEN":"Niue"},{"id":167,"text":"Norv\u00e8ge","textEN":"Norway"},{"id":161,"text":"Nouvelle-Cal\u00e9donie","textEN":"New Caledonia"},{"id":171,"text":"Nouvelle-Z\u00e9lande","textEN":"New Zealand"},{"id":172,"text":"Oman","textEN":"Oman"},{"id":231,"text":"Ouganda","textEN":"Uganda"},{"id":235,"text":"Ouzb\u00e9kistan","textEN":"Uzbekistan"},{"id":178,"text":"Pakistan","textEN":"Pakistan"},{"id":185,"text":"Palau","textEN":"Palau"},{"id":183,"text":"Palestine","textEN":"Palestine, State of"},{"id":173,"text":"Panama","textEN":"Panama"},{"id":176,"text":"Papouasie-Nouvelle-Guin\u00e9e","textEN":"Papua New Guinea"},{"id":186,"text":"Paraguay","textEN":"Paraguay"},{"id":166,"text":"Pays-Bas","textEN":"The Netherlands"},{"id":30,"text":"Pays-Bas carib\u00e9ens","textEN":"Caribbean Netherlands "},{"id":174,"text":"P\u00e9rou","textEN":"Peru"},{"id":177,"text":"Philippines","textEN":"Philippines"},{"id":181,"text":"Pitcairn","textEN":"Pitcairn"},{"id":179,"text":"Pologne","textEN":"Poland"},{"id":175,"text":"Polyn\u00e9sie fran\u00e7aise","textEN":"French Polynesia"},{"id":184,"text":"Portugal","textEN":"Portugal"},{"id":182,"text":"Puerto Rico","textEN":"Puerto Rico"},{"id":187,"text":"Qatar","textEN":"Qatar"},{"id":41,"text":"R\u00e9publique centrafricaine","textEN":"Central African Republic"},{"id":61,"text":"R\u00e9publique dominicaine","textEN":"Dominican Republic"},{"id":56,"text":"R\u00e9publique tch\u00e8que","textEN":"Czech Republic"},{"id":188,"text":"R\u00e9union","textEN":"R\u00e9union"},{"id":189,"text":"Roumanie","textEN":"Romania"},{"id":77,"text":"Royaume-Uni","textEN":"United Kingdom"},{"id":191,"text":"Russie","textEN":"Russian Federation"},{"id":192,"text":"Rwanda","textEN":"Rwanda"},{"id":66,"text":"Sahara Occidental","textEN":"Western Sahara"},{"id":26,"text":"Saint-Barth\u00e9lemy","textEN":"Saint Barth\u00e9lemy"},{"id":120,"text":"Saint-Kitts-et-Nevis","textEN":"Saint Kitts and Nevis"},{"id":204,"text":"Saint-Marin","textEN":"San Marino"},{"id":141,"text":"Saint-Martin (France)","textEN":"Saint-Martin (France)"},{"id":211,"text":"Saint-Martin (Pays-Bas)","textEN":"Sint Maarten (Dutch part)"},{"id":180,"text":"Saint-Pierre-et-Miquelon","textEN":"St. Pierre and Miquelon"},{"id":237,"text":"Saint-Vincent-et-les-Grenadines","textEN":"Saint Vincent and the Grenadines"},{"id":199,"text":"Sainte-H\u00e9l\u00e8ne","textEN":"Saint Helena"},{"id":128,"text":"Sainte-Lucie","textEN":"Saint Lucia"},{"id":244,"text":"Samoa","textEN":"Samoa"},{"id":11,"text":"Samoa am\u00e9ricaine","textEN":"American Samoa"},{"id":209,"text":"Sao Tom\u00e9-et-Principe","textEN":"Sao Tome and Principe"},{"id":205,"text":"S\u00e9n\u00e9gal","textEN":"Senegal"},{"id":190,"text":"Serbie","textEN":"Serbia"},{"id":195,"text":"Seychelles","textEN":"Seychelles"},{"id":203,"text":"Sierra Leone","textEN":"Sierra Leone"},{"id":198,"text":"Singapour","textEN":"Singapore"},{"id":202,"text":"Slovaquie","textEN":"Slovakia"},{"id":200,"text":"Slov\u00e9nie","textEN":"Slovenia"},{"id":206,"text":"Somalie","textEN":"Somalia"},{"id":196,"text":"Soudan","textEN":"Sudan"},{"id":208,"text":"Soudan du Sud","textEN":"South Sudan"},{"id":130,"text":"Sri Lanka","textEN":"Sri Lanka"},{"id":197,"text":"Su\u00e8de","textEN":"Sweden"},{"id":43,"text":"Suisse","textEN":"Switzerland"},{"id":207,"text":"Suriname","textEN":"Suriname"},{"id":201,"text":"Svalbard et \u00eele de Jan Mayen","textEN":"Svalbard and Jan Mayen Islands"},{"id":213,"text":"Swaziland","textEN":"Swaziland"},{"id":212,"text":"Syrie","textEN":"Syria"},{"id":219,"text":"Tadjikistan","textEN":"Tajikistan"},{"id":228,"text":"Ta\u00efwan","textEN":"Taiwan"},{"id":229,"text":"Tanzanie","textEN":"Tanzania"},{"id":215,"text":"Tchad","textEN":"Chad"},{"id":216,"text":"Terres australes fran\u00e7aises","textEN":"French Southern Territories"},{"id":106,"text":"Territoire britannique de l'oc\u00e9an Indien","textEN":"British Indian Ocean Territory"},{"id":218,"text":"Tha\u00eflande","textEN":"Thailand"},{"id":221,"text":"Timor-Leste","textEN":"Timor-Leste"},{"id":217,"text":"Togo","textEN":"Togo"},{"id":220,"text":"Tokelau","textEN":"Tokelau"},{"id":224,"text":"Tonga","textEN":"Tonga"},{"id":226,"text":"Trinit\u00e9-et-Tobago","textEN":"Trinidad and Tobago"},{"id":223,"text":"Tunisie","textEN":"Tunisia"},{"id":222,"text":"Turkm\u00e9nistan","textEN":"Turkmenistan"},{"id":225,"text":"Turquie","textEN":"Turkey"},{"id":227,"text":"Tuvalu","textEN":"Tuvalu"},{"id":230,"text":"Ukraine","textEN":"Ukraine"},{"id":234,"text":"Uruguay","textEN":"Uruguay"},{"id":242,"text":"Vanuatu","textEN":"Vanuatu"},{"id":236,"text":"Vatican","textEN":"Vatican"},{"id":238,"text":"Venezuela","textEN":"Venezuela"},{"id":241,"text":"Vietnam","textEN":"Vietnam"},{"id":245,"text":"Y\u00e9men","textEN":"Yemen"},{"id":248,"text":"Zambie","textEN":"Zambia"},{"id":249,"text":"Zimbabwe","textEN":"Zimbabwe"}]
this is just a sample. I have a lot of other things to get from my API. I would start with a little sample to understand how to do that.
You would have to loop through this code and insert each record into a lookup form. Then you would use the lookup form content in your dynamic field.
but i have to create an extension ? i have to create a php file ? where to put my php code who get data and send it to formidable form ?
Please login or Register to submit your answer