When an email is added to a Contact or Agency, the Modified_Time of the Contact remains unchanged. This poses a challenge in detecting when a new email has been added for data synchronization purposes.
In my workflow using SSIS, I rely on a Last Sync Date to retrieve Contacts modified from that date to the current one. However, since the Modified_Time is not updated when an email is added or modified, I struggle to detect these changes and retrieve the new values.
Simply refreshing all emails for all contacts is not an efficient solution for my scenario. How can I effectively detect and synchronize newly added emails without relying solely on the Modified_Time of the Contact?
Thank you in advance