Hi Brian,I don’t download the requests table but it’s available to me in a “data lake”.   I access it using Alteryx and recently used this to obtain lists of unique activity dates per student.  From t...

Thank you James.  It's basically the same issue.  It seems it's currently not possible to establish timelines of workflow state changes.:smileycry:

I'm looking at the Course Dimension table from the Canvas data but can't find this info.  Does anyone know if it is available somewhere?

Thank you James.  I think this is where I must be going wrong.  I have neither the wiki the wiki_page_fact nor the wiki_fact available to me in the data lake at the moment.  They are going to be added...

I'm trying to get information relating to all of the wiki pages contained within a course from the Canvas data.  Looking at the wiki and wiki page dimensions I get only 1 wiki per course.  Am I missin...

You could take periodic snapshots using the Courses table where WORKFLOW_STATE will tell you if it's published ('available') or unpublished ('claimed').  You can add account (school, faculty etc.) and...

I only had very limited experience with LE some years ago.  This is probably the best place to get started; https://canvas.instructure.com/doc/api/file.data_service_introduction.html https://canvas.in...

Ignore above I've cracked the code.  You just need to string multiple account tables together joining COURSE.ACCOUNT.ID to ACCOUNT.ACCOUNT.ID to get the school level data and then join another account...

X

Problem statement: Canvas Data 1.0 had a fields which indicated which school and faculty a course belonged to (ACCOUNT_DIM.SUBACCOUNT3 and ACCOUNT_DIM.SUBACCOUNT2). From what I can see in the Account...