Can we use multiple external ids in boomi for SFDC upsert operation? I know how to handle with single external id but what if we want to do upsert based on multiple external ids.
I think you could achieve your scenario by using reference fields concept in the upsert operation. We could mark Use External Id for reference and then select different external ids for different reference fields so that you could upsert on the reference fields basis.
But I think your entire record would be taken into consideration as a new OR existing OR duplicate based on the main external field which we have to specify while upserting. The Salesforce object may have up to 25 external Id fields in it but not more than that. So,While doing the upsert in Boomi, we have to choose ONE out of all available external Ids in that particular SFDC object.
Please see these posts:
Salesforce operation ,http://blog.jeffdouglas.com/2010/05/07/using-exernal-id-fields-in-salesforce/
Help | Training | Salesforce ,
Please mark this as helpful/correct If this answers your question.
Thanks for the relply Michael.
But my requirement is I have to do upsert operation based on the combination of 3 external ids. I think this is not possible right?
In a short as of now, It is not possible. I suggest creating an idea. We will vote for it. Cheers!!!
Happy Exploring Boomi.
As per my conversation with Support team multiple external ids concept is not supported by Boomi.
So we I have asked SFDC team to create an additional external id which is combination of other 3 ids which solved my issue.
You may be able to solve this use case by creating a new field that the is combination of your 3 external ids as described in this external article.
Thanks Varun for the workaround.
Retrieving data ...