TrackingCategories
Query Tracking Categories for a Xero organisation.
Table Specific Information
The TrackingCategories view allows you to SELECT tracking categories for a Xero organization. The Id column is generated by the add-in; it combines the index of the line item with the unique, Xero-generated TrackingCategoryId.
SELECT
The Xero API allows extensive filtering and ordering. You can define WHERE and ORDER BY clauses in a query to filter and order the results using any non-line-item column.
Note: The Xero API does not support filtering on line items or journal lines.
Columns
| Name | Type | Description |
| Id [KEY] | String | The tracking option index combined with the unique Xero identifier of the tracking category. |
| TrackingCategoryId | String | The unique Xero identifier of the tracking category. |
| Name | String | The name of the tracking category. For example, Department or Region. |
| Status | String | The status of a tracking category. This will always be ACTIVE. |
| TrackingOptionId | String | The unique Xero identifier of the tracking option. |
| OptionName | String | The name of the tracking category option. For example, North or South. |
| TenantId | String | The ID of the tenant to query instead of the connection tenant |