user_sis_id

Jump to solution
tross
Community Champion

OK am I missing something.  I can't find the user_sis_id in Canvas Data.  I know I can get it if I switch to using the API but requires learning a new language for me.  I am downloading data nightly and populating a SQL database.   Works great and lets me use the tools I want but only having a name on users is a problem since I need the number to be unique.  Am I missing a table?  

0 Likes
1 Solution
Kerlene_King
Community Explorer

The "sis_user_id" is found under the pseudonym_dim table

View solution in original post