Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 rathnam_qv
		
			rathnam_qv
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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.
 tresesco
		
			tresesco
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Try to access your URL from outside. Is it working? Probably not, hence you get the error message.
 rathnam_qv
		
			rathnam_qv
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		then how to resolve it?
 tresesco
		
			tresesco
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Login here: https://code.google.com/apis/console and get your own APIKey, that should help.
 
					
				
		
 adarsh_a
		
			adarsh_a
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
