I have been using salesforce.com for several years and am well versed with dataloader for upserts. I am now using castiron to upsert records to salesforce from a DB2 table. Here's the problem:
I have a custom object (Object A) that has an external id field that I use to upsert, no problem, works like a champ. Object A also has a lookup field that is a reference to another custom object (Object B). From my source system in DB2, I don't know Object B's salesforce id, only the numeric id from Db2.
When I upsert object A I would like to refer to the numeric id and have it resolve it, just like you can do in dataloader.
My question is: can this be done in castiron, I don't see anywhere in the studio that allows you to specify an external id for a related object (object b). All I can see in the editor is a place to specify the primary object's external id.
This topic has been locked.
2 replies Latest Post - 2012-01-07T21:38:23Z by shahss
Pinned topic Need help on upsert to Salesforce.com
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-01-07T21:38:23Z at 2012-01-07T21:38:23Z by shahss
Puchalapalli 270004S3BA1 PostACCEPTED ANSWER
Re: Need help on upsert to Salesforce.com2011-12-19T13:15:40Z in response to Tderosa_solutionsYes its possible only if you have an external id field on object B. In this case, when you will choose the field in the "Configure" Task (Salesforce Upsert Activity), for some of the fields you will see a "V" icon. Just click on the "V" icon and you will get a drop down list having all the external ids on object B. Select the appropriate one and then this field would automatically do a look up for you based on the numeric field which you map to this external id. If there is a record on object B with this external id then your record can be inserted/updated otherwise it would give an error.