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 add-in 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 add-in.

Tables

Tables describes the available tables such as Vendors, Invoices or Subscriptions.

Views

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

Stored Procedures

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 add-in offloads as much of the SELECT statement processing as possible to the Square APIs and then processes the rest of the query within the add-in. 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')