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 · Accepted solution]

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 

[matthew_buckett]

@stimme Thanks. I was wanting to quickly report on what sort of thing people had put into the usage_rights fields, and iterating is just too slow and not worth it. I just wanted to so a quick:

SELECT copyright, count(*) FROM files group by copyright;