-
Canvas Data 2 Schema Out of Sync?
Hi All, Our group recently rebuilt our entire Canvas database with the release of DAP 1.1.0 (we were behind and using a deprecated version until that point). After dropping and initdb'ing all our tables again, everything was working again, with the exception of: 1. canvas.comment_bank_items, upon initializing, reports an…
-
(Canvas Data 2) Is it possible to scope on SubAccounts?
Hey Community, I’m currently trying to migrate my application to use Canvas Data 2 and I’ve been running against a problem and was wondering if you could help. Example: RootAccount * SubAccount1 * Account1 * Account2 * SubAccount2 * Account1 * Account2 I want to retrieve all data from SubAccount1, now I thought this could…
-
Canvas Data 2 Query Review
Confession: I am not a developer or an SQL expert, but I can view certain kinds of code, sort of learn it, and make adjustments as needed. Otherwise, I rely heavily on ChatGPT, particularly when it comes to SQL. 😁 That said, I was wondering if someone more experienced with SQL than I might be able to please look over the…
-
DAP Client syncing tables returning "pysqlsync base QueryException": column resource_link_lookup_uui
When we are running our DAP synchronizer python script, we are running into issues going back to Feb 27. This was the last time it ran successfully and we noticed it 2 days ago. When diving into the issue we are finding that several tables now are trying to cast automatically to type uuid. How do we fix this? Should we…
-
DAP CLI Tool Imports Structure but No Data into Tables
Hello Community, I'm currently working with the DAP CLI tool to import Canvas Data 2 into a database, but I'm running into an issue where the tables and column headers are created successfully but the table rows remain empty. This is after running the “initdb” command (dap initdb --namespace canvas --table TABLENAME). I am…
-
Canvas Data 2 public table submissions column submitted_at returns inaccurate dates
Good afternoon, PostGres SQL queries using Canvas Data 2 for the public table, submissions column, submitted_at field returns inaccurate dates. Below is an example of the results of a submitted_at field for a student in a class. The top is null because the row was for a teacher and would not have submitted the assignment,…
-
Decompress parameter in the dap client v.1.1
In v1.1 of the newly released dap client, there is now a decompress parameter in the API. Is there a plan to include this parameter in the CLI version of the dap client? I love this feature and have a workaround in place to change the default to True. Works great for my needs at present but would love to see it as a…
-
Canvas Data 2 403 Forbidden Error on the job endpoint
I am getting a 403 error on the job endpoint specifically. Please see the message below ********************** Got response: HTTP/1.1 403 Forbidden [Server: CloudFront, Date: Fri, 22 Mar 2024 13:53:34 GMT, Content-Type: text/html, Content-Length: 915, Connection: close, X-Cache: Error from cloudfront, Via: 1.1…
-
Canvas Data 2 authentication Error
I believe that I have followed the install directions for placing the Canvas Data 2 Command Line tool on my machine. I've created my Canvas Data 2 API key. I thought I would try out the simple command below, which is supposed to return a list of table names: dap list --namespace canvas But I get an error message:…
-
dap 1.x adds namespace prefix to MySQL table names
We devised a simple workaround to utilize dap 0.3.18 to load our production MySQL 5.7.15 tables. All of our CD2 SQL queries have been tested and deployed into production using the non-prefixed table names, e.g. assignments rather than canvas__assignments. The 1.x dap CLI release notes include the following: "In earlier…
-
CD1 to CD2 schema mapping document.
Hi , In the CD1 to CD2 schema mapping document below, [PUBLIC]: CD1 to CD2 schema mapping - Google Sheets enrollment_dim&fact sheet user_id field is obfuscated using the command " obfuscate_global(cast(enr.user_id AS bigint), g_shard_id)". But it's coming up with error in sql; "'obfuscate_global' is not a recognized…
-
Mismatch between API data and New Analytics
Can somebody please answer this question for me. I am experiencing very confusing anomalies between data obtained via API calls and corresponding data obtained via the New Analytics UI. Specifically, I ran the following API call to extract details of student activity on a course:…
-
Discrepancy between Requests and Web_logs
I was working on switching over a process I had previously been using CD1 Requests for to show the break down of the types of Operating Systems and Browsers are used by our faculty and students. When I was comparing the data I noticed there was substantially less data in the web_logs table compared to requests. Luckily we…
-
CD2 - How many assessment submissions have been graded
Howdy, I am trying to gather information on the number of assessment submissions are being marked by each of our marking staff. I use CD2 CLI to download CD2 tables. I then import into a database and then run SQL queries on the data. In the submissions table, it's my understanding that there are not entries for every…
-
Canvas Data 2 404 error on the data endpoint 'https://api-gateway.instructure.com/dap/query/canvas/t
I am able to call the schema endpoint, but I am getting a 404 error on the data endpoint 'https://api-gateway.instructure.com/dap/query/canvas/table/' + $splitValue + '/data' The error is: Failure: Failed to execute the request, or the endpoint responded an error, Reason: Got response 404 - Not Found from the endpoint,…