Salesforce Update (not Upsert) by External ID

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2017 02:39 PM
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…
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2017 02:44 PM
There is a feature request for this functionality under consideration.
Diane Miller

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2017 04:30 PM
@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.
