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.

I have the same question (0)

All responses (1)

Answers (0)

Anaxarsys777 3 on at

Like (0)

Report

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.

Was this reply helpful? Yes No