Is there a table for uploaded files in CD2?

matthew_buckett

Hiya,

I was just trying to see what people had set as the copyright holder on the files uploaded to our Canvas instance. Looking at the list of CD2 tables I could see a table for folders: 

https://data-access-platform-api.s3.amazonaws.com/index.html#tag/folders

but I couldn't see one for files. There used to be a dimension and fact table for files in CD1:

https://portal.inshosteddata.com/docs/#file_fact

https://portal.inshosteddata.com/docs/#file_dim

but these don't seem to hold any details of the copyright holder.

Anyone got a solution?

Thanks.

Matthew

stimme

Hey @matthew_buckett ,

The CD2 successor to file_dim and file_fact is attachments. It has a foreign key to a usage_rights table that is not exposed yet. Perhaps it will be in the future.

The best way to get usage rights info right now would be calling the Files API endpoint to list files and to include usage_rights. https://canvas.emory.edu/doc/api/files.html#method.files.api_index