Here is my use case. I am syncing records between two orgs using Jitterbit. I select Users from orgA and create Contacts in orgB. Pretty straight forward and this is working.
My challenge is that there is a relationship that I want to create in OrgB. Contacts have a Manager Lookup where the manager is also a contact. On Insert\Upsert the "Manager" may not exist when the "Contact" record is Inserted\Upserted.
What I would like to do is.
- Complete my batch upsert.
- Wait for the batch to finish and then for each record that was upserted lookup the newID for the manager and set it on the Contact.
Part of my data includes this relationship from orgA so I know the ID of the manager, I was hoping that I could do an after insert\upsert, use the ID from OrgA to lookup the ManagerID in OrgB where OrgAID = "managerID from upsert" and set that as the manager ID?
Does that make sense? Any suggestions?