The most recent content from our members.
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…
Wondering if admin announcements are avail (or planned) for CD2? The announcements API only presently supports courses. It's a rather niche query but thought I'd check as I didn't find anything in [canvas].[discussion_topics] /[canvas].[discussion_entries].
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,…
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…
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…
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…
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…
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…
@sgergely It seems that schema versions for a number of tables in the the canvas namespace have reverted. For example, "rubrics" had been at version 2 in mid February, but shows version 1 when downloaded today from DAP. The following tables seem to have issues: access_tokens assignment_overrides assignments attachments…
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…
Sign in to enhance your access to articles, forums, and events—and to participate by sharing insights, engaging in discussions, and connecting with your network of edtech peers.