For every third-party App integration, there are many tables that can be imported. Outside of the reference tables, here are some of the most used tables for your analytics.

  • Items(Incremental)
  • Categories(Incremental)
  • Discounts(Incremental)
  • Taxes(Incremental)
  • ModifierLists(Incremental)
  • Payments(Incremental)

    Retrieves a list of payments taken by the account making the request. Results are eventually consistent, and new payments or changes to payments might take several seconds to appear. The maximum results per page is 100.

  • Refunds(Incremental)

    Retrieves a list of refunds for the account making the request. Results are eventually consistent, and new refunds or changes to refunds might take several seconds to appear. Themaximum results per page is 100.

  • Locations

    Provides information of all locations of a business.

  • Team Members(old V1 Employees API)

    Returns a paginated list of TeamMember objects for a business.

  • List Team Member Wages(old V1 Roles API)

    Returns a paginated list of TeamMemberWage instances for a business.

  • Customers

    Lists customer profiles associated with a Square account.

  • Shifts

    Returns a paginated list of Shift records for a business.

  • Orders

    Search all orders for one or more locations. Orders include all sales, returns, and exchanges regardless of how or when they entered the Square ecosystem (such as Point of Sale, Invoices, and Connect APIs).