Chris, That would be brilliant. Like most of these things once you get going and have something to build on then it's OK... I just don't seem to have any bricks at the moment!
Many thanks.
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Chris Davis Sent: 13 September 2016 13:27 To: profox@leafe.com Subject: RE: Google API for Geocoding ... Again
I could send you some code which uses the vfpconnection from sweet potato, it builds a URL to pass the parameters in (in my case just a uk postcode) and then uses the JSON project from VFPX to process the response and give you the longitude and latitude etc.
Let me know if it sounds close to what is required and I will dig it out this evening.
Regards
Chris.
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Dave Crozier Sent: 13 September 2016 11:44 To: profoxtech@leafe.com Subject: Google API for Geocoding ... Again
Fellow Gentlemen, I posted a request about doing geocoding requests to receive back a Lat/Long dataset for various addresses a few weeks ago and now find that Google do in fact provide a Geocoding service:
https://developers.google.com/maps/documentation/geocoding/start
The responses back from the requests are all JSON from a Java Script API run by Google. I have looked over Rick's Westwind site to try and get a start on using this method to get back a JSON response but seem to be getting nowhere fast. Anyone got any ideas on a simple & neat way of retrieving this data back using VFP programmatically? Either that or anyone know a free Geocoding site that would handle up to 100 name and address calls per day ideally by sending a text file and receiving one back which could be automated from the VFP end.
Never even looked at Web services in anger before so it all seems a little baffling and terribly long winded at the moment unless I am missing something obvious.
Note I don't want to have to drop into an intermediate program/language to accomplish this, if possible.
Dave
[excessive quoting removed by server]