Problem:

How to use Loqate AVC to choose which addresses get imported.

Solution:

A new parameter, "verificationStatusMapping", has been added to the "options" section of the cleansing function. 

The order of verification statuses is important. If several AVC codes match several statuses according to verificationStatusMapping, the highest in the order of statuses will be chosen. For example, "Verified" is higher in the order than "Partially Verified", so it would be chosen. After each verification status goes an array of regular expressions. According to them, the status will be set if AVC status matches a regular expression. If "verificationStatusMapping" exists in the configuration and "ovOnly" is "true", only AVCs matching "Verified" status get Reltio Cleanser Crosswalk.

Here is an example:

{  
   "cleanse":[  
      {  
         "cleanseFunction":"Loqate",
         "options":{  
            "loqateKey":"2ebdcf4ae28ff15c3dc7ba6dc3d465125b1c38e0",
            "ovOnly":"true",
            "verificationStatusMapping":{  
               "Verified":[  
                  "V.*",
                  "P..-I2.-P(6|7)-(100|09.)",
                  "A..-I(4|5).-P(6|7)-(100|09.)"
               ]
            }
         }
      }
   ]
}

According to this example all verified AVC (starts with "V"), Partially Verified like "V22-I22-P6-99", and "A22-I44-P6-100" will be cleansed. Also, the user can declare some verified AVCs as partially verified like this.

  
   "cleanse":[  
      {  
         "cleanseFunction":"Loqate",
         "options":{  
            "loqateKey":"2ebdcf4ae28ff15c3dc7ba6dc3d465125b1c38e0",
            "ovOnly":"true",
            "verificationStatusMapping":{  
               "Partially Verified":[  
                  "P.*",
                  "V..-I22-P(3|4)-(0|1|2|3)."
               ],
               "Verified":[  
                  "V.*"
               ]
            }
         }
      }
   ]
}

In that case, AVC like "V22-I22-P4-30" will be set as Partially Verified and Reltio Cleanser Crosswalk won't be added.

The below example excludes partially-verified addresses:

"params": {

  "verificationStatusMapping": {

   "Verified": [
    "V.*",
    "A..-I(4|5).-P(6|7)-(100|09.)"
 ],
  "Unverified": [ "U.*" , "P.*"]

Next, use the below API to re-cleanse with a forceCleansing option.

POST <env_uri>/reltio/api/<tenantId>/cleanse?entityType=Organisation &forceCleansing=true
Optional Body: ["entities/", "entities/",...]