[AccessD] Google API for address sanitising

[John Bodin]

Not sure where you found that Gustav, but works really well, and fast!  Put that one in the utility chest.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Wednesday, December 21, 2016 2:34 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Google API for address sanitising

Hi all

Did you know that you can sanitise an address by a single call to Google API? It even accepts our European and localised spelling and returns these correctly. For example, a call containing our malformed company address:

    https://maps.googleapis.com/maps/api/geocode/json?address=kalkbranderiloebsk 4A, DK - 2100 København

returns a Json with the correct spelling and postal code (country code DK should not be prefixed):

    "Kalkbrænderiløbskaj 4A, 2100 København Ø, Danmark",

Replace the commas, and you have the correct address block:

    Kalkbrænderiløbskaj 4A
    2100 København Ø
    Danmark

Indeed, for our US friends it can very useful, as you have a bad habit of abbreviating street names.

As you may know, there is a limit for free calls of 2000 per day. If more, you need a paid license - it should be quite fair though.

/gustav
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com