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/consoleHas 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!