Back

The field contains one or more invalid characters

Published: Nov 10, 2016
Post Author Written by eOne Solutions

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.

Did this answer your question?

FEEDBACK FORM HERE

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.