0 Replies Latest reply: Apr 11, 2013 8:56 AM by Mathias Pietrus RSS

    Loading coordinates from Google maps

    Mathias Pietrus

      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