FE NXT Database Schema Online?

Dean Barrett · February 14

We are implementing FE NXT soon and I need to use SKY API to extract data that will eventually make its way to our data warehouse. Is there any online reference for FE NXT?

I found this great resource for CRM:

I would love to have something similar for FE NXT if it exists and I am just missing it. Thanks.

Alex Wong · February 14

@Dean Barrett
if you are planning to use SKY API, you will refer to the SKY API Reference doc for FENXT here:

https://developer.blackbaud.com/skyapi/products/fenxt

If you want even more clarity on data (i.e. what field is limited to how many characters so you can setup the data warehouse table with the right data type and limit), then you will need the FE Database Schema documentation:

https://kb.blackbaud.com/knowledgebase/articles/Article/75380

Warning: FE database schema documentation is not as detailed as the RE database schema documentation.

Dean Barrett · February 14

@Alex Wong - thanks for the reply.

What am I missing to have the .chm file work? (see screenshot below). Yes, I can see the Vendor GET

for example and see the API definition. But, I also want to see the underlying tables. Is ‘Vendor’ data still stored in a table called ‘AP7VENDORS’ or has the whole schema been updated? That is what I am trying to resolve.

6d878b7173afd6e63c7775b9178367d6-huge-fe

Alex Wong · February 14

@Dean Barrett
CHM file is “dangerous”. Ones that are downloaded form the internet requires it to be “unblocked” first.

Right click on the file and select Properties. Then check “Unblock”

7c70b6fd7925341c91b819d6a2c113f5-huge-im

Dean Barrett · February 14

@Alex Wong - thanks! That resolved my issue. Not as convenient as that CRM db reference page but is should get me what I need (assuming it is up to date!).

FE NXT Database Schema Online?

Comments

Categories