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.