Devices
(Beta) Query the devices registered with a Square merchant.
Table Specific Information
Select
The driver 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 driver.
- 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. |