-
CD2 page_views and requests not working?
We have consultants helping us pull data from CD2 They are having issues pulling some data, and have asked us for help….can anyone give me any guidance I can bring back to them: …we were able to successfully extract data from Canvas using the available APIs and load it into Databricks. However,…
-
API Query for All Courses in a Term
I am creating an API call that queries courses for the syllabus document by using the "/v1/courses/{course_id}/files" GET statement. I have proven that the GET statement works as expected. However, I need an efficient way to retrieve all of the {course_id} numbers for a particular term. I have looked at other GET…
-
Where to get students calculated grades?
Hello, We are trying to get student's calculated grades from Canvas course sections. It looks like the Canvas Data 2 datasets do not provide this calculated data, which makes us have to manually calculate the grades and we're concerned our calculations won't always match what faculty and students see in Canvas. Is there a…
-
Students Missing From Activity Report
Using Canvas Free For Teacher Account to deliver content to high school teachers. On the site, the People tab currently lists 1,593 students (including 345 pending), but the Activity tab only shows data for 1,360 students. Activity has data on everyone who was enrolled (pending or not) as of about December 2025, but…
-
Canvas Data 2 Syncing Issues
Hi, We've been having some sync issues in the past 8 hours or so. We're using DAP client, both the CLI and the Python library, and we're getting errors back from the Instructure servers. With the CLI, we're getting errors back for all commands, along with {'message': None} as the Reason: And in the Python library a similar…
-
How much do you rely on the strict typing in the DAP schema?
Hi everyone, I'm exploring some changes to how the DAP Query API handles schemas, and I want to hear from you before we go too far down any path. Here's the situation. The DAP schema today is fairly sophisticated. It defines specific enum values, type constraints, and so on. That gives you a strong data contract, but it…
-
Issues with overnight DAP
Hello! Has anyone noticed slowness/failures in their DAP processes? We use the incremental CLI from DAP overnight starting around 1 AM Arizona Time. It was taking 15-20 minutes for a sync to occur. Then around 4/17 to now it's taking over an hour. Last night we even got 500 errors from the DAP Api and one of our other…
-
How can I get specific students' activity streams from the API?
We are currently using the user in a course level participation data report we created with our data warehouse to highlight students who haven't participated in a certain amount of time. The Registrar then checks each of those marked students to check if they at least viewed a course page or assignment more recently, since…
-
Is it possible to get the exact time of the four hour interval our DAP Data Refresh happens at?
We'd like to time our syncdb commands so we know what time index we're pulling down data FROM. Currently we're doing it once every 24 hours automatically, but we occasionally have need, in a given business day, to sync changes that have been made and it would be very helpful to know if we're going to be getting data from…
-
initdb for big tables aborts part way through
While running the DAP 2.2 CLI on a Windows 11 machine, using Python 3.3.12, to push data into an Aurora PosgtresQL database, the data load aborts mid way through — it will look something like this: For some of the medium-sized tables I truncated the table, re-tried and it eventually loaded all the data; for this biggest…
-
What is uninitialized workflow_state value for new_quizzes.quizzes in Canvas Data?
On the new_quizzes.quizzes table, all of my institution's records have either "unpublished" or "uninitialized" values in the workflow_state column. The documentation for this type lists "published" as a possible value. It seems like all of my institution's published New Quizzes have the "uninitialized" value. What does…
-
How is "NA" a permissible value in the "criterion_use_range" field?
I recently received a data dump of ALL rubric data from our Canvas instance so that I could analyse how our rubrics are being set up. One field I was interested to investigate was the ratio of rubrics using point vs using ranges. This field seems to be captured by "criterion_use_range" and contains values TRUE (i.e. is…
-
What determines CD2 new_quizzes.quizzes.practice_quiz value?
The new_quizzes.quizzes table has a practice_quiz boolean field described as "whether the quiz is a practice quiz." The does not correspond to a configurable field, as far as I can tell. I wonder, how is this field's value determined? What is a practice new quiz?
-
Error when performing DAP syncdb on web_logs table
We are getting this error today when syncing the web_logs table and the sync fails. I have never seen this one. 'invalid input value for enum canvas_logs.web_logs__web_application_context_type: "SisBatch"' Has anyone else seen this?
-
Error today syncing web_logs table
We are getting this error today when syncing the web_logs table and the sync fails. I have never seen this one. 'invalid input value for enum canvas_logs.web_logs__web_application_context_type: "SisBatch"' Has anyone else seen this?