[ARCHIVED] List of courses for a group of students

[RodrigoJimenez]

I am trying to see if it is possible to get the list of courses for a group of students using the api. I know I can get the list of courses for a single student but in my situation I need to be able to get the list of courses for each student in a group. Any advice will help. Thank you!

[jerry_nguyen · Accepted solution]

@RodrigoJimenez 

There are several ways you can get the list. Depending on your expertise:

The easiest is to download the Enrollment Provisioning report (https://community.canvaslms.com/t5/Admin-Guide/How-do-I-view-reports-for-an-account/ta-p/109) which will list all enrollments in your Canvas instance. You can then use Excel to filter.

If you want to use API you will need to know some basic programming. Basically, you will need to write a program (E.g. simplest is to use Excel Built-in VBA) to call the Group endpoint to get the list of students then use a loop to get enrollments of each student. 

Another way is to run SQL query from Canvas Data (https://community.canvaslms.com/t5/Admin-Guide/How-do-I-use-the-Canvas-Data-Portal-for-an-account/ta...)