Skip to Content

Microsoft Dynamics CRM connector Upsert in Jitterbit Design Studio

Introduction

A Microsoft Dynamics CRM Upsert activity, using its Microsoft Dynamics CRM endpoint, updates an existing object record or creates a new object record in Microsoft Dynamics CRM and is intended to be used as a target in an operation.

Creating a Microsoft Dynamics CRM Upsert activity

An instance of a Microsoft Dynamics CRM Upsert activity is created from a Microsoft Dynamics CRM endpoint using its Upsert activity type.

To create an instance of an activity, follow one of these options:

  • Navigate to File > New > Connectors > New MS CRM Upsert.
  • In the tree on the left under Connectors, expand Microsoft Dynamics CRM, then right-click on MS CRM Upserts and select New MS CRM Upsert.
  • In the top toolbar, click the connectors icon. In the dialog, select Microsoft Dynamics CRM, then select MS CRM Upsert.

Configuring a Microsoft Dynamics CRM Upsert activity

Follow these steps to configure a Microsoft Dynamics CRM Upsert activity:

Step 1: Select or create an endpoint

In this step, select or create an endpoint from the Available MS CRM Endpoints dropdown:

attachment

  • Name: After selecting an existing endpoint, you can change the name of the endpoint here.
  • Connection Parameters: After selecting an existing endpoint, its connection parameters are displayed and you can change these parameters here. For more information on each connection parameter, see Microsoft Dynamics CRM connector endpoint.
  • Next: Click to navigate to the next screen.
  • Cancel: Click to close the activity configuration without saving.

Step 2: Select an object

In this step, select the object containing the record to be upserted. Each user interface element of this step is described below.

attachment

  • Filter: Enter any part of the object name into the search box to filter the list of objects. The search is not case-sensitive. If objects are already displayed within the table, the table results are filtered in real time with each keystroke. To reload objects from the endpoint when searching, enter search criteria and then refresh, as described below.
  • Show: Select one of Logical Name or Display Name to change the display of the object names.
  • Selecting an Object: Within the table, click anywhere on a row to select an object. Only one object can be selected. The selected object is highlighted in blue.
  • Refresh: Click to reload objects from the Microsoft Dynamics CRM endpoint. This may be useful if objects have been added to Microsoft Dynamics CRM. This action refreshes all metadata used to build the table of objects displayed in the configuration.
  • Back: Click to return to the previous step.
  • Finish: Click to review the data structures and to complete the activity configuration.
  • Cancel: Click to close the activity configuration without saving.

Step 3: Review the data structures

Any request or response structures generated from the endpoint are displayed. Each user interface element of this step is described below.

attachment

  • Name: Enter a name to identify the activity. The name must be unique for each Microsoft Dynamics CRM Upsert activity.
  • Endpoint: Select or create a new endpoint to be used for the Upsert activity.
  • Edit: Click to edit the selected Microsoft Dynamics CRM connector endpoint.
  • Type: The activity type is displayed here.
  • Object: The previously selected object from Step 2: Select an object is displayed here.

  • Use in an Integration: Select one of Create Operation, Create Request, or Create Response.

    • Create Operation: Click to create an operation using the configured Upsert activity.

    • Create Request: Click to navigate to the Transformation wizard screen, where you can configure a request transformation for the configured Upsert activity.

      For the account object, support for creating or updating an account's owner as a team owner is available with version 1.0.4.0 of the Microsoft Dynamics 365 Cloud connector installer. To provide data for a team owner, provide data for the ownerid node's #text value in the format of team_{GUID}.

    • Create Response: Click to navigate to the Transformation wizard screen, where you can configure a response transformation for the configured Upsert activity.

Next steps

For information on using configured activities in an operation, see these resources: