List of products (and services) for the business.

Table Specific Information

The adapter uses the Wave Financial API to process some of the filters. The adapter processes other filters client-side within the adapter. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause inconsistent data. For example, the following queries are processed server side.

SELECT

SELECT * FROM Products WHERE BusinessId = 'QnVzaW5lc3M6NjE2MTYtYzVlMS00YzkyLTg0Y2EtNzA0ZDM4MTcyNTdl'
SELECT * FROM Products WHERE Id = 'QzVlMS00YzkyLTg0Y2EtNzA0ZDM4MTcyNTdlO0N1c3RvbWVyOjMyNzkyMTEz'
SELECT * FROM Products WHERE IsSold = true
SELECT * FROM Products WHERE IsBought = true
SELECT * FROM Products WHERE IsArchived = true
SELECT * FROM Products WHERE ModifiedAt < '2020-07-03 08:28:56.0'

Columns

Name	Type	References	SupportedOperators	Description
Id [KEY]	String			Unique identifier for the product.
BusinessId	String	Businesses.id		The unique identifier for the business.
Name	String			Name of the product.
Description	String			Description of the product.
UnitPrice	Decimal			Price per unit in the major currency unit.
IsSold	Bool			Is product sold by the business. Allow this product or service to be added to Invoices.
IsBought	Bool			Is product bought by the business. Allow this product or service to be added to Bills.
IncomeAccountId	String	Accounts.Id		Unique identifier for the account.
ExpenseAccountId	String	Accounts.Id		Unique identifier for the account.
IsArchived	Bool			Is the product hidden from view by default.
CreatedAt	Datetime			When the product was created.
ModifiedAt	Datetime			When the product was last modified.