Answered

Dataverse Custom API Alternate key

Like (0) Share

Report

Posted on 20 Oct 2022 19:22:42 by BartoszP

Hi,
Is it possible to use alternate key on custom api when input parameter is type of Entity Reference. Then in payload to custom api call instead of entity reference in form of table name and record id use, alternate key from source table.

example payload:

{
 "contactid": {
 "@odata.type": "Microsoft.Dynamics.CRM.contact",
 "customalternatekey" : "uniquevalue01"
 }
}

C# example call:

EntityReference contactIdKey= new EntityReference("contact", "customalternatekey", "uniquevalue01");
 OrganizationRequest request = new OrganizationRequest("new_apitest")
 {
 Parameters =
 {
 ["contactid"] = contactIdKey,
 
 }
 };

 var response = client.Execute(request);

Categories:

Microsoft Dataverse

All responses (4)

Answers (1)

a33ik 3,304 Most Valuable Professional on 21 Oct 2022 at 13:28:50

Like (0)

Report

Re: Dataverse Custom API Alternate key

Thanks for the interesting discovery! Never thought to use the alternate key that way!
Guido Preite 1,488 Super User 2024 Season 1 on 21 Oct 2022 at 07:16:12

Like (0)

Report

Re: Dataverse Custom API Alternate key

thanks for the confirmation!
Verified answer

BartoszP 16 on 21 Oct 2022 at 07:13:23

Like (2)

Report

Re: Dataverse Custom API Alternate key

I checked it again on morning and it was issue with my plugin that give error with dictionaries, and I was almost sure it was corelated with payload data.
So alternate key for custom API are working.
Guido Preite 1,488 Super User 2024 Season 1 on 20 Oct 2022 at 20:26:27

Like (1)

Report

Re: Dataverse Custom API Alternate key

interesting question, honestly I never tried but I don't think it's possible. Did you try and got a specific error?

EDIT: user confirmed is possible