Address mapping

Mapping allows you to map a collection of data values returned by the Experian Address Validation API (and additional Enrichment API if configured) to a collection of Microsoft Dynamics entity fields.

A address mapping is always associated with a single entity and must be named. An entity may have as many address mappings configured as there are addresses held by the entity.

The solution comes pre-configured with two simple address mappings (named Address1 and Address2) for the address1_* and address2_* fields of the 4 standard entities:

  • Account
  • Competitor
  • Contact
  • Lead

These pre-configured mappings may be used out-of-the-box to perform simple address searches on the standard entities, but can be modified to suit your needs. You can also create new address mappings for any Microsoft Dynamics entity.

Configuring an address mapping

First select an existing mapping or add a new one:

  1. Go to the Experian Data Validation Configuration Power App.
  2. Select the Map fields page from the left menu.
  3. From the entities list on the left select the entity for which you want to configure an address mapping.
  4. Either select an existing mapping from the list in the MAPPINGS column or click + Add in the top menu to create a new mapping.
  5. If adding a new mapping, select the Entity name, provide a Mapping name and then click Add.

The properties from our APIs are split across two tabs:

  • Standard address fields - the 7 standard address fields plus optional validation message and timestamp fields
  • Address data fields - the additional address data fields grouped into Components, Metadata and Enrichment, which will only appear if enabled on the Additional data page

The process for mapping the fields is identical for both tabs:

  1. Under each API property is a combo box that contains the fields of the associated entity. Click on each combo box and select the field that you want populated with that API value. The list is separated into three types for convenience, depending on the data type of the field:
    • Text - the text value returned by the API is stored in the field.
    • Choice - the item selected for the choice field will be the one where the text of the choice item matches the text returned by the API using a case insensitive match. (Choice refers to Option Set in the Classic version)
    • Lookup - the lookup record selected for the field will be the one where the text of the primary name column of the Lookup entity matches the text returned by the API using a case insensitive match.
  2. Optionally, if you want to save the validation message and timestamp, select the fields created previously from the combo boxes for the Address validation message and Address validation timestamp API properties. See Validation tracking fields if you have not yet created these special fields.
  3. For any standard or additional address data fields that you want to ignore, choose the value Not mapped from the combo box.

Example address mapping

An example of the mapping from standard address properties to entity fields would be:

Standard address property Entity field
Address line1 address1_line1
Address line2 address1_line2
Address line3 address1_line3
Address locality address1_city
Address province address1_stateorprovince
Address postal code address1_postalcode
Address country address1_country

Example of standard address field mapping