524
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 think there is no way OOB in online CRM but you can write custom code and apply that on pre validation
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.
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')
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (