Hi,
We are building a solution that will integrate with a database which has multiple contact details (phone, email, address, etc) from multiple sources for the same contact. This data is external read only data and is not the source of truth. We also need to define specific email addresses (personal and business) for different marketing lists and purposes. For example, we want to email all employees of a client with a service related requests. But product related emails should go to their personal email address.
I was thinking we would create a custom entity to hold Contact Details, or use the address entity, to store all known details and their source. Then have a logic to update the out of the box fields to emailaddress_1 = Primary, emailaddress_2 = Business, emailaddress_3 = Personal.
Utilising Dynamics 365 Marketing can you choose to use more than the emailaddress_1 for marketing lists?
What would be best practice for handling such data and logic? Any thoughts on how to tackle this?