You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to Keep Imported SFDC Opp Contact Role Data Updated With Latest Related Opportunity Data?

in Eloqua 4 comments

We integrate with SFDC using the Salesforce Integration App. For our Onboarding and Pipeline Acceleration campaigns in Eloqua, we want to target contacts with specific Contact Roles on Opportunities in specific stages. To support this, we have an import within the SFDC Integration App that pulls Opportunity Contact Role data (primary object) and related Opportunity data. The import writes to a Custom Object table where the Contact Role ID is the unique identifier, since - at least for us - any one contact may be associated to multiple opportunities and may have multiple contact roles on the same opportunity.

Where we're struggling is this: the import will only pull back data when the Contact Role record itself is modified, not when the Opportunity is updated. Thus, large chunks of our Opportunity Contact Role CDO data for the related opportunity is out of date.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!