Thread: Upsert Record(s) related to other Objects

Maybe I am not understanding you fully, but it seems what you are trying to do is not possible. If you have an external ID set on Accounts, then you have to use that external ID to upsert to that object. Same goes for contacts or any other object. Now if I am wrong with your question, please be more clear and I am sure that I can help you out

Thanks for joining the site!!

~Mike

Originally Posted by quantentunnel

Hi,
after searching for hours I would like to ask how you do upsert/create records containing lookup-fields to objects with theire own external ID.

e.g.: Contact has its own external ID = Contact_ext_ID__c
Account has its own external ID = Acc_ext_ID

I would like to upsert contacts like this
Contact_ext_ID__c = "23523AG",
Account.Acc_ext_ID__c = "A540065" //can't get this field matching during upsert/create
Info__c = "Prospect"
Name = "Mike",
City = "Hollywood";


best regards

UPDATE: There is another thread that is not really solved in PHP: Setting a lookup field using an External ID in UPSERT

Hi Quant,

You can do this it just might require two steps. You can't use two external IDs for one upsert which is why Account.Acc_ext_ID__c = "A540065" won't work.

In order to do this, you can use your existing detail but make the Account.Acc_ext_ID__c the Salesforce.com generic AccountID from the Contact Object.

In this case, you can keep your data structure and populate your external ID to the contact and then use the AccountID to associate it with the proper account.

Because you have an external ID for the account, I would assume that you could simply export your current Account table with the external ID and then use a vLookup to match that against your upsert file.

I hope this helps!