Student Data

[nschutz]

When student upload a file in the assignment submission, is that file stored anywhere in Canvas data or is it in a file system somewhere? In the Submission _dim table, there is a field "body", but where are the uploaded files stored and how is it retrieved?

[James · Accepted solution]

 @nschutz  

The contents of the files are not stored in Canvas Data, but the information about the files is. With that information, you should be able to fetch it through the API. Start with the submission_file_fact, file_fact, and file_dim tables.

[lawd]

I think the submissions api endpoint would be the best way to retrieve file. The two best ways is to get a list of all submissions for an assignment, or get all the submissions for one student for one assignment. Within attachments, there is url that will directly download the submission file.