[ARCHIVED] Is email address available in Canvas Data?

[John_Lowe]

Is the email address of users available anywhere within Canvas Data?  I've recently been asked to generate a contact list of people based on the output of a Canvas Data report, but I can't seem to locate a field for email address in the user_dim or the pseudonym_dim.

[James · Accepted solution]

Use the communication_channel_dim table.

You're looking for address with type='email'.

You can use user_id as a foreign key to the user_dim table to get other information.

[John_Lowe]

Perfect!  Thanks!

[kmeeusen]

John:

You can also run a provisioning report through the standard Admin UI to collect those, and you can filter by term. We do that one all the time.

KLM