The most recent content from our members.
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,…
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…
@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…
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?
Hey folks I've finally managed to wrestle all of my DAP queries into Power Bi dataflows, and it was quite an ordeal. I'm currently using dataflows with DAP as a surrogate databasing solution as we do not currently have access to a SQL server that can store our info, otherwise I would probably be fetching this data using…
I know this gets asked every couple of years, so I guess I'll take up the call this year. We're developing an application that uses CD2. We've been getting by generating fake data on a table-by-table basis as we need it, but we're getting to a point where what we really need is the full CD2 schema with data that's safe for…
Hey there, My institution is going to be implementing CD2 in SQL Server and Power BI in the not to distant future. I'm reaching out to see if anyone might be interested in sharing techniques, and lessons learned in any of the following: how they orgainzed the data, if and how they went about in dimensional modeling of…
The issue -- we currently pull reports from the api/v1/reports several times a day, and the person who is responsible for those jobs that has complained to me on multiple occasions that they take a long time and often get stuck or fail, because of the size of the reports. It looks like all of the data in those reports is…
Hi all -- The courses table in DAP has a tab_configuration column which holds a JSON array of various configurations for the course. We recently decided to try to take advantage of that information to determine which files are visible to students (one component of which is whether or not the "Files" section of a course…
On the Upcoming Canvas Changes page, I see that the UUID field is being deprecated from the File API response on 8/13/2025: 2025-08-13 Change TypeChangeDescriptionEffective DateResourceDeprecationRemoval of the UUID field from the File API The UUID field is removed from the FIle API response in efforts to streamline…
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.