GeofenceConfigs
Retrieves a list of all geofence configs.
Table Specific Information
Select
Query the GeofenceConfigs table. The connector will use the TSheets API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
- Id, TypeId and Type fields support the '=' and IN operators.
- Enabled and Active fields support the '=' operator.
- LastModified field supports the <=,<,>=,>,= operators.
For example, the following queries are processed server side:
SELECT * FROM GeofenceConfigs WHERE TypeId IN (282316, 323445) and Type = 'Locations' SELECT * FROM GeofenceConfigs WHERE Enabled = false
Columns
| Name | Type | Description |
| Id [KEY] | Int | Id of geofence config. |
| Type | String | The type of entity the geofence config is related to. |
| TypeId | Int | The id of the entity the geofence config is related to. |
| Active | Boolean | Whether this geofence config is active. If false, this geofence config is archived. |
| Enabled | Boolean | Indicates whether a geofence for the associated entity should be enabled. |
| Radius | Int | Configures the size of the geofence. |
| Created | Datetime | Date/time when this geofence config was created |
| LastModified | Datetime | Date/time when this geofence config was last modified. |