CD2 and Course Audit information

We're trying to find the course publish date and who published over a range of courses.  We know we can use the Course Audit API - https://canvas.instructure.com/doc/api/course_audit_log.html ...

Course Audit API

We were trying to retrieve when courses (plural) were published and by whom using the Course Audit API.  https://canvas.instructure.com/doc/api/course_audit_log.html  For "Query By Cour...

2023-12-18 DAP Querying service is overloaded or under maintenance

Just got the following 503 { "error": { "uuid": "8a31f148-167e-4e83-981a-1982caf43480", "message": "DAP Querying service is overloaded or under maintenance.", "type...

Cloud Access to CD2

Our data team asked the following:   Does CD2 keep the actual tables in s3 containers as parquet or other file types ? And could they provide a url to the s3 container? Our fabric allows...

CD2 data lag

Just curious, we're seeing the current data lag about five hours.   Do you concur?  I know the target was eventually four hours.   Ian

Submissions.Grade vs Scores table

We're trying to understand Assignment grades. We have an assignment set for submissions: none grades (percentages) uploaded but not posted For that assignment, in CD2: Scores table ...

BETA folk - reminder to check your key expiration

We were in the BETA and our CD2 key is now coming up to the one year expiration.  So just a heads up  for those who were in the BETA at the time to check if your key is about to expire too.

Catalog CD2 tables

We're starting to play with bringing in Catalog tables. Is there an equivalent to https://data-access-platform-api.s3.eu-central-1.amazonaws.com/index.html that documents the Catalog tables? 

CD2: test student

We were validating some course counts and noticed that the "Test Student" is counting towards our enrollments. Our CD2 Users has 20K "test students". I looked at the user's workflow state, but the ...

Assignments vs Quizzes

I'm trying to explain to some internal folk the difference between the Assignments and Quizzes. I "think": there are four types of classic quizzes (graded quiz, practice quiz, graded survey, un...

CD2: requests object skipped a number?

Just happened to be running a request, got back { "id": "f6173a8b-e377-4f44-9919-3284cac40a88", "status": "complete", "objects": [ { "id": "f6173a8b-e377-4f44-99...

CD2: classic quizzes and scores

I've run into a roadblock trying to associate scores w/ quizzes (classic) From the scores tables, the only linkages are assignment_groups, enrollments, grading_periods. However, assignment_groups...

Scores to Assignments to LTI

Now that I have my hands on scores, I'm trying to track back to if a certain score was associated with an LTI tool. From scores I can get to assignments. And, then it seems assignments ->&nbsp...

conversation_messages.context_type only has Account?

I was investigating if I can find out if a student messaged a course teacher. When I looked at our CD2 conversation_messages table, all the context_type seems to be Account. I could work backward...

How long does the X-Amz-Security-Token last?

I was testing getting wiki_pages - which gave me 8 part URLs. I was successful getting the files initially, but then when I retried the same URL later, I got an ExpiredToken.  How long does th...

discussion_entry_participants - when did they read?

I have the CD2 data for Discussion Entry Participants ( https://data-access-platform-api.s3.eu-central-1.amazonaws.com/index.html#tag/discussion_entry_participants ) but it has no timestamp informati...

The requested job id could not be found

I'm inquiring from our data team, yesterday evening they got an error getting data back for a job.  It's not failing all the time, so is it worth pursuing, or it's just one of those - it could h...

assignments - why do i have assignment ids but no title, etc.

I've finally got my hands on assignments, submissions, quizzes data. However, I'm finding i have submissions with assignments ids that are graded, but when I look in the assignments table I have ve...

CD2: where are the course final grades?

Another n00b question, via the REST API, I get the final grades via the Enrollments object;   // The URL to the Canvas web UI page containing the grades associated with this // enroll...

CD2: submissions vs quiz_submissions

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