Quizzes Submissions API returns empty list

I am attempting to get the results of quizzes (by question by student, because the available student analysis report isn't great for importing in our data warehouse) using the API.

This call results in a response with empty quiz_submissions and submissions properties. Both the quiz and the course ID exist; they were retrieved from prior API calls.

I am an admin for the account.

What am I overlooking? Or is there a different API that would provide me with each students quiz results by question?

https://mydomain.instructure.com/api/v1/courses/{{CourseID}}/quizzes/{{QuizID}}/submissions?include=submission

Find more posts tagged with

Open API

Accepted answers

All comments

MattHanes

It doesn't seem like you are missing anything. I just ran the call in Postman on a fake quiz in one of my courses and it definitely returned information. So that call does work. I could only say to verify the course and quiz ids one more time.

James

@saelterman ,

@MattHanes checked the API call, which I was able to verify as well. I'm reading it differently and not as concerned about that as I am your use of "by question" a couple of times.

Are you looking for the responses to the individual questions for each student on each quiz?

The generally reported way is through generating the student analysis report, either through the web UI or through the Quiz Reports API. That CSV file is not the easiest format to work with.

For the request you're making, the include=submission doesn't include the submission responses, it includes the summary information about the submission (date, seconds late, score, etc)

The only place I have found to obtain answers to individual questions directly through the API is the Quiz Submission Events API. Not listed in the documentation for retrieving the information is the query parameter attempt= that will allow you to retrieve the results for an attempt other than the last one. It's not particularly easy to use either as it gives all of the answers and so you have to keep track of timing to make sure you get the last one that was actually submitted.

unknown

Are you looking for the responses to the individual questions for each student on each quiz?

Yes, correct.

That CSV file is not the easiest format to work with.

Correct again Smiley Happy You're on a roll. We have several different tests and each test having essentially a different schema makes it very time consuming to develop an ETL process for our data warehouse.

Therefore, I am hoping to simply retrieve the results "by question by student" to either generate our own flat file format or add directly in the data warehouse.

I am now researching the Quiz Submission Events API like you suggested. I hope it doesn't suffer from the same apparent issue as the Quiz Submission API I discovered above:

Is there some undocumented time restriction after which submissions can no longer be retrieved?

Thanks for helping!

Unanswered Questions

Concluded Course and Canvas Data Services
Canvas Data Services sent out an alert that a course was concluded (because the course was concluded) and the status of each user in the UI is set to complete, however, the enrollments API endpoint shows the status of each user in the course as active. Is this a common issue? Have I misinterpreted how the individual…
Canvas Media Question
How can one track Canvas Media use without having the reports available from Canvas Studio? Checking API endpoints and the Data 2 schema, there do not seem to be dedicated Canvas Media endpoints. Am I missing some? A method I've considered is using the body field of the wiki_pages table, as this contains the html code of…
Canvas Catalog API - Completed Certificates
Hello, I'm trying to utilize an API call to pull completed certificates and was hoping to download and store the certs as a backup. I can successfully run the API call but it will not allow me to view the certificate unless I access the URL while signed into an account where it's "my" cert. Is there a permissions setting…
UI for weekly progression idea
UI for weekly progression idea that rest in the Schedule tab of the **K-12 UI** of Canvas it's incomplete and I really would not take it and push it into instance but I am going to post it here because in the past people like @James && @robotcars || @Steve_25 have had terrific input in the past... maybe w/their eyes and…
Canvas integration with React + Flask webapp - initially for authenticaiton
I have a new React + Flask webapp. It has its own login for users to start using the app. I have added this as an external tool in Canvas. What I want initially is to see of canvas users can start using the webapp without having to login if they click on the external tool link in a canvas course. I have 2 methods…