Getting My Feet wet and importing Student id's

Bethany Van Etten · September 2023

So our organization (college) has already started using the enrollment management system. However it doesn't assign a student id during the application process. So I have to manually go through and import student id's for anyone who has completed an application. Since we require this for making a deposit payment I was trying to figure out how to automate this. I have a report that runs and emails to me every morning. I want to take Host ID and pop it into Student ID for consistency since it doesn't seem like student id is automated in ANY way.

I've started looking at sky api but I came from a web development background where I had full control. Can anyone point me in the direction to start setting up some kind of scheduled update/PATCH for just student id? Thanks!

Stephen Boyle · September 2023

@Bethany Van Etten
In SKY API, the Student ID is returned by Users extended by role(s). And it can be updated by User update. So, you can get all students, check for missing Student ID, then update the student if necessary.

Bethany Van Etten · September 2023

@Stephen Boyle
That's wonderful, but how do I go about actually doing that?

Stephen Boyle · September 2023

@Bethany Van Etten
Here is the Getting Started documentation for setting up a developer account, etc.

Bethany Van Etten · September 2023

@Stephen Boyle
Okay, I have a Sky api developer account and looked through the tutorial. But how do I use the example code shown? It just sort of ran through authorization, but not actually doing anything with it after. I understand the code itself but where do I actually start building anything?

Stephen Boyle · September 2023

@Bethany Van Etten
Now this is where the API community can help. I don't know enough detail to help especially with the myriad tools out there. But there are some very knowledgeable folks in the boards here. I hope they can pick up the thread and get you further.

Michael Panagos · September 2023

@Bethany Van Etten
I wrote a PowerShell module for the SKY API that can be used to easily schedule this if you don't want to spend too much time on it. Not all the endpoints are in there yet (been wanting to add them in but it's been a busy summer), but the ones you want are. The WiKi has directions on setting it up.

You can also use something like Microsoft Power Automate to do it (but it will cost you a license to use the Blackbaud connectors - but it's very reasonable)

Bethany Van Etten · October 2023

@Michael Panagos
Oh thank you! It took us a bit to figure out since we weren't really familiar with powershell but once we got going this module was awesome! Thank you so so so much! And the commenting in it is PERFECT!

Michael Panagos · October 2023

@Bethany Van Etten
Glad it helped!

Getting My Feet wet and importing Student id's

Comments

Categories