Community

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
John_Lowe
Community Champion

Is email address available in Canvas Data?

Jump to solution

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.

Tags (3)
1 Solution

Accepted Solutions
James
Community Champion

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.

View solution in original post

3 Replies
James
Community Champion

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
Community Champion

Perfect!  Thanks!

kmeeusen
Community Coach
Community Coach

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