Mismatch Between Extended User API and Relationship API Response (user_one_role inconsistency)
Hello,
While integrating with Blackbaud Education Management (SKY API), I noticed a mismatch in user_one_role for the same relationship:
- Relationship API →
"user_one_role": "Child" - Extended User API →
"user_one_role": "Parent"
Both responses refer to the same user_one_id and user_two_id.
Relationship API Response
{ "first_name": "Elroy", "last_name": "Tucker", "relationship": 6, "type_id": 1, "user_one_id": 2269115, "user_one_role": "Child", "user_two_id": 2269114, "contact": true, "parental_access": true}
Extended User API Response
{ "first_name": "Elroy", "last_name": "Tucker", "relationship": 6, "type_id": 1, "user_one_id": 2269115, "user_one_role": "Parent", "user_two_id": 2269114, "contact": true, "parental_access": true}
Questions
- Why does the role differ between these APIs?
- Which one should be considered the source of truth?
- Is this role direction-based depending on the endpoint?
Answers
-
I have never run into this inconsistency. Are you seeing this for multiple users?
You should check the relationship data in Core for the users involved. Is there an incorrect relationship defined? Is Elroy Tucker listed as both the child of user 2269115 and the parent of user 2269115?
0 -
.
0 -
Hello,
Thank you for your response.
We are currently working within the SKY Developer Cohort environment and have observed this inconsistency while using the following endpoints:
- https://api.sky.blackbaud.com/school/v1/users/2269115/relationships
- https://api.sky.blackbaud.com/school/v1/users/extended/2269115
For the same user relationship, these two APIs are returning conflicting
user_one_rolevalues.At the moment, we do not have access to the Core system to directly verify the relationship data or confirm how many roles are assigned to the user.
0 -
I don't use the Cohort environment, so I don't have any more info for you. @Stephen Boyle may be able to look into it.
0 -
- This looks like a bug
- the User Extended results are the correct version
- "user_one_id": 2269115
- This is George Tucker the dad,
- "Parent" is the correct user_one_role
- No, I think it's a bug - and b/c everyone uses User Extended for relationships, the bug in the relationship Get was never reported (or that is my guess). I'm reviewing this with Support to decide what to do. Since, it's been out there so long, users may have adapted to how it is now.
0 -
Thank you for your response, Stephen Boyle.
We appreciate you looking into this. Could you please keep us informed once there is confirmation on whether this is a bug or an expected behavior?
This clarification will help us ensure we align our integration logic accordingly.
0 -
I'll go ahead call it that it's a bug. We are still reviewing whether to change the output. We need to check how many users are calling the relationship endpoint. If they are accounting for the current output in there integrations, we don't want to break their code. The other fields, especially "relationship" and "type_id", are correct in both. A relationship code of 6 represents the parent-child relationship.
0 -
Thank you for your response, @Stephen Boyle.
Based on this, we plan to use the extended API to retrieve relationship and student_id data. Once the bug is confirmed and any updates are finalized, please let us know so we can proceed accordingly and ensure alignment with the extended API.
0 -
@Stephen Boyle. Any update on this one?
0
Categories
- All Categories
- 1 Blackbaud Agents for Good™
- Raiser's Edge NXT test
- 6 Blackbaud Community Help
- 211 bbcon®
- 1.4K Blackbaud Altru®
- 403 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.2K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 16 donorCentrics®
- 360 Blackbaud eTapestry®
- 2.6K Blackbaud Financial Edge NXT®
- 661 Blackbaud Grantmaking™
- 583 Blackbaud Education Management Solutions for Higher Education
- 3.3K Blackbaud Education Management Solutions for K-12 Schools
- 947 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.8K Blackbaud Raiser's Edge NXT®
- 3.8K SKY Developer
- 251 ResearchPoint™
- 120 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 243 Member Lounge (Just for Fun)
- 37 Blackbaud Community Challenges
- 37 PowerUp Challenges
- 3 (Closed) PowerUp Challenge: Grid View Batch
- 3 (Closed) 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
- 804 Community News
- 3K Jobs Board
- 57 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)

