[ARCHIVED] [ARCHIVED] Return list of classes using an integration

[jason_kocur]

Hi Folks, 

After reading the Canvas API documentation and not finding what I was looking for, I figured I would ask. I am looking for a way to download a list of classes at my school that use a 3rd party integration. We have over a 1000 classes and rather that look through each one manually, I am hoping there is a way to use the API to search through the class list and see if it has the external tool located in it. 

Does anyone know if this is possible? Also, to give as much detail as possible, I am looking to use python to capture this information and then put it into a spreadsheet. 

Cheers!

Jason

[smartps]

Hi,

It looks like the Show Module Item API call returns a ModuleItem object which includes the type of a module item (ExternalTool). I don't have an example of that exact call but here's some code to get you started, just change the API endpoint URL.

import requests, json
data_set = []
headers = {
 'Authorization': 'Bearer 15691~dsfasdfsdfsd',
 'per_page':'100' #You'll need to loop through pages if you have 1000's courses
}

#List all courses
uri = 'https://banana.instructure.com/api/v1/courses?per_page=50' 
r = requests.get(uri, headers=headers) 
raw = r.json() 
parsed = json.loads(r.text)
#print(json.dumps(parsed, indent=4, sort_keys=True))
print("ID \t Blueprint \t Name")
for course in parsed:
 print(course['id'],"\t",course['blueprint'],"\t\t",course['name'])

#List details of a single course
uri = 'https://banana.instructure.com/api/v1/courses/42'
r = requests.get(uri, headers=headers) 
parsed = json.loads(r.text)
print(json.dumps(parsed, indent=4, sort_keys=True))

#List settings of a single course
uri = 'https://banana.instructure.com/api/v1/courses/42/settings' 
r = requests.get(uri, headers=headers) 
parsed = json.loads(r.text)
print(json.dumps(parsed, indent=4, sort_keys=True))

:wq

Paul

[Chris_Hofer]

Hi  @jason_kocur ...

I'm not sure if you are a Canvas administrator at your school, but have you tried downloading the "LTI Report"?  How do I view reports for an account?