New Table in CD2/DAP Query API: Collaborations

sgergely
Instructure
Instructure
3
605

Canvas.png

We’re excited to announce updates to a new table in the Canvas namespace that will be available in your CD2/DAP Query API dataset starting February 10th. 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.

The collaborations table will look like this:

collaborations

This table contains attributes related to collaborations.

  • Parameters:
    • id (int64) – primary key The ID of the collaboration.
    • collaboration_type (Annotated[str, MaxLength(255)] | None) – The type of the collaboration.
    • document_id (Annotated[str, MaxLength(255)] | None) – The ID of the document.
    • user_id (users| None) – The ID of the user.
    • context_id (accounts | groups | courses | None) – The ID of the context.
    • context_type (collaboration__context_type | None) – The type of the context.
    • url (Annotated[str, MaxLength(255)] | None) – The URL of the collaboration.
    • uuid (UUID | None) – The UUID of the collaboration.
    • data (json | None) – The data of the collaboration.
    • created_at (datetime) – The date this collaboration was created.
    • updated_at (datetime) – The date this collaboration was updated.
    • description (bounded_str | None) – The description of the collaboration.
    • title (Annotated[str, MaxLength(255)]) – The title of the collaboration.
    • workflow_state (Annotated[str, MaxLength(255)]) – The workflow state of the collaboration.
    • deleted_at (datetime | None) – The date this collaboration was deleted.
    • context_code (Annotated[str, MaxLength(255)] | None) – The context code of the collaboration.
    • type (Annotated[str, MaxLength(255)] | None) – The type of the collaboration.
    • resource_link_lookup_uuid (UUID | None) – The UUID of the resource


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

3 Comments
Bjarquin
Community Member

I can used canvas yet I just started in college Medical assisting .

stimme
Community Coach
Community Coach

@sgergely Has there been a change to the release date for canvas.collaborations in CD2/DAP?

sgergely
Instructure
Instructure
Author

@stimme yes, there was a slight delay because we have discovered an issue with in the Catalog schema where a new column (hide_in_user_workflow ) got added unplanned in the table user_defined_fields. And this additional column broke the DAP CLI for those who have been syncing this table. 

Both collaborations tables and the new schema for Catalog namespace has been released and I would like apologize for the inconvenience we have caused.