Get code table list (PREVIEW) - Forbidden?

Daniel Maxwell

Is anyone using the code table list preview endpoint? I'm trying and getting a 403 Forbidden. Is there anything I need to do to enable this or am I missing something? I'm not sending any parameters yet. Maybe this isn't for NXT? Although I would really like to use this. I'm used to using the CODETABLES and TABLEENTRIES tables from FE 7 on-premises SQL.

Thanks!

Daniel Maxwell

@Daniel Maxwell
I found this blog post Introducing the Code Table API for Raiser's Edge NXT - Blackbaud Community that indicates possibly this API endpoint is just for Raiser's Edge NXT right now.

So, if this isn't available to me, what alternatives do I have to get the Code Tables and Table Entries? I really need several of them.

Alex Wong

@Daniel Maxwell
it does not look like FE NXT has the code table API endpoints yet. only RE.

I have done my fair share of querying directly RE and FE database using SQL and via SKY API. What exactly are you trying to accomplish that you need the code table and tableentries data.

Daniel Maxwell

@Alex Wong For our on-premise database we have, I think 4, code tables and associated table entries that we use as what would be custom fields now. We use them as look-ups and filters, with a relational db model to help hone in on the projects we are after. We have our own Division, Location, Fund Type and a few others very specific to our data. So, I was hoping I could at least use those end points to replicate the data. Is there another way to get that data out of FE via the API?

Alex Wong

@Daniel Maxwell
understood. I don't think what you want exists in FE api endpoints. You will want to use the IdeaBank to get it on BB radar

Daniel Maxwell

@Alex Wong Thanks again, and another idea submitted.