Courses and accounts

A user asked about whether there were public courses at KTH that the user could look at for examples. This got me to thinking, surely one can use the API to get a list of all of the courses and then one can look at the is_public and is_public_to_auth_users attributes of a course to see which were public. This resulted in a simple program ( Download export-list-of-all-courses.py

) to get this information.

When looking at these courses I wondered which parts of the university were associated with each course. One can look at the account_id attribute, but as is usual  in Canvas this is just a number - so one has to know the mapping between this number and something more useful to humans. This resulted in the program  Download export-list-of-all-accounts.py

).

This lead to a combined program Download export-list-of-all-courses-with-account-info.py

 

This leads to a spread with entries such as (some columns have been removed for improved readability):

default_time_zone id name parent_account_id parent_account_name root_account_id sis_account_id workflow_state nice_account_name
0 Europe/Stockholm 1 KTH Royal Institute of Technology active KTH Royal Institute of Technology
1 Europe/Stockholm 2 Ω Demo 1 KTH Royal Institute of Technology 1 active KTH Royal Institute of Technology_Ω Demo
8 Europe/Stockholm 9 ICT 1 KTH Royal Institute of Technology 1 active KTH Royal Institute of Technology_ICT
25 Europe/Stockholm 26 Imported course rounds 9 ICT 1 ICT - Imported course rounds active ICT_Imported course rounds
33 Europe/Stockholm 34 Manually created course rounds 9 ICT 1 active ICT_Manually created course rounds
41 Europe/Stockholm 42 Sandboxes 9 ICT 1 active ICT_Sandboxes
47 Europe/Stockholm 47 Ω Misc 1 KTH Royal Institute of Technology 1 active KTH Royal Institute of Technology_Ω Misc