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.
Locations	Query Location information for a Merchant.
Merchants	Query the available merchants in Square.
OrderDiscounts	The list of all discounts associated with the order.
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	The list of all taxes associated with the order.
Payments	Query the available card Payments in Square. Cash and other tenders payments will not be returned.
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	Lists all events for a specific subscription.
TeamMemberBookingProfiles	Lists booking profiles for team members.
Teams	Query the available list of TeamMember for a business in Square.