UPDATE: If someone is willing to lend us their assistance to get this accomplished in short order, we are willing to pay for this help.

We just migrated from FE on-premise to NXT. When on-premise, we could bounce simple queries directly against the SQL Server tables to get data we need to do other formatting and processing work with like:

SELECT PURCHASEORDERNUMBER, IMPORTID

FROM AP7PURCHASEORDERS

WHERE (PURCHASEORDERNUMBER = 31600)


and like:

select CHECKNUMBER, AMOUNT, CHECKDATE

from CHECKS7

WHERE (CHECKTYPE = 1 OR CHECKTYPE = 4) and POSTSTATUS = 2 and BANKSID = 1 and CHECKDATE = '" & dDate & "'"


We ran these queries from Visual Studio .NET applications pre-NXT migration and want to accomplish the same kind of thing using NXT tables, but seem to be getting the impression that it's not possible, even though we can get close using the Purchase Order (GET) console at https://developer.sky.blackbaud.com/docs/services/57a342f1d7dcde1c28a749fe/operations/GetPurchaseOrder/console


Has anyone done this kind of thing using .NET and can guide us down a path? The learning curve is feeling steep, if it's even possible.


Thanks!