Error: Input DataSet must contain keycolumn(s) in Upsert/Update scenario. Missing key column(s) in Microsoft Azure Data Factory

Azure Data Factory and CRM

Got the below error while creating the records in CRM Online from an Azure Blob storage (CSV file) using Microsoft Azure Data Factory.

“errorCode”: “2200”,
“message”: “Failure happened on ‘Sink’ side. ErrorCode=UserErrorMissingValidKey,’Type=
Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Input DataSet must contain keycolumn(s) in Upsert/Update scenario. Missing key column(s): contactid,Source=Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin,'”,
“failureType”: “UserError”,
“target”: “Create CRM records from Azure Blob Storage”

The above error is because of the GUID column data was missing in the CSV file. Updated the data with GUID Column and saved the data in Azure Blob storage.

Reconfigured the Azure Blob Storage (Source) and Sink (Destination) Schemas and Mapping values in Azure Pipeline. Published all pending changes.

Triggered the pipeline, it ran successfully and records created in CRM.

Below article is well explained in detail, to create CRM records using Azure Blob storage (CSV file) and Microsoft Data Factory.

Azure: Copy Data from CSV file to D365 instance using Azure Data Factory

Click here to know about more about Azure Data Factory.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.