Via the API, I need to determine whether user ids have already confirmed their email address or not. Using DataExplorer I am querying the email_tokens table, but am confused about how to interpret multiple rows for a given user id. When there are multiple rows, N-1 of them have expired = true, but the row with expired = false doesn’t seem to be the current state of whether they have confirmed their email address. For example there are verified users whose email_tokens row with expired = false showing confirmed = false
Probably going about this the wrong way. Please advise. Thank you!