I've used Postman and am able to get data from Canvas Data Portal 2.  I'm trying to do the same thing in Python.  I'm able to get all the preliminary steps (GetJWT, Dispatch query, get status of query) in python, but get a bad request format when try...

As far as I can tell there currently isnt a way to get the account settings using Canvas Data 2 but I would love to be corrected.I can see that the genuine Canvas backend has a feature_flag table for this as well as a settings column in the accounts ...

We are looking for a way to create a report showing all the settings selected for quizzes and assignments in a spreadsheet. We are finding that when we create multiple quizzes or assignments, we sometimes miss enabling certain settings every time (i....

I'm trying to see if students bother to look at the responses I give on the discussion board after their participation deadline.  As a result, I've exported the course activity via 'New Analytics'.  In the "Content Type" column of the csv file I down...

Problem I've noticed there are entries in most course content items for a migration_id. My assumption was this was a way to join with the content_migrations table, but the id in that table doesn't match the format of the migration_id.  What I'm Tryin...

A disgruntled teacher when through and deleted a bunch of stuff from a bunch of courses. I need to be able to answer this question, and seemingly cannot due to inadequate Canvas logging.    "What did a faculty person delete, from where, and when"? If...

I am trying to populate a database with ALL the tables in the Canvas namespace. I am following the instructions on this documentation to initialize my database using the initdb command. Below is my CLI:   dap initdb --connection-string my_connection_...

I'm seeing a lot of students that do not have a value within the Enrollments table in their "last_activity_at" attribute.  I resync'd my data this morning into Postgres and found a case where a student showed no activity, but had completed several as...

Why does listing tables from canvas_logs namespace still return the user_agents table? I thought this table was deprecated/sunset? Is there a plan to stop listing it? This dap command returns the following: dap --base-url $DAP_API_URL --client-id $DA...

Hello,  I am looking at the New Analytics for my course and it is showing zero participations, but I know students have submitted quizzes. This is listed as what counts as a participation so why is it not generating numbers on the graph (image attach...

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...

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__'...

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, 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...