Validating an Account ID and removing invalid ones
Hi,
A behavior we are trying to drive is to get Account IDs populated against our contact records in Eloqua so that when the lead heads into SF we can reflect the lead against the related account. The problem we are running into is that we sometimes have people entering an invalid account ID in the field, which in turn causes the lead creation in SF to fail.
As there is no way of validating that the account ID field has been correctly populated, I was wanting to use Data tools to check the account id field on the contact object against the account table in Eloqua and if it doesn't find a match for the account id there, then clear that field, but I am not even sure if this is possible or how to go about it. Does anyone have any ideas or has possibly done something similar in their instance?