Automatic Exports

Geoffrey Goodfellow

Is anyone aware of possible solutions to allow a particular K12 list or advanced list to be exported/emailed automatically at a defined time to produce a. CSV of attendance and conduct data? I see that functionality of our dashboards and even of OneRoster but not with any of the lists or advanced lists. Anything creative that people of come up with to accomplish this? PowerAutomate?? SKYAPI?? Others??

Brian Gray

@Geoffrey Goodfellow - @Nick Marchese at the Emma Willard School has a Google Sheets extension that will automate the extraction of data from Advanced Lists to Google Sheets.

That may be a step in the right direction for you.

Geoffrey Goodfellow

@Brian Gray, that sounds like a wonderful lead! Thank you for the connection.

Nick Marchese

Thanks for the tag, @Brian Gray. Yes, @Geoffrey Goodfellow, I have a Google Sheets extension that pulls Advanced Lists into sheets and then have also configured this on our end with additional scripting to push to other systems. Shoot me an email (nmarchese@emmawillard.org) and we can talk.

John Bozek

@Geoffrey Goodfellow I have been working on something like this for quite a while. what you're asking can be done with the “School API Endpoint” under your list inside of your Blackbaud solution you can find the list id #. The most complicated part and the part I have been stuck on for quite a while is being able to authenticate to the API endpoint programmatically. Google is another method I am exploring as there seems to be some tools in managing and connecting to API endpoints but I have not dug that deep into it.

to send out my school attendance e-mail every morning I still unfortunately have to download the source lists manually but then everything else is easily automated with Python or power automate. Were I able to authenticate programmatically I would be able to use the school API endpoint to access the data I need.

k-12 Endpoints:

Education Management - SKY API

Byron Avila

Hi All,

I am curious if anyone has made progress since the last comment. Any documentation or resources will be much appreciated!