Retrieve Google Geocode from a list of address

KKWong — Thu, 23 Dec 2021 13:52:54 GMT

Hi,

I have a list of address where I would like to retrieve the geocode from Google Map Geocode API.

Notice that I have to create a connection if I do not disable the Standard Mode (which I prefer).

I have tried to create REST or Web connection and I have input the string with a variable like below:

But seems like the connection could not resolve the variable when I load it out.

Would be great if anyone could help.

Regards,

Re: Retrieve Google Geocode from a list of address

lorenzoconforti — Tue, 31 Mar 2020 15:39:17 GMT

Create your webfile connection then specify your url in your FROM section; e.g.:

FROM [lib://YourConnection] (url is [https://maps.googleapis.com/maps/api/geocode/xml?address=$(vVariable)&key=MyKey], XmlSimple, Table is [YourTablePath]);