Query BankAccounts in Sage Business Cloud Accounting.

Table Specific Information

Query the available BankAccounts

Select

The driver uses the Sage Accounting API to process search criteria that refer to UpdatedOrCreatedSince,DeletedSince,ExcludeStripe columns. The driver processes other filters client-side within the driver.

• UpdatedOrCreatedSince supports the '=' operator.
• DeletedSince supports the '=' operator.
• ExcludeStripe supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM BankAccounts WHERE UpdatedOrCreatedSince='2019-10-02T11:46:53Z'
SELECT * FROM BankAccounts WHERE DeletedSince='2019-10-02T11:46:53Z'
SELECT * FROM BankAccounts WHERE ExcludeStripe='false'

Insert

• Create a simple bank account.
  

  INSERT INTO  [Addresses] (BankAccountTypeId, Balance, AccountName) VALUES ('2', '0.0', 'test')

Update

Updates are performed based on Id.

UPDATE BankAccounts SET BankAccountTypeId='SAVINGS' WHERE Id='80b34e32b85a46c39a71c3627d577fa2'

Delete

You must specify the Id of the BankAccounts to delete it.

DELETE FROM BankAccounts WHERE id ='80b34e32b85a46c39a71c3627d577fa2' 

Columns