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 SSIS Components for Square Views
| Name | Description |
| BankAccounts | Query the Bank Accounts of the merchant. |
| Bookings | Lists all bookings. |
| BusinessBookingProfile | Retrieves a seller's booking profile. |
| Catalog | Returns a list of all CatalogObjects. |
| 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. |
| 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. |