Salesforce Update (not Upsert) by External ID

[omair]

I’m trying to do a SF update based on External ID … however, the snaps available right now make it look like that’s not possible. I have:

• Salesforce Update: update based on Id
• Salesforce Upsert: update or insert based on external id.

Can someone advise how I can do an update only (and no insert) based on external id…

[dmiller]

There is a feature request for this functionality under consideration.

[del]

@omair, a creative workaround might be to add a parallel flow to your pipeline that uses a Salesforce Read to pull the external id for all existing object records and then join the two flows with an Inner Join based on External Id. That will reduce your resulting set down to only existing Salesforce records with matching external IDs.