Unable to import emails from salesforce to Dynamics 365 MS CRM

(0) Share

Report

Posted on by Shaikahammadali

Hi Team,

I am unable to migrate email entity from Salesforce to MS CRM.

We are facing issue regarding 'to' field .

This is the error message below:

02sD000001QUphIIAT,/System.Exception: Error: Failed to process 'to' field with an input value of cmd_marketing@eircom.ie; eircombusinesscrcnotifications@eir.ie; unified.faults@eir.ie' (value type: String, field type: PartyList, entity: email). System.Exception: Failed to process party list values for 'to' field, the input value does not appear to be in a valid JSON or delimited text format: 'crcescalations@eir.ie; cmd_marketing@eircom.ie; eircombusinesscrcnotifications@eir.ie; unified.faults@eir.ie'. (SSIS Integration Toolkit for Microsoft Dynamics 365, v23.1.1.13901 - DtsDebugHost, v16.0.5223.0) (SSIS Integration Toolkit for Microsoft Dynamics 365, v23.1.1.13901 - DtsDebugHost, v16.0.5223.0)System.Exception

Please suggest us the steps to resolve this issue.

All responses (1)

Answers (0)

Anaxarsys777 3 on at

Like (0)

Report

Unable to import emails from salesforce to Dynamics 365 MS CRM

Hi!
You can use script component in your data flow and put in OutputBuffer string in such template $"[{{\"PartyId\":\"{entityId}\",\"Type\":\"{entityName}\",\"Name\":\"\"}}]". Then you should map this output row on destination component field 'to' with Choose Target Field option and <Opt Out -Input is GUID> as Lookup method in text lookup editor for this field.