The CData MCP Server 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 server 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 server.

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