Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
KKWong
Contributor
Contributor

Retrieve Google Geocode from a list of address

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

Labels (4)
1 Solution

Accepted Solutions
lorenzoconforti
Specialist II
Specialist II

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

View solution in original post

1 Reply
lorenzoconforti
Specialist II
Specialist II

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

View solution in original post