How can I get the students all the submissions in the tables exported from Canvas via CLI tool?

Question

Hi, Canvas Community,

I have a problem. The tables are exported from Canvas via the CLI tool (Canvas Data 2).

There is a table called "submissions". But this table only captures the students' most recent submission for one assignment. How can I get all the submissions for one assignment?

For example, the student has made a few attempts for one assignment. But the "submissions" table only captures the most recent submission for that assignment. How can I get all the historical submissions for that assignment?

Thanks.

IanGoh · Answer

Well, we sort of have a way, but it's because we do daily pulls of the CD2 data and use system-versioned sql tables.  I was helping one of our constituents find prior attempts, and it was sort of possible using our system-versioned sql tables.  The submissions had to be one day apart (due to our frequency).  So it wouldn't work if someone did three submissions on the same day, we'd only get the most recent at the time of the pull.

And, it might also depend on how the submission is setup.  Say you have multiple attempts, but you want HIGHEST SCORE, not most recent.  What if 
attempt 1 - you get 80
attempt 2 - you get 40

Unfortunately, from my testing, what I get back is 80 stored for BOTH attempt1 and attempt2.  I haven't figured out where the 40 went...

stimme · Answer

@JiaqiCheng Canvas Data 2 only includes current attempt submissions for assignments.