Google Address Lookup is broken - API changed?

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Create a new cleansing project
2. Create a new transformation with a Google Address Lookup step
3. Run cleansing engine in debug mode

What is the expected output? What do you see instead?
Google Address Lookup steps should complete successfully. A error is
generated during engine run - check error stack trace below.

What version of the product are you using? On what operating system?
0.9.5 in OS X.

Error Stack Trace:

(...)
2010-01-07 17:09:41,348 DEBUG Address Lookup Response for "Courts, Dubai,
UAE": {
  "name": "Courts, Dubai, UAE",
  "Status": {
    "code": 200,
    "request": "geocode"
  },
  "Placemark": [ {
    "id": "p1",
    "address": "Dubai Courts 1 - Dubai - United Arab Emirates",
    "AddressDetails": {
   "Accuracy" : 9,
   "AddressLine" : [ "Dubai Courts 1" ]
},
    "ExtendedData": {
      "LatLonBox": {
        "north": 25.2501966,
        "south": 25.2439014,
        "east": 55.3237266,
        "west": 55.3174314
      }
    },
    "Point": {
      "coordinates": [ 55.3205790, 25.2470490, 0 ]
    }
  }, {
    "id": "p2",
    "address": "Dubai Courts 2 - Dubai - United Arab Emirates",
    "AddressDetails": {
   "Accuracy" : 9,
   "AddressLine" : [ "Dubai Courts 2" ]
},
    "ExtendedData": {
      "LatLonBox": {
        "north": 25.2511176,
        "south": 25.2448224,
        "east": 55.3225256,
        "west": 55.3162304
      }
    },
    "Point": {
      "coordinates": [ 55.3193780, 25.2479700, 0 ]
    }
  } ]
}

2010-01-07 17:09:41,350 DEBUG Rolling back a_buildings1_dub
2010-01-07 17:09:41,351 DEBUG Closing MungeStep a_buildings1_dub
2010-01-07 17:09:41,351 DEBUG Closing MungeStep Upper Case
2010-01-07 17:09:41,351 DEBUG Closing MungeStep Translate Words
2010-01-07 17:09:41,351 DEBUG Closing MungeStep String constant
2010-01-07 17:09:41,351 DEBUG Closing MungeStep String constant
2010-01-07 17:09:41,352 DEBUG Closing MungeStep Concat
2010-01-07 17:09:41,352 DEBUG Closing MungeStep Google Maps Address Lookup
2010-01-07 17:09:41,352 DEBUG Closing MungeStep a_buildings1_dub
2010-01-07 17:09:41,352 ERROR 0/1: Cleanse Engine failed
2010-01-07 17:09:42,079 ERROR Error during engine run
java.lang.RuntimeException: org.json.JSONException: JSONObject["Country"]
not found.
    at ca.sqlpower.matchmaker.CleanseEngineImpl.call(CleanseEngineImpl.java:231)
    at
ca.sqlpower.matchmaker.swingui.engine.EngineWorker.doStuff(EngineWorker.java:117
)
    at ca.sqlpower.swingui.SPSwingWorker.run(SPSwingWorker.java:60)
    at java.lang.Thread.run(Thread.java:637)
Caused by: org.json.JSONException: JSONObject["Country"] not found.
    at org.json.JSONObject.get(JSONObject.java:422)
    at org.json.JSONObject.getJSONObject(JSONObject.java:516)
    at
ca.sqlpower.matchmaker.munge.GoogleAddressLookup.doCall(GoogleAddressLookup.java
:146)
    at
ca.sqlpower.matchmaker.munge.AbstractMungeStep.call(AbstractMungeStep.java:633)
    at ca.sqlpower.matchmaker.munge.MungeProcessor.call(MungeProcessor.java:100)
    at ca.sqlpower.matchmaker.munge.MungeProcessor.call(MungeProcessor.java:58)
    at ca.sqlpower.matchmaker.CleanseEngineImpl.call(CleanseEngineImpl.java:214)
    ... 3 more

Original issue reported on code.google.com by lunasilv...@gmail.com on 7 Jan 2010 at 7:27