List Of JSON Columns?

[JimEgan]

Has anyone put together a list of columns in Canvas that contain embedded JSON data?

So far, all I have is:

ASSESSMENT_QUESTIONS.QUESTION_DATA

QUIZ_SUBMISSIONS.SUBMISSION_DATA

QUIZ_QUESTIONS.ANSWERS

[LeventeHunyadi · Accepted solution]

For Canvas tables exposed via DAP/CD 2, the following have JSON data with declared internal structure:

assignment_groups.rules
assignments.turnitin_settings
context_external_tools.settings
courses.settings
quiz_questions.question_data

For the following Canvas tables, we verify the JSON syntax for the table column but don't enforce any particular internal structure:

access_tokens.scopes
assessment_questions.question_data
content_migrations.migration_settings
context_module_progressions.requirements_met
context_module_progressions.incomplete_requirements
context_modules.prerequisites
context_modules.completion_requirements
developer_keys.scopes
grading_standards.data
learning_outcomes.data
master_courses_child_content_tags.downstream_changes
master_courses_master_content_tags.restrictions
master_courses_master_migrations.migration_settings
master_courses_master_migrations.export_results
master_courses_master_templates.default_restrictions
master_courses_master_templates.default_restrictions_by_type
master_courses_migration_results.results
rubric_assessments.data
rubric_associations.summary_data
rubrics.data
submissions.turnitin_data
web_conferences.settings

[JimEgan]

Thank you!  This is going to be very helpful.