Vendor (GET) vendor_type exists but not in FE NXT Query

Dean Barrett · April 22

The API includes Vendor Type but you cannot access this field in Query

Do the APIs build their queries the same way that the FE NXT Query tool does? If you export the JSON from a query you see this format:

"query": {
"select_fields": [{
"query_field_id": 1248
},
{
"query_field_id": 1250
},
{
"query_field_id": 995
}

What I want to know is if someone can tell me the query field id value for the Vendor Type field so that I can ‘hack’ it into an ad-hoc query API call. Does this id exist for Vendor Type?

Alex Wong · April 23

@Dean Barrett
Query in webview and Query via API is the same as Query in dbview. Until Blackbaud add webview only fields into Query API and webview, you are not going to get field that previously only available via webview. Meaning, there would not be a “query_field_id” for vendor type that is hidden for us to find and use at this time. You will need to use Idea Bank to tell Blackbaud this is needed.

Dean Barrett · April 23

@Alex Wong Thanks for the response!

These are all of the duplicate issues I can find in a quick search of the FE NXT Idea Bank on this issue. Since some are 8+ years old and the vote count scattered among each idea that does not give me much confidence.

5 votes
https://financialedge.ideas.aha.io/ideas/FENXT-I-1219

10 votes
https://financialedge.ideas.aha.io/ideas/FENXT-I-189

6 votes
https://financialedge.ideas.aha.io/ideas/FENXT-I-172

4 votes
https://financialedge.ideas.aha.io/ideas/FENXT-I-1127

4 votes
https://financialedge.ideas.aha.io/ideas/FENXT-I-1812

Vendor (GET) vendor_type exists but not in FE NXT Query

Comments

Categories