Query API- output format Rating field

Carol Grant

I have a query that I'm pulling in by the Query by ID through the Query API. In the last week or so I have noticed that one of the Rating fields in the output of the query is coming back as a number not the actual description. I'm pulling it from Specific Sources.

For example, we have a rating description “M - $10,000” this is now appearing as a number 24653. All of them are like this.

I tried changing the formatting mode to Export but that didn't work. I'm also exporting it as a CSV. When I export directly it's fine so this must be something with the API.

Anyone else see this issue?

Alex Wong

@Carol Grant
Have you check if 24653 is the table entries id for M - $10,000 ?

Carol Grant

@Alex Wong- I'm not sure how to check that. I know the field # of that field but I didn't know each entry had an ID. I looked in Tables in NXT and I don't see how I can retrieve that.

When I run the query in NXT it shows the same number. In DB View, it shows as the Text value. Maybe this is something they are working on?

Alex Wong

@Carol Grant
Use this to get code table's id

https://developer.sky.blackbaud.com/api#api=nxt-data-integration&operation=GetCodeTableList

then use this to get table entries (id and description)

https://developer.sky.blackbaud.com/api#api=nxt-data-integration&operation=GetTableEntriesList