Getting student info and updating student eligibilty status

[Cecilia Alcantara-Bedford]

Greetings,

Our software processes income surveys and meal applications for school districts and has the ability to evaluate meal status eligibility per student. Currently, our mutual customers integrate Aeries with our software by extracting the student information we need from the Aeries database and, if desired, use the Aeries NSLP Import Utility to import a CSV export from our system. We would like to simplify this process by utilizing the Aeries API, but would like some guidance in narrowing down what sections of the documentation would be relevant for this workflow.

Can the API be used to GET the following student info?

• Student Number
• Student Last Name
• Student First Name
• Student Birth Date
• Student Grade
• Student DC status
• Student DCR (or Medicaid Reduced) Status
• Household ID - unique identifier for that student's household
  
• School ID - identifier for the school site where the student is enrolled
• Student's current Meal Status
• Verification Status
• Guardian Street Address
• Guardian City
• Guardian State
• Guardian Zip Code
• Guardian Email Address
• Guardian Phone Number

I've noticed the Student-Related API End Points appears to require a School Code. If the customer were to provide our software with their desired school sites, could we then use the API to query for the data above for all students at those specified school sites?

Can the API be used to UPDATE the NSLP Code, Start Date, and End Date values for a student?

Thank you in advance for your support.

[Jesse Geron]

I believe if you're trying to get all of the students from a school site, you will need a school code. If you have the ID of a particular student, I don't believe the school code is required. You can pull all schools via the API and match on the name to get the code or have your schools provide the code or name as they're listed in Aeries.

I'm pretty certain the starte/end dates for students are exposed. Look for SchoolEnterDate andSchoolLeaveDate in the API docs here: https://support.aeries.com/support/solutions/articles/14000113683-aeries-api-student-related-end-points#Student-Information-Extended-%E2%86%91

If you search that page for NSLP you'll see a couple of endpoints for that as well.

[Cecilia Bedford]

Thanks, Jesse! I think I'm starting to piece together what we need from the API based on the existing SQL queries our customers currently use for retrieving the student data. It's looking like our development team will need to be able to allow our users to include/exclude school ID codes obtained from the Aeries API as well as indicate which codes from FRE.SRC would indicate a student is Directly Certified Free or Reduced (Medicaid Reduced). My experience with our customers so far is that the codes that can exist in FRE.SRC are not universal, so I'm trying to see if Aeries API can return a list of all the FRE.SRC values for that district rather than the value for a given student.

---

From: 'Jesse Geron' via Interfacing With Aeries <interfacing...@googlegroups.com>
Sent: Friday, May 19, 2023 10:42:13 AM
To: Interfacing With Aeries
Subject: [interfacing-with-aeries] Re: Getting student info and updating student eligibilty status

 

This is a staff email account managed by Shasta Union High School District. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender.

--
You received this message because you are subscribed to a topic in the Google Groups "Interfacing With Aeries" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/interfacing-with-aeries/C2Zz5mgQBTY/unsubscribe.
To unsubscribe from this group and all its topics, send an email to interfacing-with-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/interfacing-with-aeries/a3b021b1-9203-48ce-8644-f1489e6d7c03n%40googlegroups.com.