Education Record Post Error - How to Bulk add Schools to list

When I try to make a POST request to the education endpoint with the name of a school ('Bradley'), I get this response:


The table 'Schools' does not contain an active entry named 'Bradley'


My question is how do I add Schools to my Schools list? Edit: How do I add many schools to the list? I need to add over 1000.

Comments

  • Hi Samantha,


    You can manage the Schools code table in database view under the Configuration -> Tables area:

  • Is there a way to bulk add to this list? Or is there an API endpoint to add to that list? I have over 1000 Schools to add, and I only see the option to add them one by one right now.
  • Hi Samantha,


    Actually, there is a newer beta API that provides the ability to manage code tables. Currently, this API is in a limited availability to select ISV partners and developers but I've added you to the beta list so your API key will work with this API as well as the existing APIs. We haven't added it to the navigation yet, so here's a direct link to the endpoint reference for the API:
    https://developer.sky.blackbaud.com/docs/services/nxt-data-integration


    The endpoint you can use to add entries to the School code table is:
    https://developer.sky.blackbaud.com/docs/services/nxt-data-integration/operations/AddTableEntry


    You can use this endpoint to get the list of code tables (to get the required path parameter for the AddTableEntry endpoint):
    https://developer.sky.blackbaud.com/docs/services/nxt-data-integration/operations/GetCodeTables


    One nuance about the way this API works is that it requires the consenting user to be an "Environment administrator". In other words, the end-user who provides consent through the OAuth process will need to be an environment administrator in order to use this API.


    I hope this helps - please let us know if you have any questions or issues using this API.

    Thanks!
  • Wow that is exciting! I am a full access admin within our system, but I am getting a 403 error with the GetCodeTables endpoint. Could you explain maybe further what an environment administrator is? Or any suggestions why I would get a 403? Thanks again
  • Hi Samantha,


    You are currently listed as a Organization-level administrator, which is not the same as an Environment-level administrator (which I understand is awkward because of the hierarchy). Unfortunately, at the moment there is no way an Org admin can self-service make themselves an environment administrator. I'll shift this to email so I can provide some more details to you.
  • Thank you for all your help! This worked!

Categories