I am trying to import data using a 3rd party tool, connected to the 24.0 API. I am sending data to the SFDC Contact entity using Upsert. On my Contact entity I have created a custom text field to contain a unique GUID value from my external system. I have set this field to be an External Id.
When I send my data to SalesForce in a bulk Upsert, it is returning an error: DUPLICATE_VALUE || Error: Duplicate external id specified: someone@gmail.com || Fields: Email
The error returned tells me that my source data does not contain unique email addresses - which is correct. I do not care if my email address aren't unique, since I will have the unique key.
When I send the data non-bulk, the first record is created and subsequent records are updated.
I am hoping to understand why the Upsert is using the Email field (an Id Lookup field) instead of my Custom text field (External Id field) as I understood it would based on this article: (http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_upsert.htm).
Best regards,
Nate
2 risposte
Hi Mamoon,
Thank you for replying so quickly.
I would like to use Upsert + Bulk because I am concerned about API hits and performance. I cannot filter or modify my source data tell me if the record exists/needs updated, so I won't know unless I first perform a lookup (which means more API hits and slower records/second for the additional operation).
My custom field is set as an External Id and Id lookup field in the entity metadata - so I was hoping that it would use that field to find if the record already existed.Do I understand you correctly the Contact entity needs a unique value for the Email field when using Upsert (but not Insert/Update) and that it ignores custom External Id fields?
Best regards,
Nate
