Changing constituent preferred address
I am trying to do some data cleanup using SKY API. We have a situation where through invalid imports we had some of the existing preferred addresses replaced by new, empty ones.

I used SKY API PATCH Address in Constituent API to update "preferred" field on the Alternate record and while it changed it to Preferred, the empty address disappeared.

I queried the database for the import ID of the "empty" constituent address record - record no longer exists. It looks like the empty address was deleted from the database without actually using DELETE endpoint. While it is somewhat helpful in the sense that we would eventually want to delete the empty addresses, I feel like deleting them without user's control is not entirely appropriate. Is that an intended behavior?
It also seems like only empty records are getting deleted that way. When I changed the "preferred" flag between two complete, non-empty addresses, both the old preferred became the new alternate.
I noticed another interesting thing too. Trying to change ONLY the preferred flag on the address record that for some reason doesn't have country code returns error 400 - country code not found, even though I am only trying to change "preferred" field and "country" is not part of the request.

I used SKY API PATCH Address in Constituent API to update "preferred" field on the Alternate record and while it changed it to Preferred, the empty address disappeared.

I queried the database for the import ID of the "empty" constituent address record - record no longer exists. It looks like the empty address was deleted from the database without actually using DELETE endpoint. While it is somewhat helpful in the sense that we would eventually want to delete the empty addresses, I feel like deleting them without user's control is not entirely appropriate. Is that an intended behavior?
It also seems like only empty records are getting deleted that way. When I changed the "preferred" flag between two complete, non-empty addresses, both the old preferred became the new alternate.
I noticed another interesting thing too. Trying to change ONLY the preferred flag on the address record that for some reason doesn't have country code returns error 400 - country code not found, even though I am only trying to change "preferred" field and "country" is not part of the request.
0
Comments
-
Hello Szymon,
We are looking into this but it might be intentional logic due to the fact that RE7 allows for a blank address. The team is going to dig a bit deeper here to see if we can get you any more details.
Anthony1 -
OK, this is expected functionality here. We added some code to cleanup blank addresses in 2016. We can see that if you are updating an address to be primary and the previous primary address was blank, we will remove that blank address completely. We used to run into a situation where we would have multiple blank addresses in the database and in an effort to clean up this situation, this method was born.1
Categories
- All Categories
- 6 Blackbaud Community Help
- 211 bbcon®
- 1.4K Blackbaud Altru®
- 402 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
- 940 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.7K Blackbaud Raiser's Edge NXT®
- 3.7K SKY Developer
- 248 ResearchPoint™
- 120 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 240 Member Lounge (Just for Fun)
- 34 Blackbaud Community Challenges
- 37 PowerUp Challenges
- 3 (Open) 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
- 796 Community News
- 3K Jobs Board
- 54 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)

