Loading

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

Date de publication: Mar 4, 2025
Tâche

GOAL

To use the Upsert operation to set null values for records created by Create job bulk api v2 operation
Étapes
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.
Numéro d’article de la base de connaissances

001116418

 
Chargement
Salesforce Help | Article