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.

All responses (3)

Answers (0)

Suggested answer

Bipin D365 28,961 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
Suggested answer

Bipin D365 28,961 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
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