Using Canvas API to import grade columns and grades

[shijo_john]

Using Canvas REST APIs how do I get a list of grading columns OR all gradable entities in a given course?

Also which API do I use to get a list grades for a given course?

[stuart_ryan · Accepted solution]

Hi  @shijo_john ,

I have had a look around the community and found a few resources that should get you started:

• Gradebook API (previous discussion thread)
• Submissions - Canvas LMS REST API Documentation (official API documentation for the Submissions endpoint, referenced in the first thread)
• Gradebook Canvas API  (additional discussion thread with some basic information).

That should get you started with your first question. With regards to listing grades for a course (i.e. total grade), you would need to use the Enrolments API which is documented Enrollments - Canvas LMS REST API Documentation  (the total grade is calculated and returned against the enrolment in a particular course.

Hope that helps!

Stuart

[PepeGimenez]

Hi,

I am very interested in this but when I click on the links I get the following message:

• You do not have sufficient privileges for this resource or its parent to perform this action.

  Click your browser's Back button to continue.

Can anyone tell me what I need to do to get those privileges?

[Chris_Hofer]

Hi there, @PepeGimenez ...

Stuart is no longer in the Canvas Community, but I saw your question about the links.  Full disclosure... I don't have much experience with APIs in Canvas.  I needed to reach out to someone at Instruture to see if he might be able to help with those links you are asking about within Stuart's response.

• For Stuart's link in his first bulleted item, "Gradebook API", it sounds like that link is now in an area called "Cold Storage".  But, my contact at Instructure was able to determine that the most helpful link in that thread was to the following: Gradebook Analysis - Error Checking The Gradebook - Instructure Community (canvaslms.com)
• For Stuart's link in his third bulleted item, "Gradebook Canvas API", that is also a closed thread in "Cold Storage".  but here was the text of that thread:
  • There is not a ‘gradebook’ API, per se. Rather the gradebook is a combination of results from the enrollment API and the submission API. Which one you will query will depend on what information you’re looking for.  The Enrollments API will return course-level calculated (and raw) grade information for each user, whereas the Submission API will return scores for the specified assignment.

I'm not sure if any of this will be of help to you, but please let Community members know if you have any other questions about this...thanks!