Tagging @sgergely since this is mostly a question for him, but I suspect it'll be of interest to folks like @ColinMurtaugh and likely others. For a few years, we've been using a mixture of CD1 requests and Canvas Live Events. They both have their pro...

Hi all,I am getting this error SELECT cls.relnameFROM pg_catalog.pg_class AS cls INNER JOIN pg_catalog.pg_namespace AS nsp ON cls.relnamespace = nsp.oidWHERE nsp.nspname = 'instructure_dap' AND (cls.relkind = 'c');when syncing the table with dap 1.1....

Got my hands on the LTI tables in CD2 now, trying to query if I can list all LTI 1.1 and 1.3 related to a specific course. Context_External_Tools (LTI 1 and 1.3) - has two kinds of tools (context_type) - Account, Course if context_type: course, then ...

The CD1 Requests table included a significant disclaimer: "The data in the requests table is a 'best effort' attempt, and is not guaranteed to be complete or wholly accurate. This data is meant to be used for rollups and analysis in the aggregate, _n...

Mostly a question for @ sgergely and @GergelyTar - I was just wondering if there's anything on the DAP client roadmap for syncing to an S3 location and/or using Iceberg? We're going w/ PostgreSQL for convenience in making our transition from CD1 to...

I’m working with Canvas Data 2 API and am having trouble accessing S3 files programmatically. While I can manually open the provided URLs in my browser, I receive a 403 Forbidden error when trying to access them using Python. I’ve been provided with ...

We're not using DAP, so our job failed when checking the schema version the other day for the web_conferences table. (We currently do schema updates by hand for ... reasons.) Is there a change log of CD2 schema changes anywhere? I don't recall any an...

Hi all,I know anyone who uses the One to One model of Canvas with Blueprints Enabled runs into the issue where you will need to see the markbooks for multiple courses that were populated from a blueprint We are of a site where we have over 30 one to ...

DAPClientError: malformed HTTP response occurs at least twice in a month. and was unable to identify the exact issue.   DAPClientError Traceback (most recent call last) Cell In [35], line 3 1 if __name__ == '__main__'...

Apologies for not knowing where else to ask. Our institution is a bit late to the full understanding of how outcomes beyond the course level can help us make informed decisions. I'd like to start with how to replicate the Learning Mastery Grade book ...

In previous terms, by disabling New Course and User Analytics in the Features Options of the settings automatically reverted back to the old analytics. However, the same process is not working for my Fall 2024 course. Disabling New Analytics removes ...

Hello!  I'm doing some time calculations and wanted to use the time_zone from the courses but I am finding a lot of courses that don't have the time_zone property in the JSON but when I look at the course in Canvas it does have a time zone set.  Has ...

Hi!  Does anyone have experience with how Advise interprets Canvas data, particularly regarding LTI analytics from Canvas/publishers?  We have Advise and Canvas connected and better understand the data such as "Participation" and "Submission" but we'...

Hi, Canvas Community,   I have a problem. The tables are exported from Canvas via the CLI tool (Canvas Data 2). There is a table called "submissions". But this table only captures the students' most recent submission for one assignment. How can I get...

Hey Community,I am currently working on a synchronisation of my own database, in which I make use of Canvas Data 2.Right now I am fetching their data, mapping their models to my models and filling my database with it. This is currently a migration of...

I'm trying to calculate the average number of students who have viewed at least 1 page on the site per week. So far, not getting anywhere because I need to be able to see unique page views rather than just 'page views'. Any ideas how to get this out ...

Wondering if anyone has any suggestions regarding some "time series-like" analytics for enrollments total_activity_time and active user counts? I'm conscious that CD2 is "eventual consistency" so time series analysis of things like weekly total_activ...

Hi all! I'm trying to identify a path forward for my institution to leverage the Canvas Data 2 API to obtain data around course level participation. From what I've gathered, it seems to have been possible in v1 of the API but I'm not immediately seei...

I know that you can only see and manage the keys that you generate within the Identity Services, so they must be associated to the user. But do they also inherit the Canvas User's status, roles, and permissions? Or, once generated, are they independe...

Hi Instructure! Is there a way to access the time zone code for the user's set time zone? Example: Right now, a user can set their time zone in the LMS to  Eastern Time (US & Canada) (-06:00/-04:00)at /profile/settings.The time zone value for this us...

I am being tasked with creating a Tableau dashboard that looks at New Analytics at a more global/course level scale. Does anyone know if there is a backend query that drives the New Analytics data that I could fork as way to improve my query? 

I'm updating our init and sync code to reflect what is prescribed in the documentation's Instructions and I am receiving the following error when i run pip install           × Building wheel for tsv2py (pyproject.toml) did not run successfully. ...