It is actually much more complicated than that if you actually want to get the default email for a user who may have multiples, as the email in the communication channel is joined via the pseudonyms. ...

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

The documentation contains details about Filter Identifies a subset of data to fetch from a table. (This feature is not currently implemented.)   When is this going to be made available?  This fea...

The Canvas Data 2 web_logs should contain everything you are after - but only for the last 30 days, and there will be a LOT of data to wade through.  That said, the presence of the user_id  and the  r...

@stimme wrote: maximum number of enrollments one user can have in one course is the product of sections x roles in your Canvas instance. The e.type = 'StudentEnrollment' WHERE clause e...

It is actually much more complicated than that if you actually want to get the default email for a user who may have multiples, as the email in the communication channel is joined via the pseudonyms. ...

The Canvas Data 2 web_logs should contain everything you are after - but only for the last 30 days, and there will be a LOT of data to wade through.  That said, the presence of the user_id  and the  r...

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

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