Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i am trying to implement the Map but, i am facing one proble...please see the following code
Table1:
LOAD FirstName,
LastName,
ProductSold,
City
FROM
(biff, embedded labels, table is Sheet1$);
let noRows = NoOfRows('Table1')-1;
for i=0 to $(noRows)
let a=peek('FirstName',$(i),'Table1');
let b=peek('LastName',$(i),'Table1');
let c=peek(‘ProductSold’,$(i),'Table1');
let address=peek('City',$(i),'Table1');
Data:
LOAD
'$(a)' as FirstName,
'$(b)' as LastName,
'$(c)' as ProductSold,
'$(address)' as Address,
subfield([Response/Placemark/Point/coordinates], ',' ,1) AS longitude,
subfield([Response/Placemark/Point/coordinates], ',' ,2) AS latitude
FROM [http://maps.google.com/maps/geo?q=$(address)&output=xml&oe=utf8&sensor=false&key=XXYYZZ] (XmlSimple, Table is [kml]);
next
and see the error in the attached image
can anyone help me out.
Regards,
Rathnam.
Try to access your URL from outside. Is it working? Probably not, hence you get the error message.
then how to resolve it?
Login here: https://code.google.com/apis/console and get your own APIKey, that should help.
Hi all,
I'm also getting the same error when I try to implement google maps.Can anyone tell the reason for this?
I got key for Google Maps JavaScript API v3 access