AnsweredAssumed Answered

Java API for creating custom ad-hoc reports

Question asked by Joel Hebrink on Apr 4, 2019
Latest reply on Apr 4, 2019 by nr2522@columbia.edu

I would like to retrieve data from Canvas at an individual assignment level to create custom reports analyzing quiz/test questions controlling for class rank, major, final class grade...etc.

 

1. Is there a Java API for Canvas that may enable me to retrieve data via JDBC, at an individual assignment or quiz level?...or a Web Service (SOAP or RESTful) that can be consumed to pull data? (I have parsed the grade book csv, but it is not granular enough to meet my requirements)

2. Is a schema available for relevant databases/tables?

3. MySQL, MSSQL, Oracle...something else?

 

#java #rdbms

Outcomes