Power BI Connector for Wave Financial

Build 24.0.9062

Products

List of products (and services) for the business.

Table Specific Information

The 本製品 uses the Wave Financial API to process some of the filters. The 本製品 processes other filters client-side within the 本製品. 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062