Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Loading coordinates from Google maps

Hi guys,

I need your help!

I'm loading Coordinates directly from Google maps API with following code:

//loop each location to get geo info

let noRows = NoOfRows('Locations')-1;

for i=0 to $(noRows)

       

        Data:

        LOAD

        '$(address)' as AddressString,

        '$(loc_key)' as LocationKey,

        '$(address)' as Address,

        '$(i)' as LocationRow_tmp,

        [Response/Placemark/Point/coordinates],

        subfield([Response/Placemark/Point/coordinates], ',' ,1) AS longitude,

        subfield([Response/Placemark/Point/coordinates], ',' ,2) AS latitude,

        [Response/Status/code] AS Statuscode

       

        FROM [http://maps.google.com/maps/geo?q=$(address)&output=xml&oe=utf8&key=MY_KEY&sensor=false] (XmlSimple, Table is [kml]);

       

next

This worked for a long time but since March it doesn't anymore.

I got an API key and changed the "call" by adding the "sensor"-parameter. So the map works again.

But the load above does not get any data back from google.

For each record the statuscode is "610". That means the key I'm using is wrong or something?

G_GEO_BAD_KEY
= 610
The given key is either invalid or does not match the domain for which it was given. 

Can anyone give me some advice how to fix it?

Do I need an other key? which one?

Thanks!

MaciekP

0 Replies