How to use Google API to fetch all the cities worldwide in CRM

(0) Share

Report

Posted on by Community Member

Hi Experts,

I want to add an Auto-complete feature on "City" field in CRM. So if user types "A" it should show all the cities in the world with that initial.

How should I accomplish that in CRM? Auto-complete part is doable but my question is how to get list of cities in the world?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

RaviKashyap 55,410 Moderator on at

Like (1)

Report

Hi,

If you know about the auto complete feature, you may already know that the auto complete works on the source of teh list. You need to either have this list within your CRM as entities, or you need to have it hard coded or you need to get this list from some other external api.

It is up to you how you you decide on the data source for the cities. You can refer below links to get some more idea about this-

www.inogic.com/.../design-auto-complete-text-controls-in-dynamics-crm-2016

gis.stackexchange.com/.../free-api-or-database-for-continent-country-city-region-state

www.quora.com/How-can-I-get-cities-and-states-of-a-country-through-Google-API

Hope this helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ravi, Thanks for the response.

Yes I am looking for using google API and if there is any alternative to it for this.

We don'T want it to be hard coded or do not have all cities listed in CRM as entity.

Was this reply helpful? Yes No
Suggested answer

Mahendar Pal 45,095 on at

Like (1)

Report

Hi,

You can't do this for CRM field directly but you can build a html web resource where you can try to connect to google api and then store selected city to internal CRM field.

check these references may it will help you:

stackoverflow.com/.../how-to-limit-google-autocomplete-results-to-city-and-country-only

ubilabs.github.io/geocomplete

Was this reply helpful? Yes No
Suggested answer

Adrian Begovich 1,027 Moderator on at

Like (0)

Report

Hi New Bee,

You can achieve this with JavaScript that runs OnChange of the "City" field. The JavaScript will need to call an API with a list of cities such as the World Cities API, and use the information to populate the "City" field. The World Cities API returns city, state and country in JSON format.

Was this reply helpful? Yes No