Ability to add Education Subjects through the API

ESO Team

Hello,

I've been using the Raiser's Edge Constituent API with the goal of being able to create a brand new constituent (this is done), and creating a new education (here's the trouble). As I was working through it, I haven't found a way to add a new subject, because of this error:

The 'Major/Minor' and 'Subject of Study (For the UK only)' tables do not contain an active entry named 'My Amazing Test Subject'.

And that call was made POSTing to constituent/v1/educations. If I use an existing subject, I have no doubt the call would succeed.

I can get the list of subjects through constituent/v1/educations/subjects, but there doesn't seem to be a way to POST, only GET. I've been browsing through all the endpoints, and nothing is really standing out. What should I be looking for?

Alex Wong

@ESO Team
Subjects is table entries in the Major/Minor table. To add to this code table, you need to use the code table endpoint to add table entry.

https://developer.sky.blackbaud.com/api#api=nxt-data-integration&operation=CreateTableEntry

which you need to know the code table id for Major/Minor, go to RE NXT > Settings > Table and select the Major/Minor table and look at the URL for the code table id.

In my case, code table id is 5079, since this is a default code table, not user created code table, yours is likely the same 5079, but verify first.

ESO Team

Thank you very much @Alex Wong! Confirmed 5079 for us as well. This is exactly what I needed. I got a bit too tunnel visioned focusing on the Constituent endpoints so much I forgot to consider the others.

Again, thank you!