How can I (IT Tech assisting CANVAS Admin) pull students grades in real-time via CANVAS, 3rd-party integration, and/or CANVAS API

[CoachChan]

Hello Everyone,

I am looking for a way within CANVAS internal reports, CANVAS API, and/or a 3rd party integration that can pull a specific list of student grades in real-time? My thought process would be to search for students by a unique identifier then pull their current course grade for each course they are currently enrolled in. 

Anyone have any ideas to best approach this? We would like to keep the solution to as cheap/free if possible since this is a small project.

Thanks for your Time!

[agschmid]

If you have the proper permissions, try the sections API: https://canvas.instructure.com/doc/api/sections.html

/api/v1/sections/sis_section_id:<sis_id>/enrollments?per_page=100
/api/v1/sections/<section_id>/enrollments?per_page=100

This returns:

"current_grade":
"current_score":
"final_grade":
"final_score":
"unposted_current_score":
"unposted_current_grade":
"unposted_final_score":
"unposted_final_grade":

Not sure if there is a way to do it per student and enrollments, possibly https://canvas.instructure.com/doc/api/enrollments.html#method.enrollments_api.index, looking at the parameters available with that call.