After Uploading a Data to Salesforce, It has Special Characters. What could be the cause of this.
Input is CSV file.
Target Profile- XML UTF-8 encoding
How to avoid this?
Refer back to SFDC what exactly it accepts.
Accordingly, make changes in your profiles.
Try looking at the data that is being sent from BOOMI first by downloading the content sent to the connector using a Notepad++.
If you see any special characters change the encoding type in BOOMI.
Try encoding the data to ANSI and look for the output you get.
Have tested with ANSI and UTF-8 BOM it did work. Just trying to replicate the issue and find out the csv encoding which gave this error.
Glad that you found this to be working.
It's in the CSV metadata that was giving out a special character.
Again to add ensure you have both the file encodings before you integrate accordingly with no issues.
Retrieving data ...