Products
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
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | False |
The unique identifier for the item | |
SalesLedgerAccountId | String | False |
The unique identifier for the item | |
CreatedAt | Datetime | True |
The datetime when the item was created | |
SalesTaxRateId | String | False |
TaxRates.Id |
The unique identifier for the item |
Active | Bool | False |
Indicates whether the product is active | |
ItemCode | String | False |
The item code for the product | |
PurchaseLedgerAccountId | String | False |
The unique identifier for the item | |
SalesPricesAggregate | String | False |
The sales prices for the product | |
DeletedAt | Datetime | True |
The datetime when the item was deleted | |
PurchaseTaxRateId | String | False |
TaxRates.Id |
The unique identifier for the item |
Notes | String | False |
The notes for the product | |
CostPrice | String | False |
The cost price of the product | |
UsualSupplierId | String | False |
Contacts.Id |
The unique identifier for the item |
DisplayedAs | String | False |
The name of the resource | |
Description | String | False |
The product description | |
PurchaseDescription | String | False |
The product purchase description | |
LegacyId | Int | False |
The legacy ID for the item | |
SourceGuid | String | False |
Used when importing products from external sources | |
UpdatedAt | Datetime | True |
The datetime when the item was last updated | |
Search | String | False | ||
DeletedSince | Datetime | True |