cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
nschutz
Community Participant

Student Data

Jump to solution

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?

Labels (1)
1 Solution

Accepted Solutions
James
Community Champion

 @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.

View solution in original post

2 Replies
James
Community Champion

 @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.

View solution in original post

lawd
Community Participant

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.