Contact Us Today!

GeoCoding for Microsoft Dynamics CRM

smartphone-695165__180

We often receive requests from customers to calculate geographic coordinates for their clients.  These can be used to display your clients on a geographical map within CRM. This is helpful to sales associates when traveling.  So, how can this be accomplished?

CRM natively includes latitude and longitude fields for certain out of the box entities, such as Accounts.  However, there is no automated way natively built into CRM for populating these fields without third party apps/custom code.  As a developer, there are many ways to accomplish this. One that we’ve used here is through a custom workflow which sends HTTP GET requests to a web service built for calculating geocodes.  This workflow can then be triggered when the address is added or changed on an Account.

Several companies exist which offer these services, including Microsoft. They offer a few different tools, including their Bing Maps REST Services Locations API.  To use the Bing Maps Services, you must have a BingMapsKey.  The following link walks you through on how to obtain one: https://msdn.microsoft.com/en-us/library/ff428642.aspx
Once you have your key, you can test it out by making a call to their web service and retrieve the XML response with geographic coordinates.  Here is a sample of what some of that code looks like:

BingMapsGeoCode

This code can also be combined with other tools to search for points of interest near the intended location.
For more information on how this functionality can be set up, please refer to:  https://msdn.microsoft.com/en-us/library/hh757509.aspx

If you are interested in geocoding within your CRM application, please reach out to Beringer, a Microsoft Gold Certified Partner.


theProfessor

theProfessor

Rob is the CTO of Beringer Technology Group, and focuses his efforts on software development, cloud engineering, team mentoring and strategic technical direction. Rob has worked with Beringer since 2005, and has influenced every department from Development, Security, Implementation, Support and Sales. Rob graduated with his MBA from Rowan University in 2012, earned his Bachelors of Computer Science in 1997, and is current with several Microsoft technical certifications. Rob is very active, and loves to mountain bike, weight train, cook and hike with his dog pack.