Query field id

Koketso Mamabolo

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

Alex Wong

@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

@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

@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

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

Erik Leaver

@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: