Data Dictionary RE NXT

Raiser's Edge NXT Core Data Dictionary ver 4.7 (updated 8/03/2026)

1. Prospect ↔ Constituent ID translation (Public Preview, July 21, 2026)

• GetProspectIdByConstituentId — GET /v1/constituents/{constituent_id}/prospect

• GetConstituentIdByProspectId — GET /v1/prospects/{prospect_id}/constituent

These solve the identifier‑space gap: when both a prospect record and a constituent record exist, you can now navigate between them without an intermediate lookup.

2. Query API — SingleRow result layout (Public Preview, announced June 15, edited July 14)

This one was already published before the v4.6 build but wasn't caught — backfilled now. Existing query create/edit endpoints add a result_layout property (MultiRow | SingleRow), plus child_selects and node_type metadata. New GET /v2/queries lists both layouts. SingleRow returns one row per base record with related data flattened into columns — the web view equivalent of database view Export. Layout is fixed at creation; SingleRow is web view only; not all fields/filters are supported yet; not available for favorites.

Raiser's Edge NXT Core Data Dictionary ver 4.6 (updated 7/17/2026)

Support-sheet updates

• SKYAPI Endpoints: +20 rows (4 OpportunityNote, 5 GiftNote, 2 Payments Disbursement, 6 Query Metadata V2, 3 Webhook events)

• Entity Relationships: +8 FK rows for the new entities plus Opportunity.org_contact_id

• Breaking hanges: v4.6 section listing all 7 items with sources; used em-dash section header (not ===) to avoid the leading-= issue that broke v4.5

• Overview: v4.6 changelog block; generated stamp → 2026-07-16 (v4.6)

Raiser's Edge NXT Core Data Dictionary ver 4.5 (updated 7/11/2026)

The Prospect API was missing from previous versions.

Raiser's Edge NXT Core Data Dictionary ver 4.4 (updated 7/1/2026)

Payments API — General Release 

• Formally released in June. Requires a separate subscription and BBMS merchant account setup. A certified Power Automate connector is in testing.community.blackbaud

• New field: reference_transaction_id added to the TransactionRead object, used by GET Checkout transaction, POST Checkout transaction, POST Refund, and GET Transaction — links a refund back to its original charge, or a capture back to its authorization.

Query API — Available field search endpoint (Public Preview)

• New /query/v1/available-fields/search endpoint lets developers programmatically discover queryable fields and categories — this is the "new metadata in RENXT Query" mentioned at the June 16 user group.

New SKY Add-in surfaces

• Add-ins can now target the Campaign, Funds, and Appeal tabs. Documented in BreakingChanges for awareness; not a schema change so no entity sheet added.

What changed in v4.4

• PaymentTransaction sheet (NEW) — 17 fields modeling the TransactionRead object, including the new reference_transaction_id

• PaymentConfiguration sheet (NEW) — 8 fields for the merchant account resource

• SKYAPIEndpoints — +8 rows (7 Payments API, 1 Query available-field-search)

• BreakingChanges — new "New APIs & Field Additions (v4.4)" section with all four items and sources

• Overview — v4.4 changelog block inserted above the v4.3 block; generated stamp updated to 2026-06-30

Workbook now: 54 sheets, 52 Excel Tables, 0 ref/data mismatches, 0 stray drawings, 0 load warnings.

The Planned Gift V2 placeholder sheets from v4.3 still remain placeholders — Blackbaud hasn't published those schemas yet.

Raiser's Edge NXT Core Data Dictionary ver 4.3 (updated 6/14/2026)
Existing sheets updated

• Education: added import_id, notes

• Opportunity: added likelihood, gift_type

• Gift: added documentation note clarifying date vs date_added semantics

New entity sheets

• MembershipCard (9 fields) — supports the new card lifecycle endpoints

• GiftAidDeclaration (16 fields) — UK Gift Aid API (Public Preview, May 2025)

• Planned Gift suite (5 placeholders): PlannedGift, PlannedGiftAsset, PlannedGiftBeneficiary, PlannedGiftRelationship, RealizedRevenueGift — endpoints documented, field schemas marked TBD since Blackbaud hasn't published them yet (June 2026 announcement)

Supporting sheets

• BreakingChanges: full Volunteer API breaking-changes section (4 endpoints, effective 2026-04-23) — GetJobById field type changes, GetVolunteerAssignments date semantics, GetJobVolunteersByJobId clarification + new fields, GetVolunteerEmergencyContact response code change. Plus a Membership 14-new-endpoints summary and a "New APIs" block.

• SKYAPIEndpoints: +54 rows (Membership 16, MembershipCard 4, Volunteer 4, Gift Aid 5, Planned Gift 21, plus shared/notes)

• EntityRelationships: +7 FK rows for the new entities

• Overview: v4.3 changelog block

Raiser's Edge NXT Core Data Dictionary ver 4.2 - added in Constituent Codes, Constituent Attachment, Action Attachment, Cmmunication preference

Raiser's Edge NXT Core Data Dictionary ver 4.1