[AccessD] Google API for address sanitising

[Gustav Brock]

Hi Arthur

1: Yes.
2: JSON is nothing but text that describes an object.

For the full info, pass the full text to a JSON parser. If you just want the formatted address, parse the string for that field and read the contents. Split this by the commas into it parts, or simply replace the commas with CRLF to have an address block for, say, to print on an envelope.

Happy New Year to you and all joining AccessD!
Gustav

Fra: Arthur Fuller<mailto:fuller.artful at gmail.com>
Sendt: 31. december 2016 18:10
Til: Access Developers discussion and problem solving<mailto:accessd at databaseadvisors.com>
Emne: Re: [AccessD] Google API for address sanitising

Gustav,

A couple of questions from a stupid person:

1. From your example it appears that the full call is the URL + the address
to sanitize. Given most databases containing addresses, street name, city,
district, postal code and country would all be in separate fields. So is
the correct strategy to assemble a string containing all the pieces and
pass that along with the URL?

2. You say it returns a JSON containing the sanitized address. By "returns"
I'm guessing that I declare a variable, assign the URL and address string
to it; it receives the JSON object as returned. I then replace the commas
with vbCRLF.

Is this correct?

Happy New Year!

/Arthur