Canvas API - Getting information for all courses to Power BI in 1 call?

[RJguo]

Hi,

I'm exploring the Canvas API trying to bring data into Power BI using the web connector.

I have admin access and can see all the courses in our system (Admin -> Courses) but not actually enrolled in any. I can see the course IDs in the canvas interface but I can't seem to find a way to list out all of the Courses using the API.

Get /api/v1/courses only returns active courses that the user is enrolled in, but is there a way to list out all the courses in the system?

The ultimate goal is to list the all student information (names and email) for all courses (active and archived).

Any help would be appreciated, thanks!

[stimme]

@RJguo If you'd like to get courses in within an account, see this API endpoint: https://canvas.instructure.com/doc/api/accounts.html#method.accounts.courses_api. You might also consider getting admin provisioning CSV reports to list courses, enrollments, and users. If you don't need to update your data sources very frequently / automatically, running on-deman admin reports would be simpler than building an API connection.