Locations
Query Location information for a Merchant.
Table Specific Information
Select
The 本製品 will execute all filters to this table client-side, in memory. Retrieve all Locations:
SELECT * FROM Locations
Columns
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. |