We do most of our reporting out of our SIS (Ellucian Colleague) using a tool from Entrinsik called Informer. However, we don't identify students who need help until after final grades have been posted to the SIS. In an effort to identify students who aren't turning in assignments or who aren't on track to pass a course before the course has ended, I've connected Informer to D2L Brightspace using the API capabilities.
Informer allows me to pull "datasets" from multiple sources and then compile them into comprehensive reports. My goal is to combine assignment/grade data from Brightspace with demographic data from Colleague to identify cohorts, such as athletes or "chemistry majors" who are struggling.
I want to pull all grades into a dataset with the student and course identifiers associated with each grade. However, it seems that Brightspace only wants me to pull grades for individual courses (the org unit ID is part of the API url). Is there some way to pull all grades for a given term (or terms) with the corresponding course and student identifiers so that I can link everything back together on the Informer side?
This has been my primary resource:
https://docs.valence.desire2learn.com/http-scopestable.html#cap-grades
