I'm running am import from SalesLogix (SQL) --> SalesForce via the API (not using BULK).
The data I'm pushing over are SalesLogix HISTORY records to SalesForce TASKS.
I managed to get almost 2000 records over successfully, however I'm getting an error on about 50 records and all of the errors are the same:
System.Web.Services.Protocols.SoapHeaderException: Character reference "�" is an invalid XML character.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at StarfishEngine.SalesforcePartner.SforceService.create(sObject[] sObjects)
at StarfishEngine.StarfishService.PostStageSalesforcePartner(rowdat& RowData, Stage st)
I am not sure which field mapping is causing the issue.
I do have the ActivityDate field mapped using the following script:
Function ScriptedField
dim dt
dt = FormatDateXML("@@ORG:COMPLETEDDATE@@") ScriptedField = dt
End Function
I checked and the COMPLETEDDATE on these records appears to be fine.
The other possibility I can think of is that the LONGNOTES field has some special characters which are not going over to SalesForce? I looked at the text and I'm not seeing those characters though.
Any assistance would be appreciated!
Thanks!
Anosh
Comments (2)