RE: Diyotta is using Bulk API V1(Bulk V1) to load salesforce data which supports only comma delimited files

Diyotta is using Bulk API V1(Bulk V1) to load salesforce data which supports only comma delimited files. The source file contains special characters(Single quotes, double quotes, comma and new line characters) so we are replacing these special chars before loading it to salesforce.

Source Database is DENTRIX

processing platform is Postgresql.

Target Database is Salesforce

How do we overcome these data load issues??

TommyM Beginner Asked on June 3, 2020 in Diyotta Monitor.
Add Comment
1 Answers

Column delimiter should always be comma while loading into Salesforce. Use double quote(“) as escape character this will escape the double quotes and Text Qualifier as Double quotes. When the data is inclusive of the single/Double quotes

RE: Diyotta is using Bulk API V1(Bulk V1) to load salesforce data which supports only comma delimited files

Expert Answered on June 3, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.