Forum Discussion

omair's avatar
omair
Contributor
9 years ago

Salesforce Update (not Upsert) by External ID

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…

salesforce

2 Replies

  • dmiller's avatar
    dmiller
    Former Employee
    9 years ago

    There is a feature request for this functionality under consideration.

  • del's avatar
    del
    Contributor III
    9 years ago

    @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.