Customer experience | Sales, Customer Insights,...

Alternate key

(0) Share

Report

Posted on by Anandhcrm

Hi,

I need to create a alternate key for emailaddress1 in contact entity. Since the entity has already thousands of records having empty email address, it doesnt allow to create alternate key. I need this to be created, because, the third party vendor passing emailaddress as the reference for the contact entity record. Is it any work around to create the alternate key.

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

XM-22040801-0 11 on at

Like (0)

Report
Hi,

You can create an alternate key with a null value in your records. You must not have any duplicates (except for nulls).

If you have empty strings, you can replace them with null in order to create your key.

Example:
I have records with null in emailadress1.

But, I can use the alternate key to find an account.

Used query:

/api/data/v9.2/accounts(emailaddress1='someone6@example.com')

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello,

Blank (null-valued) fields shouldn't be a problem creating alternate keys - I'm pretty sure it's related to duplicates within the table.

I experienced a similar situation and in order to identify duplicate records I used the following approach:

1. I created a DB and exported the data from the table into it.

2. I run a query to identify duplicated emails.

3. Having duplicated emails through the dataverse interface I just found records and either deleted duplicates or updated emails to remove that constraint.

An alternate approach you can rely on is duplicates detection - create a duplicate detection rule by your email address and run the duplicates detection job. Go and fix the results of that job.

Once you have your duplicates cleaned up - you would be able to enable your alternate key.

Was this reply helpful? Yes No
Suggested answer

ankit_singhal 560 on at

Like (0)

Report

I think there is no way OOB in online CRM but you can write custom code and apply that on pre validation

Was this reply helpful? Yes No