Can we fetch Account and account balance data from...
# suitetalkapiv
VK101
11/02/2020, 12:36 AMCan we fetch Account and account balance data from Netsuite's REST apis ?
b
battk
11/02/2020, 8:44 AMsadly both the rest api browser and the analytics browser say that balance is available but test requests/queries show that they aren't available
battk
11/02/2020, 8:53 AMthe TransactionAccountingLine join appears to exist, so you may be able to use suiteql to get your data if you know how to write a sql query with joins and aggregate functions
battk
11/02/2020, 8:56 AMmy guess to get the balance is that you want the sum of the amount of transaction accounting lines that are posting, grouped by the account's id
👍 1
t
tdietrich
11/02/2020, 11:30 AM@VK101 I use this SuiteQL query to get account balances, but I use a RESTlet. I'm not sure if it works with SuiteTalk REST.
SELECTAcctType,AcctNumber,FullName,Description,BalanceFROMAccountORDER BYAcctType ASC,FullName ASC👍 1
m
Marc Reicher
11/02/2020, 5:09 PMThere is a way to do this. Can I ask what the use case is?
v
VK101
11/05/2020, 3:24 AM@Marc Reicher.. we have already integrated simple data types of NS (invoice, invoice items, credit memo, customer, credit memo allocations, refunds) using SOAP. Now we are extending our integration to accounting data types as well!
For that I'm looking into SOAP and REST based apis and checking which will be easier for us to move forward. As we have already done previous integration with SOAP apis we are leaning towards it. But the challenge comes in when we are looking for an incremental fetch of data using lastmodifieddate with accounting data types.
32 Views