Question
Email addresses in my exported Users table started showing up blank for some users, causing duplicate rows and broken reports.
Answer
Private (non-public) email addresses can only be exported using an administrator account. If the account used to authenticate the connector isn't a Jira administrator, any user whose email visibility isn't set to public will show up blank in the Users table.
To resolve this, either:
-
Set the affected users' email visibility to public, or
-
Use an administrator account to authenticate the connector and perform the export.