Devices
(Beta) Query the devices registered with a Square merchant.
Table Specific Information
Select
The add-in uses the Square API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the add-in.
- Id supports the following operator: =.
- LocationId supports the following operator: =.
Retrieve all devices:
SELECT * FROM Devices
Retrieve a specific device:
SELECT * FROM Devices WHERE Id = 'device_id_here'
Retrieve devices at a specific location:
SELECT * FROM Devices WHERE LocationId = '92BYHNBR6W77E'
Columns
| Name | Type | Description |
| Id [KEY] | String | A synthetic identifier for the device. The identifier includes a standardized prefix and is otherwise an opaque id generated from key device fields. |
| StatusCategory | String | Category of the device status. |
| Name | String | A seller-specified name for the device. |
| DeviceType | String | The device type. |
| Manufacturer | String | The maker of the device. |
| Model | String | The specific model of the device. |
| ManufacturersId | String | The manufacturer-supplied identifier for the device (where available). |
| Version | String | The current version of software installed on the device. |
| MerchantToken | String | The merchant_token identifying the merchant controlling the device. |
| UpdatedAt | Datetime | The RFC 3339-formatted value of the most recent update to the device information. |
| Components | String | A list of components applicable to the device. |
Pseudocolumns
Pseudo column fields are used in the WHERE clause of SELECT statements (unless stated otherwise) and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| LocationId | String | Filter devices by location ID. |