The question is a little confusing.  Courses are not cross listed - cross listing "moves" a section from one course to another. If you look at the course_sections table for the section, it contains tw...

You have covered it in your following post, but for anybody else encountering this - you have to add the name, not just delete the section, as deleting it will still have the CD2 data element present ...

For most users this is a moot point, but you do need to understand that their is a real meaning behind this.  If you only have a single Canvas instance, then all the the id references are local (to en...

Web logs are a different space to tables. Try GEThttps://api-gateway.instructure.com/dap/query/canvas_logs/table (and use the canvas_logs rather than just canvas in the other queries as well)

As @reynlds said, there is far more to it than that - as there are a number of different factors interacting. In the submissions table, you need to look at the "excused" boolean for that condition, an...

@LeventeHunyadi wrote: We are looking into providing referential integrity across tables, and have identified approaches how we can make this possible in a scalable manner. I hope this investigation ...

Welcome to the world of Canvas Data 2 inconsistency. I am making some assumptions here, as your post is not completely clear to me.  If I understand correctly, You are using the DAP client to maintain...

I know this is a bit old, but I think the answer is that you can't.  There are some things that Instructure has explicitly stated that they only have the most recent version (quiz submissions), but I ...

I think you will be disappointed.  You need to add a name.  Just changing the workflow_state to deleted isn't going to fix the constraint problem - the record is not hard deleted, and will still appea...

I don't think this is ever going to be possible or feasible.  Canvas Data 2 operates as a Data Lake, where data is ingested (with some transformation), then available for efficient extract.  The filte...