Hey folks - when I try to Salesforce Upsert Record and select a table it just fails. Says “Key not found” but the column doesn’t have any other options.
Hey there Gregory sorry for the delay, did some digging around to find what was going on and so the issue here is that Salesforce Upserts, in general, require a field in Salesforce to be marked as an external ID. According to the key you’re using in Clay, no fields in your Salesforce organization are marked as an externalID, so you can’t actually run upserts because no fields load for the upsert key.“ExternalID” is a salesforce setting that says “this field can be used to dedupe salesforce records, but its values come from another source”We can definitely make changes to enable this in our regular lookups, as mentioned in this thread, but the quickest win here would be to mark a field in salesforce as an external ID and then try again