API To Transfer Graded Assignments to CRM

[rayvonwill]

Hello community:

For starters, I'm not a developer, but have a general understanding. 

For context, we are a for-profit trade school. As a SIS, we are using a CRM called Method.Me. Method uses REST API

What we are trying to accomplish is to pull grades for specific graded assignments from Canvas to each student's profile in Method CRM via API. A student's profile in Canvas can be matched with a profile in Method CRM by using their e-mail address. 

For example: 

We have 10 total graded assignments in a course, but we only want to pull grades (or scores) from Test 1, Test 2, Test 3, Test 4, and Final Exam to appear in the student's profile in Method CRM. 

Is this possible with the Canvas API?

[dbrace]

Hi @rayvonwill,

I am not a developer but I would recommend that you start by looking at the Users API for "Get a users most recently graded submissions" from https://documentation.instructure.com/doc/api/users.html.

I do not think so but you might also be able to (or need to) use:

1. "List assignments" from the Assignments API at https://documentation.instructure.com/doc/api/assignments.html
2. "List assignments for user" from the Assignments API at https://documentation.instructure.com/doc/api/assignments.html
3. some of the grading related items from the Submissions API at https://documentation.instructure.com/doc/api/submissions.html

I hope this helps you get things moving along.

-Doug

[rayvonwill]

Thanks, Doug. This was helpful. 

[ClarkDow]

I ended up using the Canvas API to pull assignment data, then pushed it into https://acupowererp.com/acumatica/customer-management using a custom script. I just triggered the export after grades were finalized. Using grade passback endpoints made it easier to keep everything synced. The trickiest part was mapping the Canvas user info to CRM records, so I relied on SIS IDs to match everything up.