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.
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.
0
Comments
-
Hi Samantha,
You can manage the Schools code table in database view under the Configuration -> Tables area:
0 -
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.0
-
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!0 -
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 again0
-
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.0 -
Thank you for all your help! This worked!2
Categories
- All Categories
- 6 Blackbaud Community Help
- 213 bbcon®
- 1.4K Blackbaud Altru®
- 401 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 15 donorCentrics®
- 360 Blackbaud eTapestry®
- 2.6K Blackbaud Financial Edge NXT®
- 655 Blackbaud Grantmaking™
- 576 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 939 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.6K Blackbaud Raiser's Edge NXT®
- 3.7K SKY Developer
- 248 ResearchPoint™
- 119 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 241 Member Lounge (Just for Fun)
- 34 Blackbaud Community Challenges
- 34 PowerUp Challenges
- 3 (Open) PowerUp Challenge: Chat for Blackbaud AI
- 3 (Closed) PowerUp Challenge: Data Health
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Product Update Briefing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports+
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Email Marketing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Gift Management
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Event Management
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Home Page
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Query
- 791 Community News
- 2.9K Jobs Board
- 53 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)
