Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I an trying to extract google lat and lng using following script , but it gives error : [result/geometry/location/lng] not found
address:
LOAD A as Address
FROM
(ooxml, no labels, table is Sheet1);
let noRows = NoOfRows('address')-1;
for i=0 to $(noRows)
let a=peek('Address',$(i),'address');
Data:
LOAD
'$(a)' as Address,
[result/geometry/location/lng] AS longitude,
[result/geometry/location/lat] AS latitude
FROM [http://maps.googleapis.com/maps/api/geocode/xml?address=$(a)&sensor=false];
drop Table address;
Please help
Hi.
I'm using geocoding.qvw.
I have a different "from".
FROM [http://maps.google.com/maps/api/geocode/xml?sensor=false&ie=utf8®ion=$(vTLD)&address=$(vAddress)] (XmlSimple, Table is [GeocodeResponse]) |
you need to set up some variable before (inside for...next)
Alessandro Furtado
Hi,
Check this script, I am getting the values. May be check whether the proxy is blocking any request. In some companies they will block, you check in machine which has full internet access without any blocking.
GeocodeResponse:
LOAD status,
[result/geometry/location/lat] as [location/lat],
[result/geometry/location/lng] as [location/lng],
%Key_GeocodeResponse_62C7A0A69859D655 // Key for this table: GeocodeResponse
FROM [http://maps.googleapis.com/maps/api/geocode/xml?address=Delhi&sensor=false] (XmlSimple, Table is [GeocodeResponse]);
Regards,
Jagan.