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...

Currently looking at canvas.courses table. I want to link all the courses / modules to their respective main Programs so that different programs can be analysed separately. For instance - a computer s...

@KeithSmith_au @Pete5484 @stimme    Thanks guys, this is super helpful and quite crisp explanation - covers the use cases. Yes I can confirm that my org uses emails as logins, hence I used...

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!

Currently looking at canvas.courses table. I want to link all the courses / modules to their respective main Programs so that different programs can be analysed separately. For instance - a computer s...

@KeithSmith_au @Pete5484 @stimme    Thanks guys, this is super helpful and quite crisp explanation - covers the use cases. Yes I can confirm that my org uses emails as logins, hence I used...

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!