📌
MBPY: Schools Technology
  • About this Resource
  • Installation
    • Requirements
    • Getting Started Local Install
    • Getting Started using Docker
    • Further instructions with Docker
    • Updating with Docker
  • Tutorials
    • Configuration
    • Importing
    • Extracting
    • Streaming
    • Pipelines
    • Scripting
    • Big Query
  • Querying & Tranformations
    • Querying Commands
    • Querying the Database
    • Querying via Script
    • Querying via an SQLite Client
  • Scripts
    • Daily Homeroom Attendance Report
  • Pipelines
    • Dataframes with pandas
    • Pipelines
    • Example Pipelines
      • Bulk Change Email domain
      • Enrollment by Gender
  • Plugins
    • mbpy_powerschool_plugin
      • PowerSchool Plugin
        • API reference
      • mbpy Plugin
        • mbpy plugin source code
    • Plugins Overview
    • mbpy_plugin_example
    • mbpy_plugin_destiny
    • mbpy_plugin_attendance_reports
Powered by GitBook
On this page
  • Get Students
  • Get Teachers
  • Get Parents
  • Get Student Enrollments in Classes

Was this helpful?

Export as PDF
  1. Plugins
  2. mbpy_powerschool_plugin
  3. PowerSchool Plugin

API reference

Please refer to the below API methods, which contain responses, for examples of the JSON returned by the plugin.

Get Students

GET {baseUrl}/ws/schema/query/mk.ManageBac_Stu

Query Parameters

Name
Type
Description

pagesize

Integer

page

Integer

{
    "records": [
        {
            "tables": {
            "u_student_additionals": {
                "nickname": "string | null",
                "enrollmentdate": "YYYY-MM-DD"
            },
            "students": {
                "dateofbirth": "YYYY-MM-DD",
                "middle_name": "string",
                "gender": "F",  // one character or null
                "first_name": "string",
                "email": "string",
                "yeargroup": "string",
                "grade_program": "string",
                "student_number": "string",  // "123456"
                "last_name": "string",
                "grade": "string"
            },
            "u_country_codes": {
                "nat": "AB"
            }
            }
        }
    ],
    "extensions": ""
}

Get Teachers

GET {baseUrl}/ws/schema/query/mk.ManageBac_Tea

Query Parameters

Name
Type
Description

pagesize

Integer

page

Integer

{
    "records": [
        {
            "tables": {
                "teachers": {
                    "middle_name": "string or null",
                    "id": "string",
                    "first_name": "string",
                    "last_name": "string"
                }
            }
        }
    ],
    "extensions": ""
}

Get Parents

GET {baseUrl}/ws/schema/query/mk.ManageBac_Par

Query Parameters

Name
Type
Description

pagesize

Integer

page

Integer

{
    "records": [
        {
            "tables": {
                "u_student_additionals": {
                    "father_private_email": "string",
                    "mother_school_email": "string",
                    "father_school_email": "string",
                    "mother_private_email": "string"
                },
                "students": {
                    "student_web_id": "string",
                    "first_name": "string",
                    "mother_first_name": "string",
                    "mother_last_name": "string",
                    "grade_level": "string", // -2, 1, 0, 1, 2, 3
                    "student_number": "12345",
                    "father_first_name": "string",
                    "father_last_name": "string",
                    "last_name": "string"
                }
            }
        }
    ],
    "extensions": ""
}

Get Student Enrollments in Classes

GET {baseUrl}/ws/schema/query/mk.ManageBac_Stu_Class

Query Parameters

Name
Type
Description

pagesize

Integer

page

Integer

{
    "record": [
        {
            "tables": {
                "students": {
                    "student_number": "123456"
                },
                "sections": {
                    "class_id": "string, including exp",
                    "section_number": "1"
                }
            }
        }
    ]
}
PreviousPowerSchool PluginNextmbpy Plugin

Last updated 2 years ago

Was this helpful?