Hi. I'm trying to determine for sure which email address is returned with the Constituent API. According to the schema it is: “The constituent's primary email address, or the constituent's first active email address if no active email address is marked as primary”. I've run queries to find Constituents with no email marked Primary. What I've found is that for those Constituents, the active email that has the earliest Date Last Modified is what is pulled. This doesn't make sense, but I've tested this with about a half-dozen records, and so far it is consistent. In cases where all the emails have the same Date Last Modified, it picks the first one.
I'm curious to know if anyone else has found this to be true, or is it actually returning the first active email?
Thank you!
RIchard