Automatic Exports

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??

Comments

  • Brian Gray
    Brian Gray Community All-Star
    Eighth Anniversary Kudos 5 K-12 Fall 2025 Product Update Briefing Badge Name Dropper

    @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.

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

  • Nick Marchese
    Nick Marchese Community All-Star
    Seventh Anniversary Kudos 1 Name Dropper Participant

    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.

  • @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

  • Hi All,

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