SFTP exports?

Matthew Robinson

Does Blackbaud/SKY API have an automated way to schedule the export of CSV files containing student, teacher, and class data and then send those files to a provided SFTP box?

If yes, does Blackbaud/SKY API export these files in a predefined format, such as OneRoster, or do you require a script to define that file format?

Thanks!

Michael Panagos

I don't believe so. I do this with PowerShell (pull down the data or list using the API and upload it using WinSCP which can integrate with the script). You can probably do something similar with Power Automate.

I also think that Blackbaud is doing something to implement OAuth 2.0 for OneRoster later this year.

Bryna Gleich

It's not automated, but it is predefined for OneRoster exports as a zipped CSV file

Melissa Handy

@Matthew Robinson Did you figure out a way to handle this because I have the same issue. I want to automate an export so my 3rd party app (ParentSquare) can pick it up from STFP folder.

Melissa Handy

@Michael Panagos I'd love some advice on how to use PowerSchell to pull down data from BB. I'm trying to pull data to an SFTP folder for 3rd party app ParentSquare.

Michael Panagos

@Melissa Handy
Hi Melissa. The Wiki for the PowerShell module I created to pull data from Blackbaud SIS should answer many of your questions > https://github.com/Sekers/SKYAPI/wiki

For uploading to SFTP there are probably a few options but I use WinSCP which integrates with PowerShell > https://winscp.net/eng/docs/library_powershell

Hope those help!

Michael Panagos

@Matthew Robinson
For anyone interested, it looks like an automated SFTP upload for OneRoster was released in July, 2023. >