Microsoft School Data Sync V2 (Preview)
Automate the process of synchronizing user and roster data from Student Information or Management Systems with Microsoft 365 for Education. School Data Sync helps you manage your educational organization, users, classes and roles for Microsoft Teams, Intune, Exchange Online, SharePoint Online, OneNote Class Notebooks, and Learning Accelerators.
Use with the new School Data Sync experience only. Not for use with SDS (Classic).
This connector is available in the following products and regions:
| Service | Class | Regions |
|---|---|---|
| Logic Apps | Standard | All Logic Apps regions except the following: - Azure Government regions - Azure China regions - US Department of Defense (DoD) |
| Power Automate | Standard | All Power Automate regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Power Apps | Standard | All Power Apps regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Contact | |
|---|---|
| Name | School Data Sync Support |
| URL | https://aka.ms/sdssupport |
| [email protected] |
| Connector Metadata | |
|---|---|
| Publisher | Microsoft |
| Website | https://sds.microsoft.com/ |
| Privacy policy | https://privacy.microsoft.com/en-us/privacystatement |
| Categories | Data |
Microsoft School Data Sync CSV Upload
Simplify class management in Office 365. School Data Sync reads rosters from your SIS and creates classes and groups for Microsoft Teams, Intune for Education, and third party applications.
Connect to the new School Data Sync experience only to upload school and roster information. Not for use with SDS (Classic).
Prerequisites
Create an app in the tenant's Azure Active Directory with Edu permissions for rostering.
How to get credentials
Create an app in the tenant's Azure Active Directory and generate a secrect.
Get started with your connector
This connector is used by the Automate School Data Sync CSV Upload PowerAutomate template. See above sections on the connector setup.
Known Issues and Limitations
Common errors and remedies
FAQ
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
Actions
|
Call Get |
Get the session for the CSV file upload. |
| Call Validate |
Call the operation to validate the uploaded CSV files. |
| Check validation result |
Check to see if the validation result of the uploaded CSV files returned errors. |
|
Get Data |
Get the DataConnector list. |
| Get Delegated Token |
Get the Delegated Token to communicate with School Data Sync. |
|
Get Inbound |
Gets the inbound flow by id found in the School Data Sync configuration |
Call GetUploadSession
Get the session for the CSV file upload.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
The created data connector id.
|
createdDataConnectorId | True | string |
The created data connector id. |
|
The access token.
|
access-token | True | string |
The access token. |
Returns
Call Validate
Call the operation to validate the uploaded CSV files.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
The created data connector id.
|
createdDataConnectorId | True | string |
The created data connector id. |
|
The access token.
|
access-token | True | string |
The access token. |
Returns
Check validation result
Check to see if the validation result of the uploaded CSV files returned errors.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
The uri of the validation operation.
|
ValidationOperationUri | True | string |
The uri of the validation operation. |
|
The access token.
|
access-token | True | string |
The access token. |
Returns
Get DataConnector list
Get the DataConnector list.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
The access token.
|
access-token | True | string |
The access token. |
Returns
Get Delegated Token
Get the Delegated Token to communicate with School Data Sync.
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
token_type
|
token_type | string |
token_type |
Get InboundFlow
Gets the inbound flow by id found in the School Data Sync configuration
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
The inbound flow by id found in the School Data Sync configuration
|
inboundFlowId | True | string |
The inbound flow by id found in the School Data Sync configuration |
|
The access token.
|
access-token | string |
The access token. |