Skip to main content

Notifications

Announcements

Forum Structure Changes Complete – Update Your Subscriptions!
News and Announcements icon
Dynamics 365 Community / Blogs / Dynamics 365 Education and Knowledge / CREATE OR UPDATE (UPSERT) R...

CREATE OR UPDATE (UPSERT) RECORDS USING ALTERNATE KEYS IN DYNAMICS 365 SDK

Charles Abi Khirs Profile Picture Charles Abi Khirs 3,569

In another post, we saw how to retrieve a record based on alternate key in Dynamics 365 using the SDK

In this post, we will see how to create or update (upsert) a record based on alternate key in Dynamics 365 using the SDK .

The below sample code can be used to achieve the UpdateRequest.

  1. For the sake of this post, the alternate key is set up on the Account Name (name) field of the account entity.

    public void UpsertRecordByKey()
    {
    KeyAttributeCollection keys = new KeyAttributeCollection
    {
    { Account.Fields.Name, "cak account" }
    };
    Account objAccount = new Account();
    objAccount.Name = "cak account";
    UpsertRequest request = new UpsertRequest()
    {
    Target = objAccount
    };
    try
    {
    UpsertResponse response = (UpsertResponse)AdminService.Execute(request);
    if (response.RecordCreated)
    {
    //Do something here
    }
    else
    {
    //Do something else here
    }
    }
    catch (Exception ex)
    {
    }
    }
  2. You will get exception if there is no record with the specified key value, or no key is added to the specified entity.
    The specified key attributes are not a defined key for the account entity

Hope This Helps!

This was originally posted here.

Comments

*This post is locked for comments