[ARCHIVED] Generating a list of all courses in Manually-Created subaccount?

[abunag]

I'm trying to get a list of all courses in the "Manually-Created Courses" subaccount, however, courses without an SIS ID seem to not show up in the stock reports.  Anyone have a method to generate a list?

[Alexandre_Sch]

Hi,

There are a few ways of doing it:

You can use the api below and get all the courses from a account. 

/api/v1/accounts/:account_id/courses GET API  https://canvas.instructure.com/doc/api/accounts.html#method.accounts.courses_api

Or

You can use the canvas data portal and get the course_dim/fact and account_dim/fact tables (need sql basic knowledge - select/joins)

Or

You can set a sis_id in all courses from that sub-account. Than, probably, all the courses will show into the admin report. 

Hope it helps!

[dgrobani]

I just ran the Provisioning report in the Manually-Created Courses subaccount, and courses without SIS IDs appeared in it.

[Alexandre_Sch]

Hey!

Never ran that report, thanks for sharing this info. 

[dgrobani]

My pleasure! The SIS report shows only things that came into Canvas via the SIS, while the Provisioning report shows everything.