Preventing Null Value Upserts in SFDC: Solutions for JSON Errors

Justin T. · 2025-03-03T00:02:50.122002+00:00

SFDC Update has a "ignore blanks" but SFDC Upsert function does not. How do I prevent null value upserts from erroring? [{"message":"Cannot deserialize instance of date from VALUE_STRING value or request may be missing a required field at [line:1, column:225]","errorCode":"JSON_PARSER_ERROR"}]

Unfortunately, the Salesforce Upsert Object action in Clay doesn't have an "ignore blanks" option like the Update Record action does. To prevent null value upserts from erroring, you'll need to ensure that the fields you're mapping from your Clay table to Salesforce match the required data types and formats. One way to handle this is to use formulas in your Clay table to transform or filter out null values before they reach the Salesforce Upsert action. You can create conditional formulas that only pass non-null values to the upsert fields. If you're still experiencing issues, you might want to share the specific JSON error you're encountering so we can provide more targeted assistance.

Sources: Upsert Object with Salesforce Salesforce integration overview | Documentation | Clay University

2 comments