Loading

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

Дата публикации: Mar 4, 2025
Задача

GOAL

To use the Upsert operation to set null values for records created by Create job bulk api v2 operation
Действия
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.
Номер статьи базы знаний

001116418

 
Загрузка
Salesforce Help | Article