Sample: Insert or update a record using Upsert

Applies To: CRM Online

This sample code shows how to insert or update records by using the Upsert message. For more information about the feature that this sample demonstrates, see Use Upsert to insert or update a record.

This sample is for Kemas Kini 1 Microsoft Dynamics CRM Online 2015. This is available to download from Insert or update a record using Upsert.

  1. Have access to a Kemas Kini 1 Microsoft Dynamics CRM Online 2015 organization.

  2. Download the UpsertSample Visual Studio project.

  3. Open the UpsertSample Visual Studio project and install Microsoft.CrmSdk.CoreAssemblies version 7.1.0-preview NuGet Package. See Install NuGet packages for instructions.

  4. After you install the NuGet packages, see Run the sample for instructions on how to run the sample and what to expect.

  1. The ProductUpsertSample class Run method calls the ImportUpsertSampleSolution method which first detects whether the UpsertSample managed solution is already installed. If it is not, the file is imported to install this managed solution.

    This managed solution contains a custom sample_product entity that is used by this sample. This entity has a sample_productcode alternate key that creates a unique constraint on the values stored in that attribute.

  2. The WaitForEntityAndKeysToBeActive method is necessary because the alternate keys required for this sample may not be ready immediately after the UpsertSample solution is installed. This method polls the metadata for the sample_product entity to delay the execution of the rest of the sample until the alternate keys are ready.

  3. The first time the ProcessUpsert method is called it processes data in the newsampleproduct.xml file to represent new products. The UpsertRequest is passed to the Execute method to create 13 new records.

    The UpsertResponse.RecordCreated property returns true to indicate that new records were created.

    Before the ProcessUpsert method completes, the program will ask if you want to view the sample product entity records. If you respond with ‘y’ the program will attempt to open Internet Explorer to a view showing the newly created records.

  4. The second time the ProcessUpsert method is called it processes data in the updatedsampleproduct.xml file to represent updates to products previously created. The Upsert message is used to update 6 records. The UpsertResponse.RecordCreated property returns false showing that records were updated.

    Again, the ProcessUpsert method will ask if you want to view the records in the browser. If you already have the view open, you can just refresh the view to observe the changes.

  5. Finally, the DeleteUpsertSampleSolution will prompt you to delete the Upsert Sample managed solution.

    If you choose “y”, the managed solution will be deleted including the sample_product entity and all the data in that entity. Your organization will be left with nothing added to it.

    If you choose “n”, you can inspect the details of the solution including the data created by the sample. But you must manually delete the managed solution to return your organization to the original state.

Use the following steps to install the required assemblies for this sample:

  1. Download this sample and extract the files.

  2. Navigate to the C# folder and open the UpsertSample.sln file using Visual Studio.

  3. In Visual Studio, right-click the UpsertSample project and choose Manage NuGet Packages.

  4. For the preview release, make sure to choose Include Prerelease rather than Stable Only in the search criteria. Then search for “Microsoft Dynamics CRM 2015 SDK core assemblies”. Make sure you select the 7.1.0-preview version.

  5. Click Install. You’ll need to accept the license terms to complete installing this package.

  1. In Visual Studio, with the solution open and the necessary NuGet packages installed, press F5.

  2. If you have not previously run one of the Microsoft Dynamics CRM managed code samples before, you’ll need to enter information to run the code, otherwise enter the number for one of the CRM servers you have previously set up.


    Prompt Description

    Enter a CRM server name and port []

    Type the name of your Microsoft Dynamics CRM server. The default is Microsoft Dynamics CRM Online ( in North America.


    Is this organization provisioned in Microsoft online services (y/n) [n]

    Type y if this is a Microsoft online services provisioned organization. Otherwise, type n.

    Enter domain\username

    Type your Microsoft account.

    Enter password

    Type your password. The characters will show as “*” in the window. Your password is securely saved in the Microsoft Credential Manager for later reuse.

    Specify an organization number (1-n) [1]

    From the list of organizations shown that you belong to, type the corresponding number. The default is 1, indicating the first organization in the list.

  3. The sample will perform the operations described in What this sample does and may prompt you with additional options.

  4. When the sample is complete, press Enter to close the console window.

Microsoft Dynamics CRM 2015 and Microsoft Dynamics CRM Online
Send comments about this topic to Microsoft.
© 2015 Microsoft. All rights reserved.