Adding to what Ed said above, a previous release provided a spreadsheet version of the schema.  This is critical to our development effort as it brings all the columns and tables into a single documen...

Using Canvas Data 2 data, I'm looking at student answers for Calculated questions.  When a question is correctly answered, the Answer_ID is populated.  When the question is incorrectly answered th...

If the grading standard row is no longer "assigned" then it would seem logical to me that the Context_ID column would be set to NULL.  Except that it's a NOT NULL column, so it's left ...

Enrollments are a free-for-all in our instance of Canvas.  I threw up my hands/keyboard and decided that going back to the SIS for the primary instructor was the path of least resistance.  We maintain...

sis_batches may be one of those tables that they include in the DDL script but is not available in the export.  That table is in the latest DDL script I'm using but I explicitly don't import a...

I'm a bit disappointed that Instructure hasn't jumped in here to either clarify why they programmed the result this way or to confirm that it's a problem.  I'm also surprised that no o...

As I go through the other question types I'll add to this thread those that have the same problem.   The "Fill in multiple blanks" question type also fails to fill in the answer ID when th...

Using Canvas Data 2 data, I'm looking at student answers for Calculated questions.  When a question is correctly answered, the Answer_ID is populated.  When the question is incorrectly answered th...

Thanks for taking a look at your data.  It gives me confirmation that I may not be on the wrong track. At this time, I don't do anything through the API.  I work with just the CD2 data.

For the data warehouse, I was going to provide percentages (mean, min, max) for the assignments in addition to the points that are stored in Canvas.  But I can't do that for an assignment with zer...