Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
Microsoft School Data Sync V2
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 |
|---|---|---|
| Copilot Studio | 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) |
| Logic Apps | Standard | All Logic Apps regions except the following: - Azure Government regions - Azure China regions - 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) |
| 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) |
| Contact | |
|---|---|
| Name | School Data Sync Support |
| URL | https://aka.ms/sdssupport |
| eishelp@microsoft.com |
| 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 GetUploadSession |
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 DataConnector list |
Get the DataConnector list. |
| Get Delegated Token |
Get the Delegated Token to communicate with School Data Sync. |
| Get InboundFlow |
Gets the inbound flow by id found in the School Data Sync configuration |
Call GetUploadSession
- Operation ID:
- CallGetuploadsession
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
- Operation ID:
- CallValidate
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
- Operation ID:
- CheckValidationResult
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
- Operation ID:
- GetDataconnectorList
Get the DataConnector list.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
The access token.
|
access-token | True | string |
The access token. |
Returns
Get Delegated Token
- Operation ID:
- GetDelegatedToken
Get the Delegated Token to communicate with School Data Sync.
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
token_type
|
token_type | string |
token_type |
Get InboundFlow
- Operation ID:
- GetInboundFlow
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. |