I am working with a customer to integrate their contact and related entities into our platform. The issue I am facing is making sure that we are getting the most recent contact and related entity data.
For example: each contact can be registered for multiple courses. contacts are being grouped by course on our platform. That contact's status within the course can change and our platform must reflect this change in a timely manner. We query all contacts with a modifiedon date in the past 30 mins every 30 mins (the client does not have the resources to push to our API) and then make subsequent queries for their courses. The question has arisen what happens when a course status has changed for a contact (this information is being stored on an intersect entity called contact_course)--is that change reflected in the contact record by the contact's modifiedon attribute or does the modifiedon attribute only change on the contact_course intersect entity? From what I can see in their dashboard the relationship is defined as referential and my guess is no. But if the contact was considered the parent of the intersect table would the modifiedon attribute change for the contact if the contact_course entity was modified?
*This post is locked for comments