Syncing "Campaign Sum" (NXT into WordPress)
Context: We’re trying to develop a one-way sync of data from NXT into the WordPress Pages on our website. We have a lot of WordPress pages. Each one stores info on an individual “Campaign.” The way our WordPress uses the word “campaign” fully aligns with the NXT data field called "campaign."
The issue: each WordPress page should have a "Campaign Sum" from NXT. To be clear, that Campaign Sum will be that single WordPress page as it's unique to that specific campaign. Our team must pull these “Campaign Sums” into these WordPress pages. We'd like to do this via NXT’s API, but can't figure it out. These Campaign Sums must represent the “total amount raised” for that specific campaign in NXT - no other campaigns should be included.
More context: When I say “Campaign,” that’s our organization's term for an array of time-bound initiatives we’re running concurrently to raise money for specific causes. Before our migration next month, these WordPress pages receive info from Bloomerang on the “total amount raised” for that specific campaign. Linking our CRM to our WordPress Pages lets us account for all donations (not just what is flowing through our payment processor online.) This lets the public see campaign totals that match the reality of what’s been raised.
Thanks for your help!
Ben
Comments
-
@Ben Mackey
My initial instinct is always, think about the data you want then build a query to get that output. Use the Query execution job (by ID) endpoint to get the data. It saves on calls and can easily be automated into an ETL. The query endpoint is included in all my workflows, it is really easy to work with.0 -
@Ben Mackey
You can use website components for this. You can find this in RE NXT > Online Giving > Website components.this allows you to create something that is based on RE NXT data and be embedded to your WP webpage
1
Categories
- All Categories
- 6 Blackbaud Community Help
- 206 bbcon®
- 1.4K Blackbaud Altru®
- 394 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 15 donorCentrics®
- 357 Blackbaud eTapestry®
- 2.5K Blackbaud Financial Edge NXT®
- 646 Blackbaud Grantmaking™
- 561 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 934 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.4K Blackbaud Raiser's Edge NXT®
- 3.6K SKY Developer
- 242 ResearchPoint™
- 118 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 238 The Tap (Just for Fun)
- 33 Blackbaud Community Challenges
- 28 PowerUp Challenges
- 3 (Open) 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
- 778 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)

