Tables
The provider models the data in Square as a list of tables in a relational database that can be queried using standard SQL statements.
CData ADO.NET Provider 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. |
| Locations | Query Location information for a Merchant. |
| PaymentLinks | Lists, Creates, Updates, Deletes payment links. |
| Payments | Query the available card Payments in Square. Cash and other tenders payments will not be returned. |
| 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. |
| Teams | Query the available list of TeamMember for a business in Square. |