Query field id

Koketso Mamabolo
Koketso Mamabolo
First Anniversary Name Dropper Facilitator 1
in Blackbaud Raiser's Edge NXT® APIs

Hello,

for this api call

are the results going to be the same for every account? as an example, will the id always be 309 for relationships regardless of who makes a call? or does the id defer from account to account?

use case: we have multiple clients with RE accounts who will be connecting to our app. we need to run querys to get their data.. does this mean i have to check the Get Query Type, Get Avaialble Fields (Root), and Get Available Fields (Node) for all the accounts? or i can just do it once and use the same field ids to get the data.. this is excluding custom fields… i just meant for all the other generic fields such as firstname, age , gender etc

Comments

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 Raiser's Edge NXT Fall 2025 Product Update Briefing Badge

    @Koketso Mamabolo
    all query_field_id is standard and same across all RE NXT.

    The only difference are individual attribute and individual phone type, etc. Where the query_field_id is the same, but they also have a another field: unique_id that destinate the specific attribute or phone that is ONLY specific to your organization instance of RE NXT.

  • James Belich
    James Belich
    Kudos 1 First Anniversary Name Dropper Facilitator 1

    @Alex Wong This is good to know. Thanks for confirming this, Alex. Do you (or anyone else) happen to know, is there any kind of reference that lists what the query_field_ID is for all fields in RE? When working with Power BI, it would make it easier to add an output field to the JSON if there were such a reference.

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 Raiser's Edge NXT Fall 2025 Product Update Briefing Badge

    @James Belich
    there is no reference list available. Query API has an endpoint that can get each “node” available field's ID, but I used that before and is cumbersome to use.

    The best way to do Query API is to use Query in webview, and then in the “Option” tab it gives you the JSON needed to do the exact same query (filter, output, sort and option).

  • James Belich
    James Belich
    Kudos 1 First Anniversary Name Dropper Facilitator 1

    @Alex Wong Good to know, thanks! I figured that was the case, but it's always worth asking.

  • Erik Leaver
    Erik Leaver Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    @James Belich There is a skills lab session at bbdevdays led by @Stacy Cope & @Austin Brown that might help: “Help! I Can’t Find the Field: Cracking the Code of Blackbaud Raiser's Edge NXT® Data”. You can check out the description & see all skills labs here:


Categories