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