Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Salesforce
  3. PowerExchange for Salesforce Configuration
  4. Salesforce Connections
  5. Salesforce Data Objects
  6. Salesforce Mappings
  7. PowerExchange for Salesforce Dynamic Mappings
  8. Salesforce Run Time Processing
  9. Appendix A: Data Type Reference

PowerExchange for Salesforce User Guide

PowerExchange for Salesforce User Guide

Handling Null Values in Update and Upsert Operations

Handling Null Values in Update and Upsert Operations

By default, the Data Integration Service does not replace existing values in a Salesforce record with null values from the source during an update or upsert operation. To replace existing values with null values, configure the Set Fields to NULL session property for the Salesforce target.
You cannot set the value of an external ID field in a Salesforce target to NULL. The session fails if you enable the Set Fields to NULL session property and the session tries to replace the value in an external ID field with a null value.

0 COMMENTS

We’d like to hear from you!