School data sync required attributes for powerschool sync

Instead of using CSV (comma separated value) files to synchronize School Information System (SIS) data with Microsoft 365, you can use School Data Sync to connect directly to your PowerSchool SIS. With this sync method, you use the REST-based API Endpoints provided byPowerSchool to sync data directly from your SIS to Microsoft 365.

When you're creating a sync profile using the PowerSchool sync method, you must have the required attributes listed below, fully populated in the PowerSchool SIS. Any object that does not contain the required attributes will fail to sync and generate an error within the SDS portal. You can add optional attributes as well.

This topic lists the required attributes. Learn more about How to deploy School Data Sync by using PowerSchool SIS API.

School attributes

Attributes associated with the School in the PowerSchool SIS.

• SIS ID   – SIS ID of the School. This value must be unique.

• Name   – Name of the School.

• Principal First Name   – First name of the School's Principal.

• Principal Middle Name   – Middle name of the School's Principal.

• Principal Last Name   – Last name of the School's Principal.

Section attributes

Attributes associated with the Section in the PowerSchool SIS.

• SIS ID   – SIS ID of the Section. This value must be unique.

• School SIS ID   – SIS ID of the School.

• Section Number   – Number of the Section.

• Course SIS ID   – SIS ID of the Course.

• Course Name   – Name of the Course.

Teacher attributes

Attributes associated with the Teacher in the PowerSchool SIS.

• SIS ID   – SIS ID of the Teacher. This value must be unique.

• School SIS ID   – SIS ID of the School.

• First Name   – Not available for use if either synced identity option is selected in the profile creation.

• Last Name    – Not available for use if either synced identity option is selected in the profile creation.

• Username   – Username of the teacher in the PowerSchool SIS. This attribute can be used in the identity matching configuration within the sync profile. This value may also be used if creating new users via SDS.

• Password   – Not Available for use if either synced identity option is selected in the profile creation.

• Status   – Status of the Teacher. Active or Inactive.

Student attributes

Attributes associated with the Student in the PowerSchool SIS.

• SIS ID   – SIS ID of the Student. This value must be unique.

• School SIS ID   – SIS ID of the School.

• First Name   – Not available for use if either synced identity option is selected in the profile creation.

• Last Name    – Not available for use if either synced identity option is selected in the profile creation.

• Username   –  Username of the student in the PowerSchool SIS. This attribute can be used in the identity matching configuration within the sync profile. This value may also be used if creating new users via SDS. 

• Password   – Not Available for use if either synced identity option is selected in the profile creation.

• Status   – Status of the Student. Active or Inactive.

TeacherRoster attributes

Attributes used for Teacher to Section mappings.

• Section SIS ID   – SIS ID of the Section.

• SIS ID   – SIS ID of the Teacher.

Student Enrollment attributes

Attributes used for Student to Section mappings.

• Section SIS ID   – SIS ID of the Section.

• SIS ID   – SIS ID of the Student.

Related Topics

Overview of School Data Sync
How to deploy School Data Sync by using PowerSchool SIS API