New Enum Values in (CD2) DAP Query API

[sgergely]

We’re excited to announce updates to multiple tables and columns in the Canvas namespace with new enumerated values (enums) that will be available in your CD2/DAP Query API dataset starting January 9th. These changes enrich the dataset with additional context and expand the range of supported use cases.

If you’re a DAP CLI user, no action is required on your part—CLI automatically handles new enum values seamlessly.

Summary of Changes

1. Conversation_messages, submission_comments, submissions
   • Column: media_comment_type
     • New Values: 
       • audio/aac, audio/amr, audio/flac, audio/mp4, audio/mpeg, audio/ogg, audio/vnd.dlna.adts, audio/wav, audio/webm, audio/x-m4a, audio/x-ms-wma, audio/x-wav, video/3gpp, video/avi, video/mp4, video/mpeg, video/ogg, video/quicktime, video/webm, video/x-m4v, video/x-matroska, video/x-ms-asf, video/x-ms-wmv, video/x-msvideo
2. access_tokens
   • Column: workflow_state
     • New Value: pending
3. assignment_overrides
   • Column: set_type
     • New Value: Course
4. assignments
   • Column: workflow_state
     • New Values:
       • outcome_alignment_cloning
       • failed_to_clone_outcome_alignment
5. attachments
   • Column: file_state
     • New Values: 
       • active
       • failed
       • public
       • processed
   • Column: context_type
     • New Values: 
       • DiscussionTopic
       • Switchman::Shard
       • DsrRequest
       • DemoSite
       • RubricImport
6. communication_channels
   • Column: workflow_state
     • New Value: deleted
7. content_migrations
   • Column: workflow_state
     • New Values: 
       • course_list_error
       • getting_course_list
       • have_course_list
8. developer_key_account_bindings
   • Column: workflow_state
     • New Value: deleted
9. discussion_topics
   • Column: discussion_type
     • New Value: not_threaded
10. grading_standards
    • Column: workflow_state
      • New Value: archived
11. learning_outcomes
    • Column: calculation_method
      • New Values:
        • weighted_average
        • standard_decaying_average
12. master_courses_master_content_tags
    • Column: content_type
      • New Value: MediaTrack
13. rubrics
    • Column: workflow_state
      • New Values: 
        • archived
        • draft
14. users
    • Column: workflow_state
      • New Value: active

The documentation is going to be updated once the release is out, so it always documents the current, live state of the system.