No worries glad it was of use > On 14 Sep 2016, at 09:47, Dave Crozier <[email protected]> wrote: > > Chris, > With a few modifications unique to how I WANT IT TO FUNCTION THAT WORKED LIKE > A DREAM > > Thanks for the input! > > Dave > > > -----Original Message----- > From: ProFox [mailto:[email protected]] On Behalf Of Chris Davis > Sent: 13 September 2016 16:33 > To: [email protected] > Subject: RE: Google API for Geocoding ... Again > > FUNCTION geocode > LPARAMETERS lcpostcode > > lcurl="http://maps.googleapis.com/maps/api/geocode/json?address=##ADDRESS##"; > > lojson=NEWOBJECT('json') > > lctempurl=STRTRAN(lcurl,"##ADDRESS##",STRTRAN(ALLTRIM(lcpostcode)," ","")) > lcget=httptostr(lctempurl) > lcret="" > loquery=lojson.decode(lcget) > IF ALLTRIM(loquery.get("status"))="OK" > loresult=loquery._results.get(1) > logeo=loresult.get("geometry") > loloc=logeo.get("location") > > lcret=ALLTRIM(TRANSFORM(loloc.get("lat")))+","+ALLTRIM(TRANSFORM(loloc.get("lng"))) > endif > > RELEASE lojson > > RETURN lcret > > Json code is from https://github.com/sait/vfpjson Httptostr is part of > vfpconnection from sweet potato > > > > -----Original Message----- > From: ProfoxTech [mailto:[email protected]] On Behalf Of Dave > Crozier > Sent: 13 September 2016 16:26 > To: [email protected] > Subject: RE: Google API for Geocoding ... Again > > Alan, > Your solution worked like a dream, thanks. Just knocking it into a useable > class now to allow input and output from our system within the daily > constraints set by Google on free accounts. > > Looks like I won't have to pull any more of my "minimalist" hair out tonight!! > > Dave (& Tom) > > > -----Original Message----- > From: ProFox [mailto:[email protected]] On Behalf Of Alan Bourke > Sent: 13 September 2016 16:15 > To: [email protected] > Subject: Re: Google API for Geocoding ... Again > > Or you can just use the WinHTTP library in Windows as per the Gist I linked > earlier, and get a string back straight into VFP. The hardest part of all > this is going to be parsing the JSON to be honest. > > -- > Alan Bourke > alanpbourke (at) fastmail (dot) fm > [excessive quoting removed by server]
_______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
