Skip to main content
Best answer

Salesforce upsert

  • August 4, 2021
  • 4 replies
  • 276 views

Hi -- the question posed before was if Zapier can upsert (insert/update) a record to Salesforce. In response, the answer was “use the find/create record” action in the Zap -- but that only creates a new record or uses an existing one. It does not update an existing record, and is therefore not an upsert.

Anyone got ideas on how to work around that?

Thanks,

-Dave

Best answer by Troy Tessalone

Hi @salesforce upsert 

You can achieve the desired results with these Zap steps:

Action: Salesforce - Find/Create Record

Action: Salesforce - Update Record (map the Record ID from the previous step )

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • August 4, 2021

Hi @salesforce upsert 

You can achieve the desired results with these Zap steps:

Action: Salesforce - Find/Create Record

Action: Salesforce - Update Record (map the Record ID from the previous step )


Awesome -- but then, aren’t you updating a record you just created?


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • August 4, 2021

@salesforce upsert 

The idea would be to create a new record with the bare min data, then update the record with the other data points.

The other option is to add paths with more complex logic, which does the same thing, but uses more Tasks.


awesome -- we’ll give this a shot. thanks for the guidance!