Query Products in Sage Business Cloud Accounting.

Table Specific Information

Query the available Products

Select

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

• Active supports the '=' operator.
• Search supports the '=' operator.
• UpdatedOrCreatedSince supports the '=' operator.
• DeletedSince supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM Products WHERE Active=false
SELECT * FROM Products WHERE Search='abc'
SELECT * FROM Products WHERE UpdatedOrCreatedSince='2018-12-15'
SELECT * FROM Products WHERE DeletedSince='2018-12-15'

Insert

Create a simple product.

INSERT INTO  [Products] (SalesLedgerAccountId, CostPrice, ItemCode) VALUES ('1', '1', '1')

Update

Updates are performed based on Id.

UPDATE Products SET SalesLedgerAccountId='abc' WHERE Id='123'

Delete

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

DELETE FROM Products WHERE id ='123' 

Columns