[AccessD] Automating Google Maps

[Jim Dettman]

BTW, if you are going the API route, you should also get Postman:

https://www.postman.com/downloads/

 as it can be very helpful in exploring and testing out calls to API's.

Jim.

-----Original Message-----
From: AccessD On Behalf Of Jim Dettman via AccessD
Sent: Tuesday, March 14, 2023 6:39 AM
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Cc: Jim Dettman <jimdettman at verizon.net>
Subject: Re: [AccessD] Automating Google Maps


 I've done some.   Used a web browser control to allow users to pin-point a
location, then got a lat/long for distance calculations from the returned
URL string.

 That was a fly under the radar type of thing as the client didn't want to
pay for the API calls (most sites charge for you to use their API based on
usage).

 If you are going to call the API directly, then I would use the VBA WEB
lib:

https://github.com/VBA-tools/VBA-Web

  While you can set a ref to the MSXML2.XMLHTTP60 lib and do the calls
yourself, far easier to use the lib.    Little bit of a learning curve to
it, but once you've used it a time or two, it really simplifies a lot of
things and most importantly, it has oAuth, which many sites are now starting
to use.

  Has lot's of good code, examples, and procedures that you can use.  It has
a built-in JSON parser, can handle XML, and lots of helper functions to aid
with calling API's. There are tutorials and YouTube video's on using it as
well.

 You'll like it (based on classes).   Great piece of work done by Tim.

Jim.


-----Original Message-----
From: AccessD On Behalf Of John Colby
Sent: Monday, March 13, 2023 1:30 PM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>; John Colby <jwcolby at gmail.com>
Subject: [AccessD] Automating Google Maps

Have any of you done any map automation?  I am looking to feed it addresses
and have it bring up a browser (edge or google presumably) and map the
address.  Get back turn by turn instructions.  Etc.

-- 
John W. Colby
Colby Consulting
-- 
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

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