The most recent content from our members.
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…
Is there a way to tell via CD2 if a course is using Enhanced Rubrics? I didn't see it in the entity diagram for Rubrics table, but I might have missed something... Thanks Ian
Hello, I'm posting here for our developer. I hope someone can help steer us in the right direction. We have been running the CD2 API for almost a year. We have run a full reload of the tables once with a column addition, and process delta runs daily. I happened to notice that our courses table is not receiving updates when…
I've read carefully two threads that discuss the contents of the quizzes and assignment tables in CD2: https://community.canvaslms.com/t5/Data-and-Analytics-Group/Assignments-vs-Quizzes/m-p/576490#M1836 https://community.canvaslms.com/t5/Data-and-Analytics-Group/New-Quizzes-CD2/m-p/604408#M2791I I was able to aggregate a…
I don't think this is the intended behavior. But please correct me if I am wrong. Table: pseudonym Column: value_unique_id Data: `NORMALIZATION-COLLISION-d5863032-ag94-4593-6g6d-adf9371f2eb9-xxxxx@gmail.com` spit-balling: So I'm beginning to think that the issue is related to them making login_id unique. (thanks @daniel)…
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.