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?