Loading

Salesforce Connector | Use Upsert Operation to Set Null Values for Records Created by Create job bulk api v2 Operation

Julkaisupäivä: Mar 4, 2025
Tehtävä

GOAL

To use the Upsert operation to set null values for records created by Create job bulk api v2 operation
Vaiheet
Change your DataWeave transformation code to pass the string "#N/A" to overwrite the fields that need null values.

For example, to set the BillingStreet field value to null, use the following DataWeave expression: 
if(!isEmpty(items.BillingStreet)) (items.BillingStreet) else ("#N/A")
 

ADDITIONAL INFORMATION

Empty field values are ignored when you update records. To set a field value to null, use a field value of #N/A.
This is not an issue with the Salesforce Connector. It is documented in Salesforce API usage:
https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/datafiles_csv_valid_record_rows.htm?search_text=Empty%20field%20values

Disclaimer: Please note that Mulesoft Support will be only limited to responding to issues with the Connector. For any source/target application-related queries; you will be required to contact the source/target vendor directly.
Knowledge-artikkelin numero

001116418

 
Ladataan
Salesforce Help | Article