GeoTAX Location Result - Precisely Data Integrity Suite

Use this query to check the results:

select * from geotax_result;

Use this query to validate the successful results:

select count(id) from geotax_result 
where parse_json(geotaxResponse):status = 'OK';

Use this query to verify the records that were unable to processed by GeoTAX Location:

select count(id) from geotax_result 
where parse_json(geotaxResponse):status != 'OK';