Jago Brown

CanvasData schema documentation - inaccuracies

Discussion created by Jago Brown on Jun 8, 2018

This post is to remind Instrucure to try and keep documentation up to date, so customers don't individually waste time finding out the hard way. e.g. by importing Canvas data into a database which then throws errors because of unexpected values not listed in the documentation in ENUM types


I read the schema for submission_dim and have so far found at least 2 values not enumerated in the documentation

Canvas Data Portal 


  • column workflow_state - should include "deleted"
  • column submission_type  - should include "basic_lti_launch"




Below is an example in the API documentation where it has not been updated removing the 'computed_' part of the name:


Even 6 months after posting the above screenshot:

How to calculate students “Total Activity” time spent in a course with Canvas Data?