Pulling school data to our server using a script or program

Elaine Mouton
Elaine Mouton
Tenth Anniversary Name Dropper Participant Facilitator 1
in Blackbaud K–12 Education Solutions™ General Discussions
We have been using the ON API to pull data using legacy lists from within php programs. We are now trying to move to the Sky API and have successfully set up authentication. We have been able to view one of our legacy lists using the Get “Legacy list” on the API Reference/School/Endpoint webpage. (https://api.sky.blackbaud.com/school/v1/legacy/lists/{list_id})

Instead of pulling data from within a program, we want to extract data from the Sky endpoint (School – Legacy list) to our internal server’s sql database using a script or program. Any help in steering us in a good direction would be most appreciated.

Tagged:

Comments

  • Dennis Ladnier
    Dennis Ladnier
    Eighth Anniversary Kudos 1 Name Dropper Participant
    Elaine, we use the Ski API and other methods to ingest into a local sql server nearly 24x7 - while your message does not have a lot of detail I assume your internally developed program to interact with the Ski API actually retrieves data. Assuming that you should then have a fairly simple task of taking each data frame through a cleansing process then performing a SQL call (i.e. nothing more than executing an sql insert or something) to your local database. All of the basic languages (C#, Python, VB, etc) have a sql 'interface'. Just make sure your sql authentication method (trusted other sql login/password) has the appropriate permissions to the sql database/table/field. Dennis

Categories