Palladian Google Address Geocoder

I’m using til Google Address Geocoder from Palladian - it works fine on some addresses, but on others I get the following error:

Execute failed: ws.palladian.extraction.location.geocoder.GeocoderException: Error while parsing JSON result ({ “results” : [ { “address_components” : [ { “long_name” : “Brobjerg Parkvej”, “short_name” : “Brobjerg Parkvej”, “types” : [ “route” ] }, { “long_name” : “Egå”, “short_name” : “Egå”, “types” : [ “locality”, “political” ] }, { “long_name” : “Denmark”, “short_name” : “DK”, “types” : [ “country”, “political” ] }, { “long_name” : “8250”, “short_name” : “8250”, “types” : [ “postal_code” ] } ], “formatted_address” : “Brobjerg Parkvej, 8250 Egå, Denmark”, “geometry” : { “bounds” : { “northeast” : { “lat” : 56.2064974, “lng” : 10.2671539 }, “southwest” : { “lat” : 56.202914, “lng” : 10.2569818 } }, “location” : { “lat” : 56.204817, “lng” : 10.2615945 }, “location_type” : “GEOMETRIC_CENTER”, “viewport” : { “northeast” : { “lat” : 56.2064974, “lng” : 10.2671539 }, “southwest” : { “lat” : 56.202914, “lng” : 10.2569818 } } }, “place_id” : “ChIJ9bly6Iw-TEYRTu_aMUfdQGc”, “types” : [ “route” ] } ], “status” : “OK” }).

The address is valid, and it seems like the feedback from Google in the above error code is legit.

I’m searching the address Brobjerg Parkvej, 8250 Egå, Denmark

What am I missing?

I other cases I’m getting the following error - I’ll provide more info if this is needed
ERROR Google Address Geocoder 8:157 Execute failed: JSON array initial value should be a string or collection or array.

Thanks - I’ll have a look. Could you by any chance supply a workflow with the input data which produces above error? That would be great!

-Philipp

Geocoding.knwf (77.1 KB)
Wow that was fast :slight_smile:

I’ve made two simple workflows, one that work and one that dosen’t.

Knime version 5.3.1

1 Like

Many thanks - I have to admit that I can currently not reproduce this - both nodes execute perfectly fine for me. However, I’ve tested this with a KNIME 5.3 (not 5.3.1) version. I’ll have a look at 5.3.1 tomorrow.

Stupid question:

  1. If you simply re-execute the failing node again, does it still fail? (I assume so, but worth checking)

  2. You could do me a huge favor, if you could enable the DEBUG logging in your KNIME settings (use the “classical” UI, go to preferences and go to “KNIME classic user interface”, and set the console (!) log level to DEBUG). Then please re-execute the failing node and copy all the log lines which appeared in the “Console” tab. Feel free to send this to mail@palladian.ws in case you’d rather not share it publicly.

Thank you!
Philipp

Hi Philipp

I’ve send a mail with the debug logs.
I was using 4.7 first and tried 5.3.1 to see if I got the same error in that version.
So I’ve send the debug logs from both.

And thank you too :smiley:

/Esben

1 Like

Update: We have fixed this in Palladian Nodes v3.1.1.

Thanks again to @esben for reporting this!

2 Likes