Skip to content

Category: PowerSchool

PowerSchool Student Class List SQL

Replace %param1% will be the Student ID

Replace %param2% will be Year ID

PowerSchool Student Immunization Non-Compliance SQL

 

PowerSchool – Getting Parents Username and Email from Access Accounts

With the above code, I have limited the result to only mother and father.

To add more into the result here is the list of relationship type ID in powerschool, you will need to edit line number 39 and add more relationship type ID’s.

 

Getting PowerSchool Access Token

PHP code to get PowerSchool access token:

jQuery code to get PowerSchool access token:

Client ID and Client Secret is available under “Data Provider Configuration” inside the plugin settings.