Discussion board where members can learn more about Qlik Sense Data Connectivity.
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.
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