> ## Documentation Index
> Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Square Multi Account Connector

## Intro

Square, Inc. is a financial services, merchant services aggregator, and mobile payments company. Domo's cloud-based solution takes all your Square data and makes it visible and consumable from your phone or computer. Easily see all your Square accounts in one dashboard, with real-time updates, so you can make better decisions for your business.

Quickly analyze your key metrics and gain insights into what action to take next. You can filter by date, location, sales category, and sales type (card or cash). See sales analytics by day or over a custom date range. You can also compare the values from a specified hour today to the same hour on a different day. To learn more about the Square API, go to [https://docs.connect.squareup.com/](https://docs.connect.squareup.com/ "https://docs.connect.squareup.com/").

This topic discusses the fields and menus that are specific to the Square Multi Account connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in [Adding a DataSet Using a Data Connector](/s/article/360042926274).

## Prerequisites

No credentials required. You can add multiple Square accounts that you want to fetch the reports for in the Details section.

### Details Pane

This pane contains a primary **Reports** menu, along with various other menus which may or may not appear depending on the report type you select.

<table border="1" cellpadding="1" cellspacing="1" data-aura-rendered-by="33:195;a"><thead><tr><th colspan="1" rowspan="1"><p> Menu </p></th><th colspan="1" rowspan="1"><p> Description </p></th></tr></thead><tbody><tr><td colspan="1" rowspan="1"> Select the accounts to run </td><td colspan="1" rowspan="1"> Select the accounts you wish to run </td></tr><tr><td colspan="1" rowspan="1"> Skip Errors </td><td colspan="1" rowspan="1"> If an account fails, it will be skipped. Otherwise, the connector will stop. </td></tr><tr><td colspan="1" rowspan="1"><p> Report </p></td><td colspan="1" rowspan="1"><p> Select the report you want to run. The following reports are available: </p><table border="1" cellpadding="1" cellspacing="1"><tbody><tr><td colspan="1" rowspan="1"> Catalog </td><td colspan="1" rowspan="1"> Returns information about product inventory & catalog. </td></tr><tr><td colspan="1" rowspan="1"> Customers </td><td colspan="1" rowspan="1"> Returns summary information for all of the merchant's customers. </td></tr><tr><td colspan="1" rowspan="1"> Labor Break Types </td><td colspan="1" rowspan="1"> Returns possible break types. </td></tr><tr><td colspan="1" rowspan="1"> Labor Shifts </td><td colspan="1" rowspan="1"> Returns shift data </td></tr><tr><td colspan="1" rowspan="1"> Labor Wages </td><td colspan="1" rowspan="1"> Returns wages for team. </td></tr><tr><td colspan="1" rowspan="1"> Locations </td><td colspan="1" rowspan="1"> Returns the merchant's locations information. </td></tr><tr><td colspan="1" rowspan="1"> Orders </td><td colspan="1" rowspan="1"> Returns the information about orders. </td></tr><tr><td colspan="1" rowspan="1"> Payments </td><td colspan="1" rowspan="1"> Returns payment information </td></tr><tr><td colspan="1" rowspan="1"> Refunds </td><td colspan="1" rowspan="1"> Returns details for all refunds initiated by the merchant or any of the merchant's mobile staff. </td></tr><tr><td colspan="1" rowspan="1"> Team Members </td><td colspan="1" rowspan="1"> Returns summary information on about the Team. </td></tr><tr><td colspan="1" rowspan="1"> v1 - Cash Drawer Shifts - Deprecated </td><td colspan="1" rowspan="1"> Deprecation 2020-02-26 - use v2 Cash Drawer Shift </td></tr><tr><td colspan="1" rowspan="1" /><td colspan="1" rowspan="1" /></tr><tr><td colspan="1" rowspan="1"> v1 - Merchant </td><td colspan="1" rowspan="1"> Returns the merchant's account information, such as business name and email address. </td></tr><tr><td colspan="1" rowspan="1"> v1 - Payments </td><td colspan="1" rowspan="1"> Returns information for all payments taken by the merchant or any of the merchant's mobile staff. </td></tr><tr><td colspan="1" rowspan="1"> v1 - Payment Itemization </td><td colspan="1" rowspan="1"> Returns information for all payments taken by the merchant or any of the merchant's mobile staff, broken down into itemized payment information, including discounts, modifiers and taxes. </td></tr><tr><td colspan="1" rowspan="1"> v1 - Refunds </td><td colspan="1" rowspan="1"> Returns details for all refunds initiated by the merchant or any of the merchant's mobile staff. </td></tr><tr><td colspan="1" rowspan="1"> v1 - Settlements Entries </td><td colspan="1" rowspan="1"> Returns information about all transactions in a settlement. </td></tr><tr><td colspan="1" rowspan="1"> v1 - Settlements </td><td colspan="1" rowspan="1"> Returns summary information for all deposits and withdrawals initiated by Square to the merchant's bank account. </td></tr></tbody></table></td></tr><tr><td colspan="1" rowspan="1"> Location Selection </td><td colspan="1" rowspan="1"> Select whether you want to select all locations or from input datasets. </td></tr><tr><td colspan="1" rowspan="1"> Ignore Accounts </td><td colspan="1" rowspan="1"> Check to ignore account selection and pull data based as listed in the InputDataSet </td></tr><tr><td colspan="1" rowspan="1"> Domo DataSet Id </td><td colspan="1" rowspan="1"> Enter your Domo dataset ID(GUID) located in the dataset url. example: <span /><a class="link-https" href="https://customer.domo.com/datasources/" target="_blank" title="https://customer.domo.com/datasources/"> [https://customer.domo.com/datasources/](https://customer.domo.com/datasources/) </a><b> aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee </b> /details/settings </td></tr><tr><td colspan="1" rowspan="1"> Account Column </td><td colspan="1" rowspan="1"> Input the column exactly as found in your DataSet that has the Account Names </td></tr><tr><td colspan="1" rowspan="1"> Location Column </td><td colspan="1" rowspan="1"> Input the column exactly as found in your DataSet that has the location IDs </td></tr><tr><td colspan="1" rowspan="1"> Entry Type </td><td colspan="1" rowspan="1"> SearchOrders will return OrderEntry objects instead of Order objects. OrderEntry objects are lightweight descriptions of orders that include order\_ids. </td></tr><tr><td colspan="1" rowspan="1"> Settlement Status </td><td colspan="1" rowspan="1"> Select the status of the settlement you'd like to filter by. Note that Square does not know when a settlement that's been sent for processing completes, only whether it's failed. </td></tr><tr><td colspan="1" rowspan="1"> Date From </td><td colspan="1" rowspan="1"><p> Specify whether the first date in your date range is a specific or relative date. You select the last date in your range in <span /><b> Date To </b>. </p></td></tr><tr><td colspan="1" rowspan="1"> Select Specific Date From </td><td colspan="1" rowspan="1"><p> Select the first date in your date range. </p> <Note><div class="info-box-wrapper"><div class="info-box-icon-container"><span class="info-box-icon" /></div><div class="info-box-content-container"><div class="info-box-content"><span> Note: <span /> The connector will throw an error if a date range greater than 1 year is selected. </span></div></div></div></Note></td></tr><tr><td colspan="1" rowspan="1"> Date To </td><td colspan="1" rowspan="1"> Specify whether the second date in your date range is a specific or relative date. You select the first date in your range in <span /><b> Date From </b>. </td></tr><tr><td colspan="1" rowspan="1"> Select Specific Date To </td><td colspan="1" rowspan="1"><p> Select the last date in your date range. </p> <Note><div class="info-box-wrapper"><div class="info-box-icon-container"><span class="info-box-icon" /></div><div class="info-box-content-container"><div class="info-box-content"><span> Note: <span /> The connector will throw an error if a date range greater than 1 year is selected. </span></div></div></div> </Note></td></tr><tr><td colspan="1" rowspan="1"> Date From Offset </td><td colspan="1" rowspan="1"><p> Enter the number of the farthest day back that should be represented in the report. Combine with <span /><b> Date To Offset </b><span /> to create a range of represented days. </p><p> For example, if you entered <span /><span class="mt-font-courier-new"> 10 </span><span /> for <span /><b> Date From Offset </b><span /> and <span /><span class="mt-font-courier-new"> 5 </span><span /> for <span /><b> Date To Offset </b>, the report would contain data for <span class="mt-font-courier-new"> 10 </span><span /> days ago up until <span class="mt-font-courier-new"> 5 </span><span /> days ago. </p></td></tr><tr><td colspan="1" rowspan="1"> Date To Offset </td><td colspan="1" rowspan="1"><p> Enter the number of the most recent day that should be represented in the report. Combine with <span /><b> Date From Offset </b><span /> to create a range of represented days. </p><p> For example, if you entered <span /><span class="mt-font-courier-new"> 10 </span><span /> for <span /><b> Date From Offset </b><span /> and <span /><span class="mt-font-courier-new"> 5 </span><span /> for <span /><b> Date To Offset </b>, the report would contain data for <span class="mt-font-courier-new"> 10 </span><span /> days ago up until <span class="mt-font-courier-new"> 5 </span><span /> days ago. </p></td></tr></tbody></table>

### Other Panes

For information about the remaining sections of the Connector interface, including how to configure scheduling, retry, and update options, see [Adding a DataSet Using a Data Connector](/s/article/360042926274).

## FAQs

<AccordionGroup>
  <Accordion title="What kind of credentials do I need to power up this connector?">
    No credentials required. You can add multiple Square accounts that you want to fetch the reports for in the Details section.
  </Accordion>

  <Accordion title="How often can the data be updated?">
    Datasets can be updated as often as once an hour. Update frequency should be decreased if rate limit errors are encountered.
  </Accordion>

  <Accordion title="Are there any API limits that I need to be aware of?">
    No
  </Accordion>
</AccordionGroup>
