Skip to main content

#Address Verification Errors0 debatiendo

We recently switched our NPSP org to Google Geocoding for address verification from the Cicero NPSP connector (RIP). It has mostly worked as expected, but I noticed that we've received a handful of

"REQUEST_DENIED: indicates that your request was denied." errors since we switched over a week ago (see below):Google Geocoding Address Verification errors when using # symbolAll of the addresses that were rejected include the # (number symbol/pound sign) character, which is a pretty common shorthand for unit/apt number. I tested and confirmed that removing the # character fixes the issue.

 

Has anyone else come across this issue? If yes, what workarounds/solutions were used? #NPSP #Address Verification Errors #Google #Cicero

1 respuesta
  1. 10 jun 2024, 16:12

    I also came across this issue - but I didn't come up with a solution - just letting you know you're not alone. If you switch the # symbol with things like "Unit" or "Ste" or "Apt," it can verify the record. Thinking about it now, I would think a before-save flow (so it happens before the verification takes place, I think) that replaces the "#" with "Unit" (or some word like that) might work.

0/9000

I'm experiencing a bug with Google Address Verification where it strips out the entire first line. In on example today, the original address was something like  764 Cambridge, Charlottesville, VA 12345. When I submitted it for verification in that format, it stripped the first line. Next, I tried 764 Cambridge St, Charlottesville VA 12345. In that case, it corrected St to Ave and left the rest of the line alone.

 

@Robin Gardiner and I seem to be having related issues. From her earlier post, "I seem to be having a similar issue where the entire street address(number and street name) gets stripped, regardless of whether there is an apartment number attached (of course I am ensuring that a comma is present before the apt number)--I'm seeing a trend that it happens when there is a "NW" or "SE" in the street address (a la Washington, DC or Seattle, WA addresses, but to be fair we are based in DC so we have A LOT of these) but it's not a hard and fast rule--I just literally can't find any other similarities among the ones it's messing up."

 

@Salesforce.org System Administrators #Address Verification Errors #Address Verification  #Google Geocoding 

 

cc: @Chris Pifer 

3 respuestas
  1. 18 jul 2016, 22:18

    I've been having issues with Google Geocoding API, also. Everything I submit - even addresses previously verified by SmartyStreets and addresses that are outrageously wrong "Avenuesty" instead of "St" - is coming back flagged as ambiguous. I found another thread that suggested unchecking the "reject ambiguous addresses" checkbox, and doing that stripped in one case the entire street and in the other one I tested all but ", Apt 108".

    I turned that sucker right back on.

    @Nonprofit Success Pack @Nonprofit Hub
0/9000