[ARCHIVED] List all courses with rubrics

[racheleve_davis]

I'm trying to find out which instructors at our institution are using rubrics in their courses within a subaccount, and would like a list of courses with rubrics. I don't see a report that would give me that information, and from what I can tell, the API endpoints only generate a list of subaccount-wide rubrics, or a list of rubrics per course ID.

I'm a subaccount admin, and our institution is self-hosted, so we don't have access to Canvas Data or Instructure support. Any tips appreciated!

[jerry_nguyen]

@racheleve_davis 

You can use GraphQL, the playground is available at https://yourschool.instructure.com/graphiql . The following query will list all assignments within a course and whether a rubric is associated and if they're being used for grading

query MyQuery {
  allCourses {
    name
    assignmentsConnection {
      nodes {
        name
        rubric {
          title
        }
        rubricAssociation {
          useForGrading
        }
      }
    }
  }
}

However, "allCourses" endpoint will be limited to courses that you're enrolled into (either as a teacher or student). 

In order to get account-wide data without Canvas Data, you'll need to write a program and provide it with the list of all courses IDs to loop through and filter the data.

[racheleve_davis]

Thank you @jerry_nguyen! I'm not familiar with GraphQL, but will try to learn. I don't think there we would have many rubrics overall, so the "used for grading" may not be that crucial. Would it be simpler (or possible) to loop through the courses on the GET /v1/courses/{course_id}/rubrics API endpoint for the information?

[jerry_nguyen · Accepted solution]

@racheleve_davis 

With GraphQL you can select which field you want to get. 

Yes, you can run a loop through all courses, either with API endpoint or GraphQL. You can write a simple VBA (Visual Basic) in Excel to display the data.