Notes-20160715: Canvas API spreadsheet

Canvas API spreadsheet 

Execute Canvas API calls from inside a Google spreadsheet! The code was written by Brian Whitmer https://docs.google.com/spreadsheet/ccc?key=0AqXrX8DLjV-DdEhTcFVDSTRtOHJsbmQ2VE5IVTBoamc#gid=1 Links to an external site.

For example, here is the result of getting all of the pages for course 11, using the function:

=canvasList("/api/v1/courses/11/pages")

 canvas-api-spreadsheet-example-20160715a-trimmed.png

Another example, in this case getting the list of files for a course:

=canvasList("/api/v1/courses/11/files")

Links to an external site.

canvas-api-spreadsheet-example-20160715b-file-list.png