This content has been marked as final. Show 2 replies
I looked through about 12 different threads and perhaps I am not understanding it.
I built a sample file below for 2 addresses.
My goal is to retrieve back the business name of each address below by using googles API.
When I run this I get an error saying
"This statement only works with lib:// paths in this script mode"
Note: I can't use legacy mode so is there a solution per below ? Thanks
LIB CONNECT TO 'Google Business API';
[Address, City, State, Zip,Lat,Long
111 Huntington Ave , Boston, MA, 02199,-71.081452,42.346097
13 Cayuga Rd, Tewksbury, MA, 01876,-72.081452,41.346097];
Lat&','&Long as GPS
Drop table tmp1;
for vRow = 0 to NoOfRows('tmp') -1
let vAddress = peek('GPS', vRow , 'tmp');
//Latest API call update 02/03/2016
//vAddress here is the Lon/Lat cordinates up top.
'$(vAddress)' as Address,
DROP Table tmp;