API Connection to Google Places?

stockisteven — Sun, 24 Dec 2017 01:40:25 GMT

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';

tmp1:

LOAD* INLINE

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

tmp:

NoConcatenate

LOAD*,

Lat&','&Long as GPS

Resident tmp1;

Drop table tmp1;

for vRow = 0 to NoOfRows('tmp') -1

let vAddress = peek('GPS', vRow , 'tmp');

//Latest API call update 02/03/2016

Addresses:

LOAD

//vAddress here is the Lon/Lat cordinates up top.

'$(vAddress)' as Address,

"place_id",

"rating",

"reference",

"scope",

"vicinity"

(JSON);

DROP Table tmp;

Re: API Connection to Google Places?

stockisteven — Mon, 25 Dec 2017 21:54:22 GMT

bump - thanks

Anonymous — Thu, 04 Jan 2018 15:21:10 GMT

Hi Steven, To avoid the error shown in the screenshot .. You have to use legacy mode any how.

If you don't want to use legacy mode then using rest connector but it will work for single request, not overriding multiple parameters.