Retrieving new students via endpoint

Fryeburg Academy Portal

Hey folks -

I'm trying to pull new students in the same way I can using SKY lists using the “New/Returning” field, but I'm not sure where this data is stored. I tried using an advanced list but can't pass the enrollment date via the List api. Does anyone know a way to programmatically find new students regardless of grade or enrollment date? Or is the “New/Returning” option in the new lists a calculation of enrollment date against something else?

Thanks for any guidance!

Brian Gray

@Fryeburg Academy Portal - I believe that the “New/Returning” value in the SKY list is calculated (probably based on a lack of enrollment records prior to the current school year).

I need to identify new students in Advanced Lists, so I look at the Enroll Date. In some lists I just include the field in the output. In others (as shown below) I use it as a filter. This works for us because we don't enroll new students very late into the academic year, and because we assign an enroll date of August 1 for all incoming students.

Stephen Boyle

@Brian Gray and @Fryeburg Academy Portal

You can get new students from the Users changed by role(s) endpoint. It returns the current state of all records changed or added after a supplied date parameter. The response includes a created_date property, so you can determine if it is new or just modified.

Brian Gray

@Stephen Boyle - thanks for pointing out this endpoint. In my case, the Advanced List works better (because the data is transferred to a shared spreadsheet), but I will keep this in mind for when I need it.