About

a1222679
Rank:
Community Contributor
Title:
Joined:
Aug 25, 2016 8:59:12 PM
Posts:
45
Solutions:
1
Likes Received:
124
Bio:
An amazing Instructure Community member

Most Liked Posts

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...
Likes: 6
Thank you James.  It's basically the same issue.  It seems it's currently not possible to establish timelines of workflow state changes.:smileycry:
Likes: 5
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?
Likes: 5
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...
Likes: 3
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 mi...
Likes: 3

Most Recent Posts

That's awesome, thank you @sgergely 
Nov 26, 2024 2:09:34 PM
Thank you @stimme I hadn't seen that.
Nov 18, 2024 1:24:54 PM
The data is stored in our data warehouse and I query all courses from there in Power BI.  I haven't been running API queries at all.
Nov 18, 2024 1:20:47 PM
With CD1 I used to be able to get a list of all the items in the navigation bar for a course. In the CD2 documentation it says that I should be able to find this information in the Courses table... t...
Nov 17, 2024 8:01:25 PM
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 (schoo...
Oct 19, 2023 3:56:18 PM

Latest Badges

50 Replies Posted

50 Replies Posted

Earned: 2024-11-18

Instructure Community: 8 Year

Instructure Community: 8 Year

8 Years with Instructure Community

Earned: 2024-09-24

3 Solutions Provided

3 Solutions Provided

Earned: 2024-08-22

First Solution Provided

First Solution Provided

Earned: 2024-08-22