Anyone figured out how to automate the Roll Call Attendance Report?

[SpencerKiper]

Hey all,

We’re in the process of integrating Canvas data into our new SIS (RIO Education) and running into a snag with attendance — specifically the data that comes from the Roll Call (LTI) tool.

We’re trying to move beyond just the aggregate attendance percentage (like “88% present”) and really need the raw details — who was marked Present, Late, Absent, and whether attendance was taken at all for a given day in each course.

Right now, I can pull that info from the root-level Attendance Report in the admin panel, but as far as I can tell, that report isn’t accessible via the API. And since Roll Call is an external LTI app, it doesn’t seem to be tied into the standard REST endpoints either.

Here’s what I’m trying to figure out:
• Has anyone found a way to automate that root-level attendance report?
• Or better yet, is there a workaround for pulling session-level attendance status data directly from Roll Call?
• Even a way to schedule regular CSV exports would be helpful at this point.

If you’ve tackled anything like this — or know if Instructure has something in the pipeline — I’d love to hear about it. Our Candidate Affairs and Ops teams would seriously thank you.

Appreciate any tips,
Spencer Kiper
Senior Systems Technologist, Reach University

[dbrace]

Hi @SpencerKiper.

While not exactly what you are looking for (because the functionality does not exist), I would recommend checking out the question, solution, and comments at Attendance Report Using API - Instructure Community - 640764 initially from (yes...) 2016.

Something that I figured out by poking around is the link for the administrative access to Attendance at the (sub)account level.  The link is: https://rollcall.instructure.com/reports/new?account_id=####  (replacing the #### with the Canvas ID number for the account). 

As mentioned in the comments by @James, you could use a "headless" browser and email programming/scripting  to download the file.

-Doug