Power Automate and School API

@Edwin Blackwood Hi! We haven't published an official, certified Power Platform connector for Blackbaud Education Management. But a few things to note:

1. We are currently in-flight releasing a new action in the Blackbaud SKY Add-ins connector named “Send an HTTP request”. We expect this to be released by mid-December (the release is controlled by Microsoft), and once released this action can be used to call ANY of the SKY APIs, including the School API. So, you could use this connector action to implement the automation you have in mind, and you'd be able to leverage the connector's native support OAuth (so you wouldn't be burdened with any OAuth implementation complexity). This would be an “easy button” way to begin working with School API functionality within Power Platform (but the user-experience would be slightly less friendly since the action is itself more of a developer-facing action dealing with HTTP request semantics). But it'd be an easy way to get started to see what's possible.
2. A Power Platform connector is (essentially) just an OpenAPI document, so you could create a “custom connector”, starting with the OpenAPI emitted for the School API in the SKY Developer platform. You could copy the basic implementation from any of our certified connectors which you can find in Microsoft's Power Platform Connectors repo in GitHub, and then paste in the desired OpenAPI operations from the School API into the custom connector definition. You'd need to associate your custom connector with a SKY Application (for OAuth purposes) and provide your API subscription key in the connector policy. This is a more advanced implementation than using the Add-ins connector, but it would give you more control over the end-user experience in Power Automate since you'd be defining 1st-class actions with friendly text.
3. We're working on certifying additional Power Platform connectors for other Blackbaud products (Blackbaud CRM, Altru, Financial Edge NXT). We don't have an immediate timeline for a certified connector for Blackbaud Education Management, but it's certainly an area of interest for us. Any details you could share about the scenarios you'd envision automating would be really useful and valuable to us to help build the case for the (small) effort needed to publish a connector. Feel free to send me any details/thoughts/ideas you have directly and I'd be happy to reply with any advice/thoughts/guidance if I can.
   

@Ben Lambert We're using power automate to send an email weekly of new enrollments to and new withdrawals from the school to internal users. Running it the way we are, there is no way to have it not send the email if there are not any enrollments or withdrawals; it just goes out blank. Is this something that a connector could help with?