Retrieve Google Geocode from a list of address

[KKWong]

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:

https://maps.googleapis.com/maps/api/geocode/xml?address=$(vVariable)&key=MyKey

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

Would be great if anyone could help.

Regards,

KK

[lorenzoconforti · Accepted solution]

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]);