Constituent Name Standardization
I hope you’re all doing well. I’m reaching out for some guidance on a Power Automate flow I’m developing to help manage constituent data in Raiser's Edge NXT.
The flow’s purpose is to standardize data by checking for and correcting any improperly formatted names and addresses. Specifically, I want to retrieve fields like First Name, Last Name, Middle Name, Preferred Name, and Address, identify cases where they are in all lowercase or uppercase (e.g., “john doe” or “JOHN DOE”), and then update them to proper case format (e.g., “John Doe”).
To accomplish this, I need to access each constituent’s specific record through the API. If you could help me identify the appropriate endpoint or provide any documentation on accessing constituent-specific details, I would really appreciate it.
Comments
-
@Ann Ubaka
both the List constituent API
https://developer.sky.blackbaud.com/api#api=56b76470069a0509c8f1c5b3&operation=ListConstituentsor the single get constituent API will give you
https://developer.sky.blackbaud.com/api#api=56b76470069a0509c8f1c5b3&operation=GetConstituent
the field you want.
2 -
@Ann Ubaka
In addition to the API endpoint links Alex provided, here are links to the corresponding actions in the (certified) RENXT Constituent connector (these actions use the endpoints that Alex references):You could also use the (certified) RENXT Query connector as the source of constituent data in your flow, in which case you'd be using this action to start a query execution job:
(in the Power Platform Showcase area, you'll also find a sample template that illustrates how to start query job, wait for it to complete, then get the query results)
3
Categories
- All Categories
- New K-12 Community Home (TEST)
- New Higher Education Home Page (Test)
- New Impact Edge Community TEST
- New YourCause Community TEST
- New SKY Community TEST
- New Grantmaking TEST Community
- New Altru Test Community
- New bbcon Community - TEST
- 12 Blackbaud Agents for Good™
- New Raiser's Edge NXT Community
- 8 Blackbaud Community Help
- 222 bbcon®
- 1.4K Blackbaud Altru®
- 411 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.2K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 16 donorCentrics®
- 361 Blackbaud eTapestry®
- 2.7K Blackbaud Financial Edge NXT®
- 688 Blackbaud Grantmaking™
- 604 Blackbaud Education Management Solutions for Higher Education
- 3.3K Blackbaud Education Management Solutions for K-12 Schools
- 954 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 85 JustGiving® from Blackbaud®
- 7.1K Blackbaud Raiser's Edge NXT®
- 4K SKY Developer
- 258 ResearchPoint™
- 123 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 249 Member Lounge (Just for Fun)
- 40 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
- 829 Community News
- 3.1K 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)

