Salesforce Upsert not upserting

[jmr123]

As you can see by the error in my screenshot, the salesforce contact upsert isn’t actually upserting anything. It’s asking me a question whether to update an existing, etc, which I can’t control in my node. I was thinking this would let me pass in an email and then see if there is an existing contact with that value. If so, update it, if not, the create. But it seems to not be capable of doing that when I pass in an existing contact as a test.

If I pass in an email that’s not in my contacts, then it creates successfully.

What additional do I need to do with this node to allow for the upsert?

Alternatively, I was thinking I could search for a contact using email and then branch based on whether it finds something, but that doesn’t seem to be an option.

I’m on n8n cloud on the latest version.

Thanks,
JMR

[n8n]

It looks like your topic is missing some important information. Could you provide the following if applicable.

• n8n version:
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app):
• Operating system:

[ihortom]

@jmr123 , I think the problem is with duplicate contacts in Salesforce. There is more than one contact with the very same email address. Try to remove the duplicates or merge them to make sure only one exists and see if that helps with upserting.