Hello! My institution has just started our Canvas Data journey and we have not quite received the upgrade to CD2. I have installed and successfully run the CLI tool to pull the data down onto my local machine and start pulling data into Power BI for ...

So I'm wondering why this is, but if the file names returned from the table query endpoint (/dap/query/canvas/table/{table name}/data) are to be sequential (part0, part1, part2, etc.), why then does this not seem to be the case consistently across al...

While I developed a "partially" working solution for CD2, it's nowhere near the robustness of my CD1 daily download and ship to AWS. I'm interested in seeing a working solution for CD2, even a generic one. If so, sharing the setup for this would be V...

Trying to get the dap client running to no avail. dap schema --table wikis 2023-04-20 09:53:35,688 - WARNING - Received error in response: {'message': 'The client is not authorized to perform this operation.'} 2023-04-20 09:53:35,692 - ERROR - {'mess...

I thought I'd start a thread for posting Canvas Data 2 queries we've found useful, and not being a DBA myself, for review/feedback if you have found better ways of getting the same data.Users Query, including pseudonym/communication channel lookup (l...

I don't see the feature_flag table (relevant model in the Canvas code) listed in the CD2 schema documentation, either in the list of tables included or the list of tables that are not exposed. Can this table be made available? It would be handy to be...

Another n00b question.  I'm trying to find our the last quiz or test submission for a student.From Assignments, I know about the submissions table.  But there's also a quiz_submissions table.If I'm just looking for the last quiz submitted, can I get ...

is anyone encountering this error message on canvas analytics? is it temporary?

With Canvas Data 1 we could give specific users access to the data. This would allow us to have users that can use Canvas Data, but not have admin access to anything outside of that. We have data professionals in other departments who are allowed acc...

Our Institution was part of CD2 Beta Phase, we used the identity service and was able to generate the API key and accessed the DB snapshot etc.Now that CD2 is available as general availability, we want to generate an API key not associated with a can...

We wanted a way to import selected data from selected Canvas tables into a Microsoft SQL Server instance in a way that can be scheduled for automation and required the smallest number of dependencies and tools.  Using canvas-data-cli, we were able to...

Even though some workarounds have been pointed out for other parts of Canvas, so users can see Mon-Sun weeks (like changing the language settings to English UK), that does not work when running the New Analytics Online Attendance option. It would be ...

1. Can it be opened in full screen to avoid scrolling?2. Will you build an export function for SIS's like Anthology Student?Thank you.Dr. Kiko Suarez

Hi everyone.  Does anyone know a tool or workaround to identify which courses have assignments with outdated due dates?  We need to ensure all due dates have been updated to be within the confines of the current term.  We are using AspireEDU Dropout ...

Hello,I need to see who has been enrolled in all courses in one Term. I have ran the Provisioning Courses report and the Provisioning Enrollments report and I am not getting the information for anyone that has not accepted the enrollment. How do I ge...

Hi,We are starting to use the canvas data service with the caliper schema to integrate with other apps. Does anybody knows what happens if when instructure send the request an it returns a html code different to 200?? Does the instructure retry to se...

I'm unsure how to go about making copies of data from external LTIs that are part of a given set of notes, e.g. quizlet, Duolingo, Geogebra, etc.

The schema says quiz_submission_historical_dim contains "Attributes for all submitted quizzes" which lead me to believe I would be able to find the dates of each submission.  However, at least in our data, the only items in this table with data in th...

Hello, I am trying to get files from the Canvas Data Portal that we can read and use. We have used the 7Zip file reader to open the gz files as recommended and we can get a couple of fields to show, but the rest of the fields are errors and the field...

Thanks to another post on this board, I found out that New Quizzes data is not included in Canvas Data. I asked our SCM about what other data is not included, and he referred us to Account Services. They recommended that I look at the schemas, but th...

Hello there.  I attached what I found about Studio data.  It is useful, but not what I need.  I want to answer a question that will inform decisions about media production resources. My question is pretty basic.  "Are students viewing our Canvas Stud...

Submissions data for New Quizzes don't appear in the quiz submission dim or are exportable from the UI in the way the original quizzes were.  The FAQ only says that an API will be created one day.  Does anyone know if there's a way to download all Ne...