CD2 API - Get All Users that are displayed in Users List UI

[cvang]

Hello,

Using the CD2 API, what is the suggested way to get the Users from the User's List on UI?  I have tried using Users and Pseudonyms but I am receiving more results compared to my original logic on CD1.  

Also, according to the documentation

• Users says "Not all users are displayed in users list on UI."
• Pseudonyms says, "not all users can be found in the pseudonyms table."
  
  

Sample data that I am trying to gather:
*Note* With a filter by "StudentEnrollment" and "TeacherEnrollment" in enrollments table.

• canvas_id ➡️ user.key.id
• sis_id ➡️ pseudonyms.value.sis_user_id
• login_id ➡️ pseudonyms.value.unique_id
• email ➡️ communication_channels.value.path
• name ➡️ user.value.name
• short_name ➡️ user.value.short_name
• avatar_url ➡️ user.value.avatar_image_url

Any feedback and/or suggestion is appreciated.

[stimme]

Hello @cvang! It looks like you have mapped the fields you want to get from CD2. I suggest filtering the users table to exclude id > 10000000000000 (which the document you linked to states would be from other instances of Canvas - typically Instructure Support staff). Beyond this, I am not certain what would explain the difference between your CD1 and CD2 results. Perhaps you could post your CD1 query or strategy to clarify.

[WillGHampton]

select * 
from
users u, pseudonyms p
where
u.id = p.user_id

When in doubt, slim your query down to the basics. I'd run a similar query to this basic query on both CD1 and CD2 to compare the number of results.

[WillGHampton]

You may want to filter on workflow_state in the users table, as without filtering the user list will include deleted students.

select * 
from 
users u, pseudonyms p
where
u.id = p.id 
and
u.workflow_state != 'deleted'