Merchants
Query the available merchants in Square.
Table Specific Information
Select
The adapter uses the Square API to process search criteria that refer to the Id column, while other filters are processed client side within the adapter.
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. |