-
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?
-
Architecting an Automated Spatial Prioritization System for EORE in the oPt: Methodologies and Evaluation Framework
Introduction and Research Context In complex humanitarian emergencies, the static deployment of resources often fails to address the rapidly shifting vulnerabilities of affected populations. My research project focuses on developing an algorithmic Explosive Ordnance Risk Education (EORE) Prioritization System for the…
-
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?
-
Gathering Duration Data for How long a Student Spends on an Assignment. Specifically minutes, seconds, and hours.
Hello everyone, I was wondering if there is a way for the Canvas LMS to track the specific amount of time that a student spends on each assignment in a course. I am not referring to page views, I'm referring to gathering the date, time in minutes, seconds, and hours that a student spent working on each assignment in a…
-
CD2 assignments data changed/updated?
In our CD2 Assignments table, we're noticing a weird discrepancy: - ran a query in 2/2025 and saw 50 assignments in one class from 2018 - ran the query in 2/2026 and there were fewer (only 40 assignments) We looked at the Assignments table, specifically at the ts field. On 10/1/25, 100% of the records in that table (6.5…
-
Error initializing large table using dap on python 3.14
Hi — I've been struggling to initialize our "submissions" table using the dap CLI and I've narrowed down the problem to Python 3.14. I'm able to successfully run the same exact initdb command (on the same EC2 instance) under Python 3.13 and 3.12. On Python 3.14.2, the import successfully processes about 34 million records…