By Lorren Zemke, Director of Professional ServicesThursday, November 10, 2016
When integrating to Dynamics CRM, we are receiving the above error message for some fields that we are trying to set. There are some characters that are not accepted by Dynamics CRM and are typically non-printable characters. One method for removing those characters, if you cannot remove them from the data source, would be to create a new Calculated Field.
Use the code below to remove those characters and replace it with the value in the replaceWith variable. In this example we replacing the invalid characters with a New Line.
Dim result As New System.Text.StringBuilder()
Dim replaceWith as string = Environment.NewLine
For i As Integer = 0 To _MYSOURCECOLUMN.Length – 1
Dim c As Char = _MYSOURCECOLUMN(i)
Dim b As Byte = Microsoft.VisualBasic.AscW(c)
If b < 32 Then
Once the calculated field is created, map this to your field in CRM instead of the source field.