Territories
Returns a list of sales territories used for organizing and assigning CRM records by region or criteria.
Select
All the filters are executed at client side within the connector.
SELECT * from Territories;
Columns
| Name | Type | Description |
| Id [KEY] | String | Unique identifier of the territory. |
| Name | String | Name of the territory. |
| ParentId | String | Unique identifier of the parent territory, if one exists. |
| Criteria | String | Conditions used to define which records belong to this territory. |
| Managername | String | Full name of the manager assigned to this territory. |
| Managerid | String | Unique identifier of the manager assigned to this territory. |
| CreatedByName | String | Name of the user who created the territory. |
| CreatedById | String | Unique identifier of the user who created the territory. |
| ModifiedByName | String | Name of the user who last updated the territory. |
| ModifiedByid | String | Unique identifier of the user who last updated the territory. |
| CreatedAt | Datetime | Date and time when the territory was created. |
| ModifiedAt | Datetime | Date and time when the territory was last updated. |
| Desription | String | Description of the territory, if provided. |