Canvas API Quiz Submissions get all attempts for each student?

[Denham]

G'day! I'm trying to extract all the submissions (including all attempts by each individual) for a quiz,

Looking at the API:

/v1/courses/{course_id}/quizzes/{quiz_id}/submissions

• Get all quiz submissions.

Implementation Notes

Get a list of all submissions for this quiz. Users who can view or manage grades for a course will have submissions from multiple users returned. A user who can only submit will have only their own submissions returned. When a user has an in-progress submission, only that submission is returned. When there isn't an in-progress quiz_submission, all completed submissions, including previous attempts, are returned. 200 OK response code is returned if the request was successful.

this sounded to me like what I should use, but it isn't including all previous attempts, only 1 attempt is being included in the response message.

Anyone encountered this before and have a solution handy? (I'm using VB, extending on the spreadsheet that was shared by stelpstra) - I checked and confirmed that the data being returned via the live API is incomplete (not returning the 2nd attempt).

[chriscas]

Hi @Denham,

Have you verified that users you're experiencing the issue for don't all have an in progress submission at the moment (as the documentation states "When a user has an in-progress submission, only that submission is returned.").  This seems the most logical explanation, but have you also verified that the students do have multiple attempts and not just a single one?

P.S. I moved your post to the developers group, where there are more experts for API type things, so someone else here might provide a more in-depth answer if you can verify the things above.

-Chris

[Denham]

Hi Chris,

I just got a solution working thanks to https://community.canvaslms.com/t5/Canvas-Question-Forum/Get-All-Quiz-Submissions-API-not-working/m-... 

On the Live API there was no information about including attempt as a query string parameter, nor is it listed on https://canvas.instructure.com/doc/api/quiz_submissions.html#method.quizzes/quiz_submissions_api.sho... 

so very grateful to @James  for the information he shared on that previous question.