Merchants
Query the available merchants in Square.
Table Specific Information
Select
The driver uses the Square API to process search criteria that refer to the Id column, while other filters are processed client side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will have an unfiltered response.
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'
Columns
| 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. |