Customer experience | Sales, Customer Insights,...

Update (Patch) Contact using email address instead of contact id

(0) Share

Report

Posted on by RS-07051616-0

=eeWe have a use case where in we need to update a contact in Dynamics CRM using contact's email address instead of the contact id. Here is what the API documentation says:

PATCH [Organization URI]/api/data/v9.0/contacts(contactid)

Can we do as below:

PATCH [Organization URI]/api/data/v9.0/contacts?emailaddress1=name@yahoo.com

Any help would be appreciated.

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Bipin D365 28,981 Moderator on at

Like (0)

Report

Update (Patch) Contact using email address instead of contact id

Hi,

Please check below article to define alternate key for your table

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/use-alternate-key-reference-record?tabs=webapi

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,981 Moderator on at

Like (0)

Report

Update (Patch) Contact using email address instead of contact id

Hi,

You can define alternate key as your Email address field and use below syntax to update contact by email address

PATCH [Organization Uri]/api/data/v9.2/example_records(example_key1=2)

More details can be found on below link

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/use-upsert-insert-update-record

Was this reply helpful? Yes No
Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

Update (Patch) Contact using email address instead of contact id

Hi,

Unfortunately, it is impossible.

You must use the contactid, which is a GUID and is unique within that environment.

So you need use it to find correct record to update it.
More information:
https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/update-delete-entities-using-web-api

I hope you can mark my answer verified if it answer your question! If you have any questions, please feel free to contact me.
Regards,
Leah

Was this reply helpful? Yes No

Community site session details

Update (Patch) Contact using email address instead of contact id

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Mansi Soni – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Update (Patch) Contact using email address instead of contact id

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Mansi Soni – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates