Tables

The component models the data in Square as a list of tables in a relational database that can be queried using standard SQL statements.

CData SSIS Components for Square Tables


Name	Description
Cards	Creates, updates, deletes, and retrieves customer‑linked or merchant‑linked cards in Square. Includes cardholder details, billing address, expiration dates, brand information, and card usage status.
CatalogCategories	Query the available catalog categories.
CatalogDiscounts	Query the available catalog discounts.
CatalogImages	Query the available catalog images.
CatalogItems	Retrieves detailed information about each item in a Square seller's catalog, including names, descriptions, pricing variations, availability, and location settings.
CatalogItemVariations	Query the available item variations.
CatalogModifierLists	Query the available catalog modifier lists.
CatalogModifiers	Retrieves detailed information about modifiers associated with Square catalog items, including pricing, availability, and location-specific settings. Modifiers represent add‑ons, options, or customizations that can be applied to an item during checkout.
CatalogTaxes	Query the available catalog taxes.
CustomerGroups	Retrieves, creates, updates, deletes customer groups of a business.
Customers	Create, update, delete, and query the available customers in Square.
DeviceCodes	Creates and lists DeviceCode that can be used to login to a Square Terminal device to enter the connected terminal mode.
GiftCardActivities	Creates and lists gift card activities.
GiftCards	Retrieves, creates, and updates gift card records in Square, including card type, balance, state, account details, and customer associations.
InventoryChanges	Query historical physical counts and adjustments on inventory items.
Invoices	Create, configure, and publish invoices for orders that were created.
Locations	Query Location information for a Merchant.
PaymentLinks	Lists, Creates, Updates, Deletes payment links.
Payments	Retrieves card payments processed through Square. Does not include cash or other non‑card tenders.
Refunds	Creates and retrieves details for refunds issued by a merchant or their staff within a specified date range. Includes refund amounts, payment references, processing fees, destination details, and status tracking.
Shifts	Create, update, delete, and query the available shifts in Square.
Subscriptions	Creates and manages customer subscriptions in Square, including plan details, billing settings, payment methods, and subscription lifecycle status.
Teams	Query the available list of TeamMember for a business in Square.
Vendors	Create, update, and query the available Vendors in Square.