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
result.Append(replaceWith)
Else
result.Append(c)
End If
Next

return result.ToString()


Once the calculated field is created, map this to your field in CRM instead of the source field.