The CData Excel Add-In for Square models the Square APIs as relational tables, views, and stored procedures. These are defined in schema files, which are simple, text-based configuration files.

Key Features

• The 本製品 models Square entities like Bookings, BankAccounts or Sites as relational views, allowing you to write SQL to query Square data.
• Stored procedures allow you to execute operations to Square
• Live connectivity to these objects means any changes to your Square account are immediately reflected when using the 本製品.

Tables

テーブル describes the available tables such as Vendors, Invoices or Subscriptions.

Views

ビュー describes the available views. Views are statically defined to entities such as Payouts, SubscriptionEvents, and LocationBookingProfiles.

Stored Procedures

ストアドプロシージャ are function-like interfaces to Square. Stored procedures allow you to execute operations to Square, including attaching documents or images to an invoice and canceling a subscription.

Using Query Processing

The 本製品 offloads as much of the SELECT statement processing as possible to the Square APIs and then processes the rest of the query within the 本製品. The following sections document API limitations, requirements, or particularities.

Querying Several Business Locations

You can query tables/views from different business locations by specifying multiple LocationIds in the "IN" operator. Note however that for tables/views like Customers, Employees, Orders, and OrderItems, this is not possible.

SELECT * FROM Transactions WHERE LocationId IN ('CBASEDbVhLxAJeGrBRLi-BxZ3XcgAQ','CBASEGJDarn_hucmacLdA_iGNGwgAQ','CBASEFsuPlSmrLHXu9a5Lmlv4D4gAQ')