Duplicate records returned via users extended endpoint - one without roles

Tyler Sivavec

A mutual client (The Frederick Gunn School) is reporting issues in Finalsite, and the source issue is that the users extended endpoint is returning some records more than once, with the same ID, but no metadata (phones, roles, occupations, etc.)

For example, ID 3553392 is returned once via this endpoint with no metadata (phones, roles, occupations, etc.) and once with that metadata. You can see the same thing happening with ID 6946247.

This inconsistency is causing critical issues, as we depend on the roles a record is returned with. Please treat this case with urgency

Tyler Sivavec

Noticing this for many clients via the users extended by roles endpoint unfortunately

Todd DeSchuiteneer

@Tyler Sivavec this issue was reported to our Support team from a school and we are currently investigating the issue. If there are more examples it would be appreciated if the problem was reported to our team with as much detail as possible.

Tyler Sivavec

@Todd DeSchuiteneer Thanks for the reply. I can see this happening for another mutual client of ours, Notre Dame High School https://www.ndnj.org/ as well.

returns IDs 2768354, 3082302 and 3066458 twice, once without any roles.

---

For The Frederick Gunn School, these IDs are returned twice:
3553392,3553401,4237732,4238140,4268091,4384401,5551809,5483027,6191565,6915035,7408933,7635570,7779272,6946247

for

Let me know what other information might be helpful
https://api.sky.blackbaud.com/school/v1/users/extended?base_role_ids=15

Judy Rynkewicz

@Todd DeSchuiteneer
Hi Todd, I would like to escalate this issue. I can also tell you that it seems to be only happening with the following staff members each time: Aaron Bartuska, Kristen Lloyd and Sean O'Malley. These individual are also alumni and exist in Blackbaud in the roles of faculty or staff and alumni. We currently don't sync alumni but they have been given that role manually on the Finalsite side.

Tyler Sivavec

@Todd DeSchuiteneer Got a new report from Summit Country Day School https://www.summitcds.org/ of this same issue.

Faculty feed:

Affected IDs: 2907781,3035881,2926924,2927301,2927039,3121258,2926838,2926931,2926825,2927415,3446018,2926927

Parent feed:

Affected IDs:
3035881,2927301,5123565,2926767,2926931,2926945

Please treat this as a critical issue

Todd DeSchuiteneer

Hi @Judy Rynkewicz , I apologize for the problems this issue is causing for your school and I have already reached out to my development team on it and have made sure it will be addressed as soon as possible.

If there is suspicion of a defect within the application or with API results in the future, either you or the developer of the application can reach out to the support team first so we can gather the necessary details and report the issue directly to our development team. That way we can properly provide updates and notification of resolution.

Todd DeSchuiteneer

@Tyler Sivavec I wanted to give you an update on the issue. The team has been investigating the issue and found the cause. The problem is stemming from schools having duplicate values in their Citizenship tables found in Core > Settings > General Settings > Table Values.

To immediately resolve the issue if the admins at schools go in there, there is a clean up option to merge fields or they could give the values unique names. Example: 2 United Kingdom entries, they could change one to Great Britain.

The team is working on a fix to stop issues like this one from occurring in the future.

Tyler Sivavec

@Todd DeSchuiteneer Thanks for that Todd - I'll pass that info along as a workaround in the interim and I look forward to a permanent solution

Tyler Sivavec

@Todd DeSchuiteneer Hey Todd. I appreciate the workaround you had previously shared, but was wondering if there was any update about a permanent fix for this issue. Thanks for your help

Todd DeSchuiteneer

@Tyler Sivavec sorry for the late reply. Our development team has put in a permanent fix for this issue so duplicate records will not be returned if this type of issue should come up again.