AnsweredAssumed Answered

Data truncated for column 'customerNumber' at row 1

Question asked by lrodr99329380 on Nov 15, 2017
Latest reply on Nov 21, 2017 by allan.ford577519

Hello there!

I'm new to Boomi, so I'm hoping someone can help me out here.  I'm just getting started , but this should be pretty straight forward.  The use case moving data from Salesforce to MySQL.  Trying to move Account id to CustomerNumber and Account Name to customerName.  The SQL statement used in the connector operation is

 

INSERT INTO customers (customerNumber, customerName) VALUES (? , ?);

 

Fields are mapped properly,  Account id is null for one of the records,  I did read that this may be an issue, but I'm not sure how to proceed.  Any help would be greatly appreciated.

Outcomes