Community

Thank you, James, and apologies for the delayed response. I've been away for a few days. I got some great clues from your post (this is a learning exercise for me as much as a problem to solve). I understand now that the Submissions API is acting correctly. I am actually using your canvasAPI() function, originally from your Course Due Dates Google sheet. When I check the Link headers, I get exactly what you suggested: "Link":"<https://rmit.instructure.com/api/v1/courses/20447/quizzes/73499/submissions?page=1&per_page=100>; rel=\"current\",<https://rmit.instructure.com/api/v1/courses/20447/quizzes/73499/submissions?page=2&per_page=100>; rel=\"next\",<https://rmit.instructure.com/api/v1/courses/20447/quizzes/73499/submissions?page=1&per_page=100>; rel=\"first\",<https://rmit.instructure.com/api/v1/courses/20447/quizzes/73499/submissions?page=3&per_page=100>; rel=\"last\"","status":"200 OK"} "Link":"<https://rmit.instructure.com/api/v1/courses/20447/quizzes/73499/submissions?page=2&per_page=100>; rel=\"current\",<https://rmit.instructure.com/api/v1/courses/20447/quizzes/73499/submissions?page=3&per_page=100>; rel=\"next\",<https://rmit.instructure.com/api/v1/courses/20447/quizzes/73499/submissions?page=1&per_page=100>; rel=\"prev\",<https://rmit.instructure.com/api/v1/courses/20447/quizzes/73499/submissions?page=1&per_page=100>; rel=\"first\",<https://rmit.instructure.com/api/v1/courses/20447/quizzes/73499/submissions?page=3&per_page=100>; rel=\"last\"","status":"200 OK"} "Link":"<https://rmit.instructure.com/api/v1/courses/20447/quizzes/73499/submissions?page=3&per_page=100>; rel=\"current\",<https://rmit.instructure.com/api/v1/courses/20447/quizzes/73499/submissions?page=2&per_page=100>; rel=\"prev\",<https://rmit.instructure.com/api/v1/courses/20447/quizzes/73499/submissions?page=1&per_page=100>; rel=\"first\",<https://rmit.instructure.com/api/v1/courses/20447/quizzes/73499/submissions?page=3&per_page=100>; rel=\"last\"","status":"200 OK"} So I needed to look elsewhere. Then I remembered that I had trouble with the object returned by the canvasAPI() function. When calling the Submissions API, the canvasAPI() function returns an object of the form: {"quiz_submissions":[{},{},{}]} instead of [{},{},{}]} so I was fixing this after using your canvasAPI() function. But what if this unexpected form of the array creates a problem within the canvasAPI() function itself? Sure enough, when looking through it I could see where it was falling out because the returned Submissions object was a single value/key pair. So, I used: if (json.hasOwnProperty('quiz_submissions')) { json = json.quiz_submissions; } to capture the condition, amend the object to the expected form and continue on. Now I'm getting all the data. Thanks for your help and your scripts! Cheers Ric ... View more

Hi  @stuart_ryan , I'm having the same problem as Glen did. There's more to it, though. When I compare the Student Analysis Report for a quiz with the data I get from calling the submissons API for the same quiz, I don't get data for all the students, for those students I do get data for, only their first submissions data is present. Changing the per_page value has an effect but doesn't solve the problem. When per_page is set to 200, I get the last 69 records ordered by student id, ignoring any subsequent submissions that may have been made by the student; when the value is 100, the same result. When the value is 50, the last 19 records are returned. When the value is 25, the same 19 are returned. When the value is 20, 9 records are returned and same again when the per_page value is set to 10. This is for a quiz allowing 2 attempts with 193 submissions. I may be missing something but the results seem to suggest there's something amiss with the Submissions API? ... View more