Locations

Query Location information for a Merchant.

Table Specific Information

The connector will execute all filters to this table client-side, in memory.

Retrieve all Locations:

SELECT * FROM Locations


Name	Type	Description
Id [KEY]	String	The location's unique ID.
Name	String	The location's name. Location names are set by the account owner and displayed in the dashboard as the location's nickname
Address	String	The location's physical address.
TimeZone	String	The IANA Timezone Database identifier for the location's timezone.
Capabilities	String	Indicates which Square features are enabled for the location.
Status	String	The location's status.
CreatedAt	Datetime	The time when the location was created, in RFC 3339 format.
MerchantId	String	The identifier of the merchant that owns the location.
Country	String	The location's country, in ISO 3166-1-alpha-2 format.
LanguageCode	String	The language associated with the location in BCP 47 format.
Currency	String	The currency used for all transactions at this location, specified in ISO 4217 format.
PhoneNumber	String	The location's phone_number.
BusinessName	String	The location's business_name which is shown to its customers.
Type	String	The location's type, as set by the account owner in the Square dashboard.
WebsiteUrl	String	The location's website, as set by the account owner in the Square dashboard.