Locations
Query Location information for a Merchant.
Table Specific Information
Select
The provider will execute all filters to this table client-side, in memory. Retrieve all Locations:
SELECT * FROM Locations
Insert
To create a location, you will need to specify Address and Name.
INSERT INTO locations (Address, Name) VALUES ('{ "address_line_1": "1234 Peachtree St. NE", "locality": "Atlanta", "administrative_district_level_1": "GA", "postal_code": "30309"}', 'Midtown')
UPDATE
A location can be updated by providing the Id.
UPDATE locations set name='testlocation' where id='LNX1YQ5C29K9A'
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
The location's unique ID. |
| Name | String | False |
The location's name. Location names are set by the account owner and displayed in the dashboard as the location's nickname |
| Address | String | False |
The location's physical address. |
| TimeZone | String | False |
The IANA Timezone Database identifier for the location's timezone. |
| Capabilities | String | False |
Indicates which Square features are enabled for the location. |
| Status | String | False |
The location's status. |
| CreatedAt | Datetime | False |
The time when the location was created, in RFC 3339 format. |
| MerchantId | String | False |
The identifier of the merchant that owns the location. |
| Country | String | False |
The location's country, in ISO 3166-1-alpha-2 format. |
| LanguageCode | String | False |
The language associated with the location in BCP 47 format. |
| Currency | String | False |
The currency used for all transactions at this location, specified in ISO 4217 format. |
| PhoneNumber | String | False |
The location's phone_number. |
| BusinessName | String | False |
The location's business_name which is shown to its customers. |
| Type | String | False |
The location's type, as set by the account owner in the Square dashboard. |
| WebsiteUrl | String | False |
The location's website, as set by the account owner in the Square dashboard. |
| BusinessHours | String | False |
The hours of operation for the location. |
| Coordinates | String | False |
The physical coordinates (latitude and longitude) of the location. |
| MCC | String | False |
A four-digit number that describes the kind of goods or services sold at the location. The merchant category code (MCC) of the location as standardized by ISO 18245. |