AnsweredAssumed Answered

API to get all Grade Column Scores per ID

Question asked by John Ligda on Aug 29, 2018
Latest reply on Aug 30, 2018 by Peter Love

Like • Show 0 Likes0
Comment • 3

I'm new to API programming this year but have built out a few using SQL Server/SSIS and and extension called Zappysys. I develop in POSTMAN and transfer to the SSIS task. It's fun.

I'm trying to get all scores per course.

In POSTMAN I'm getting

a list of courses

a list of assignments per course

Are all columns in the 'grades' considered 'assignments'. I don't see the calculated columns. What I need is every column, weather calculated or an assignment, pivoted per student. And, of course, the entered score.

I'm not sure where to go in the API for this? Any help?

At the very least I need the ID and each column in the grades, listed as ScoreName and the ScoreValue.

No one else has this question

Outcomes

Kona Jones

Aug 29, 2018 8:13 PM

John, greetings! Due to the technical nature of this question I'm sharing it with the Canvas Developers group in the Community to see if they can help. They are the programmers and the ones who do this type of work on the back-end of Canvas. I'd also recommend joining this group so that way you'll have access to their resources and information.

Hope this helps!

Kona

1 person found this helpful

I've got somewhere to get to so I've got to keep this response short. Actual scores for students are found under the Submissions API. I use the List submissions for multiple assignments endpoint with student_ids[]=all to fetch all students. If that's not completely what you're looking for at least maybe it will help you get there.

2 people found this helpful

Actions

Peter Love Aug 30, 2018 4:57 PM

Hi John,

I know what you want to do and you would think it would be straightforward via a gradebook endpoint. But unfortunately it is not. I think its a missing feature.

As James has said, for columns that relate to scores, you need to use the submissions API. For custom columns you need to use the Custom Gradebook Columns. I haven't come across a simple call to get the Total column yet. I think you can run a report and extract it from there.

Peter

Actions

3 Replies

Kona Jones Aug 29, 2018 8:13 PM
Mark Correct
Correct Answer
John, greetings! Due to the technical nature of this question I'm sharing it with the Canvas Developers group in the Community to see if they can help. They are the programmers and the ones who do this type of work on the back-end of Canvas. I'd also recommend joining this group so that way you'll have access to their resources and information.

Hope this helps!
Kona
1 person found this helpful
Like • Show 0 Likes0
Actions
James Jones Aug 30, 2018 8:41 AM
Mark Correct
Correct Answer
John Ligda,

I've got somewhere to get to so I've got to keep this response short. Actual scores for students are found under the Submissions API. I use the List submissions for multiple assignments endpoint with student_ids[]=all to fetch all students. If that's not completely what you're looking for at least maybe it will help you get there.
2 people found this helpful
Like • Show 0 Likes0
Actions
Peter Love Aug 30, 2018 4:57 PM
Mark Correct
Correct Answer
Hi John,

I know what you want to do and you would think it would be straightforward via a gradebook endpoint. But unfortunately it is not. I think its a missing feature.

As James has said, for columns that relate to scores, you need to use the submissions API. For custom columns you need to use the Custom Gradebook Columns. I haven't come across a simple call to get the Total column yet. I think you can run a report and extract it from there.

Peter
Like • Show 0 Likes0
Actions

API to get all Grade Column Scores per ID

Outcomes

Related Content

Recommended Content