Excel Add-In for Square

Build 23.0.8839


Query the available merchants in Square.

Table Specific Information


The 本製品 uses the Square API to process search criteria that refer to the Id column, while other filters are processed client side within the 本製品.

Retrieve all the merchants in your Square account.

SELECT * FROM Merchants

Specify Id in the WHERE clause using the = operator:

SELECT * FROM Merchants WHERE Id = 'CD215R7H3340KCD'


Name Type Description
Id [KEY] String The Id of the merchant.
BusinessName String The merchant's business name.
Country String The merchant's country.
Currency String The merchant's currency.
Status String The merchant's status.
LanguageCode String Code of the language.
MainLocationId String The ID of the main Location for this merchant.
CreatedAt Datetime The time when the location was created, in RFC 3339 format.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839