Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData Power BI Connector for Square Views
| Name | Description |
| BankAccountByV1Id | Retrieve a bank account by its legacy Square V1 bank account ID. |
| BusinessBookingProfile | Retrieves a seller's booking profile. |
| Catalog | Returns a list of all CatalogObjects. |
| CatalogInfo | Returns information about the catalog API, including API limits and the current API version. |
| Channels | (Beta) Query the channels available to a Square seller. |
| CheckoutMerchantSettings | Query the merchant-level settings for Square online checkout. This is a read-only single-row view. |
| Devices | (Beta) Query the devices registered with a Square merchant. |
| Disputes | Query the disputes associated with a Square account. |
| InventoryAdjustments | Retrieves a single InventoryAdjustment record by its ID. |
| InventoryCounts | Query current inventory counts in Square using a batch POST retrieval endpoint. Supports filtering by CatalogObjectId, LocationId, and State. |
| InventoryPhysicalCounts | Retrieves a single InventoryPhysicalCount record by its ID. A WHERE Id = '...' clause is required. |
| InventoryTransfers | Retrieves a single InventoryTransfer record by its ID. A WHERE Id = '...' clause is required. This is a Beta API. |
| LocationBookingProfiles | Lists location booking profiles of a seller. |
| Merchants | Query the available merchants in Square. |
| OrderDiscounts | Returns all discounts applied to a specific Square order, including fixed and percentage-based discounts, their scope, and related catalog details. |
| OrderEntries | A list of OrderEntries that fit the query conditions. |
| OrderItems | The order items included in the order. Every order has at least one order item. |
| Orders | Orders specify products for purchase, along with discounts, taxes, and other settings to apply to the purchase. |
| OrderTaxes | Returns all taxes applied to a specific Square order, including percentage‑based and fixed‑amount taxes, their scope, and related catalog details. |
| PayoutEntries | Retrieves a list of all payout entries for a specific payout. |
| Payouts | Retrieves a list of all payouts for the default location. |
| SearchAvailability | Query available appointment slots in Square. Use StartAt range filters to define the search window. |
| Sites | Lists the Square Online sites that belong to a seller. |
| SubscriptionEvents | Returns all events that have occurred for a specific Square subscription, including plan changes, phase transitions, cancellations, and other subscription lifecycle updates. |
| TeamMemberBookingProfiles | Lists booking profiles for team members. |