Great! Thanks for the query Pete. Yes I was planning to filter on workflow state too - I am doing the same for the courses table.  I am not sure but looks like there is no need for communication_chann...

Also 2 questions to you as I asked the same to Pete in the thread below: 1. I am not sure but looks like there is no need for communication_channels - atleast to get the Emails and SIS ID. The pseudon...

Great! Thanks for that - legend!

Hi,  Does anyone know a way to find student IDs or user emails from CD2? I have checked users and accounts tables in the canvas namespace - but they don't have "email" column. I only have ...

Also 2 questions to you as I asked the same to Pete in the thread below: 1. I am not sure but looks like there is no need for communication_channels - atleast to get the Emails and SIS ID. The pseudon...

Great! Thanks for the query Pete. Yes I was planning to filter on workflow state too - I am doing the same for the courses table.  I am not sure but looks like there is no need for communication_chann...

Great! Thanks for that - legend!

Hi,  Does anyone know a way to find student IDs or user emails from CD2? I have checked users and accounts tables in the canvas namespace - but they don't have "email" column. I only have ...