Got the below error while creating the records in CRM Online from an Azure Blob storage (CSV file) using Microsoft Azure Data Factory.
“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,'”,
“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.