Power BI Connector for Wave Financial

Build 24.0.9062

Businesses

List businesses.

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 name FROM Businesses WHERE Id = 'QnVzaW5lc3M6MDU3MWUwYWYtGI3LWE1ZTAtNmYyNzU4N2IwNGNi'

Columns

Name Type References SupportedOperators Description
Id [KEY] String The unique identifier for the business.
Name String The name of the business.
IsPersonal Bool Is the business a personal one with limited functionality compared to regular businesses.
OrganizationalType String The organization type of the business.
TypeName String The description of the business type in human-friendly form.
TypeValue String The enum value of the business type.
SubtypeName String The description of the business subtype in human-friendly form.
SubtypeValue String The enum value of the business subtype.
CurrencyCode String

Currencies.Code

Currency code.
Timezone String The timezone of the business.
AddressLine1 String Address line 1 (Street address/PO Box/Company name).
AddressLine2 String Address line 2 (Apartment/Suite/Unit/Building).
AddressCity String City/District/Suburb/Town/Village.
AddressProvinceCode String

Provinces.Code

[ISO 3166-2](https://en.wikipedia.org/wiki/ISO_3166-2) identifier.
AddressCountryCode String

Countries.Code

Country code.
AddressPostalCode String Zip/Postal Code.
Phone String The phone number of the business.
Fax String The fax number of the business.
Mobile String The mobile/cell number of the business.
TollFree String The toll free number of the business.
Website String The website of the business.
IsArchived Bool Is the business hidden from view by default.
CreatedAt Datetime When the business was created.
ModifiedAt Datetime When the business was last modified.

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