Hi,

I am working on a data migration to SalesForce - using a SalesForce adapter in Scribe Insight as connector and the unique record Id in SalesForce as a lookup. My Upsert is not working, as it is still creating a new record, despite that the record Id already exists. I read that an External Id must be used as a lookup to identify if a record already exists. 

Question: As per article “https://success.scribesoft.com/s/article/Using-The-Upsert-Operation-For-Salesforce-Integrations” - either the entity primary key or a custom field, set as type External ID, can be used to determine whether to create a new record or update an existing record. 

I am using the record Id, but still my Upsert doesn’t work. Should I really have a custom field, set as type External ID? Thanks in advance.