Address parsing and cleansing #3
Description
Pulled from the app repo.
Currently a job is automatically geocoded when it has no coordinates and when the SiteAddress is not empty. Some customers have records in their database with e.g. SiteAddress = ", , " because NAV/BC has no address details and the connector is not always taking that into account (certainly where the connector was customized).
Can we add another check before sending the request to PTV? We could strip some specific characters from the string and see if it is empty after doing that. Characters could be ",.-" and maybe more. When the string is empty, the request should not be sent.
Example for customer [redacted]: they have around 38500 records like this in their database which results in more than 1.000.000 calls per month that are not needed. I asked them to change the connector code and to empty the field in the Job table.