Reporting students who are "PRESENT"?

Brian Gray

In the past, we focused on students who were absent from class.  Now, we need to be able to report who was present in a particular class on a particular day for contact tracing.


I can'f find the right combination to extract the students who were marked present.  Has anyone been able to do this - either through the API or through Advanced lists?

Brian Gray

I've spent a good bit of time chasing through the API, but to no avail.  I don't see any way to extract Present or Virtual attendance status.  


The Attendance List endpoint (https://developer.sky.blackbaud.com/docs/services/school/operations/V1AttendanceGet) tells me who was absent, but we need more information. We need to be able to distinguish between present physically, present virtually, no attendance taken, and class cancelled.  I don't see any way to extract "present" or "virtual" through the API or through Advanced Lists.


The data has to be in the database in some way. It's visible to the student and parent.  (Although even that screen is somewhat misleading...if the class is marked as Canceled, the student's screen shows "Attended").


The API or Advanced List capability that I need is either:

• given a student ID and a date, report the attendance information for every obligation on the student's schedule. For each obligation's group, was the meeting cancelled? Was attendance reported? What is the student's attendance status (present, virtual, absent, tardy).
• given a section ID and a date, list all students on the roster on that date and the attendance status of each student  (canceled, not reported, present, virtual, etc). (This is the information that appears on the "Take attendance" dialog for the teacher.)

Conor Lynch

+1 to the suggested additions/changes.

The Attendance List Endpoint also does not provide “Day Attendance” as shown in the screenshot of this post:

The above data is really what we need to get out in a API format. The current endpoint not only just provides absences, but it also does not provide the values we are entering for the whole day attendance.

We are currently needing to extract attendance for the whole day, rather than per class, as per class does not provide us with whether or not we marked the student wholly present for the day from a billing perspective.

Bryna Gleich

These List Templates for Advanced lists might help:

They were added in the October 27, 2020 release.

Conor Lynch

Hi Bryna,

Thank you so much for your insight! I should have just gone to the advanced list tables first to see what they could offer, so I appreciate you leading me in that direction.

Sadly though, I am still unable to replicate those “Day Attendance Lists” as there doesn't seem to be any data in the “Virtual Attendance” table. If I try just looking at the records from the table, I get no results as shown below:

Yet when I go into our Day Attendance, we have plenty of records with “Attendance Type" as “Virtual” all over, so I am a bit confused if this is an access issue? I have the Attendance Manager and Data Manager roles, as well as the List Admin role, so I don't think it is that.

Are you able to get data out of your Virtual Attendance table?