Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

Preventing Null Value Upserts in SFDC: Solutions for JSON Errors

·

·

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"}]

Loading attachments

Preventing Null Value Upserts in SFDC: Solutions for JSON Errors | Clay

2 comments

· Sorted by Oldest

Channeled
APP
·
·
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
Channeled
APP
·
·
Was that helpful?