Tables

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

CData Python Connector for Square Tables


Name	Description
Cards	Create, update, delete, and query the available Cards in Square.
CatalogCategories	Query the available catalog categories.
CatalogDiscounts	Query the available catalog discounts.
CatalogImages	Query the available catalog images.
CatalogItems	Query the available items.
CatalogItemVariations	Query the available item variations.
CatalogModifierLists	Query the available catalog modifier lists.
CatalogModifiers	Query the available catalog modifiers.
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	Lists, creates, and updates gift cards.
InventoryChanges	Query historical physical counts and adjustments on inventory items.
Invoices	Create, configure, and publish invoices for orders that were created.
PaymentLinks	Lists, Creates, Updates, Deletes payment links.
Refunds	Create and query the details for all Refunds initiated by a merchant or any of the mobile staff of the merchant during a date range.
Shifts	Create, update, delete, and query the available shifts in Square..
Subscriptions	Create and manage subscriptions.