3Hello,
I am trying to move consent records from an on-prem source system into dataverse (CIJ). I am specifically trying to create Purpose type consents. I followed the instructions to setup mapping fields for a lookup column as per microsoft documentation using a copy activity in Fabric pipeline. For the purpose lookup (msdynmkt_purposeid) i am mapping to the msdynmkt_purposeid field and msdynmkt_purposeid@EntityReference to which i am passing the value "purpose". As per microsoft documentation, i should be passing the table name.
Passing the entity reference as an additional column in the source:
I have tried the table name and the schema name (msdynmkt_purpose) and in both cases i am getting the error:
ErrorCode=DynamicsOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Dynamics operation failed with error code: -2147220989, error message: Invalid type for entity id value.,Source=Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin,''Type=System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=9.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]],Message=The creator of this fault did not specify a Reason.,Source=Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin,'
Could someone please suggest what could be incorrect here?
Categories:
