# HelpdeskCategories: Crisp Helpdesk Categories - Catalog: `Crisp` - Schema: `Views` - Label: Helpdesk Categories This is a read-only view. The Crisp API may not support changing the data or the Invantive UniversalSQL driver for Crisp does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Crisp API. ## View Columns The columns of the view `HelpdeskCategories` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `articles` | `int64` | | ☐ | Number of articles in the category. | | `articles` | `int64` | | ☐ | Number of articles in the category. | | `category_id` | `varchar2` | | ☑ | Category identifier. | | `category_id` | `varchar2` | | ☑ | Category identifier. | | `color` | `varchar2` | | ☐ | Colour of the category as a hexadecimal colour code (if any). | | `color` | `varchar2` | | ☐ | Colour of the category as a hexadecimal colour code (if any). | | `created_at` | `datetime` | | ☑ | Category creation timestamp. | | `created_at` | `datetime` | | ☑ | Category creation timestamp. | | `description` | `varchar2` | | ☐ | Description of the category (if any). | | `description` | `varchar2` | | ☐ | Description of the category (if any). | | `image` | `varchar2` | | ☐ | Image URL of the category (if any). | | `image` | `varchar2` | | ☐ | Image URL of the category (if any). | | `locale` | `varchar2` | | ☑ | Locale code of the helpdesk (ISO 639-1). | | `locale` | `varchar2` | | ☑ | Locale code of the helpdesk (ISO 639-1). | | `name` | `varchar2` | | ☑ | Name of the category. | | `name` | `varchar2` | | ☑ | Name of the category. | | `order` | `int32` | | ☐ | Category ordering weight. | | `order` | `int32` | | ☐ | Category ordering weight. | | `sections` | `int64` | | ☐ | Number of sections in the category. | | `sections` | `int64` | | ☐ | Number of sections in the category. | | `updated_at` | `datetime` | | ☑ | Category update timestamp. | | `updated_at` | `datetime` | | ☑ | Category update timestamp. | | `url` | `varchar2` | | ☐ | Public URL of the category. | | `url` | `varchar2` | | ☐ | Public URL of the category. |# HelpdeskCategories: Crisp Helpdesk Categories - Catalog: `Crisp` - Schema: `Views` - Label: Helpdesk Categories This is a read-only view. The Crisp API may not support changing the data or the Invantive UniversalSQL driver for Crisp does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Crisp API. ## View Columns The columns of the view `HelpdeskCategories` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `articles` | `int64` | | ☐ | Number of articles in the category. | | `articles` | `int64` | | ☐ | Number of articles in the category. | | `category_id` | `varchar2` | | ☑ | Category identifier. | | `category_id` | `varchar2` | | ☑ | Category identifier. | | `color` | `varchar2` | | ☐ | Colour of the category as a hexadecimal colour code (if any). | | `color` | `varchar2` | | ☐ | Colour of the category as a hexadecimal colour code (if any). | | `created_at` | `datetime` | | ☑ | Category creation timestamp. | | `created_at` | `datetime` | | ☑ | Category creation timestamp. | | `description` | `varchar2` | | ☐ | Description of the category (if any). | | `description` | `varchar2` | | ☐ | Description of the category (if any). | | `image` | `varchar2` | | ☐ | Image URL of the category (if any). | | `image` | `varchar2` | | ☐ | Image URL of the category (if any). | | `locale` | `varchar2` | | ☑ | Locale code of the helpdesk (ISO 639-1). | | `locale` | `varchar2` | | ☑ | Locale code of the helpdesk (ISO 639-1). | | `name` | `varchar2` | | ☑ | Name of the category. | | `name` | `varchar2` | | ☑ | Name of the category. | | `order` | `int32` | | ☐ | Category ordering weight. | | `order` | `int32` | | ☐ | Category ordering weight. | | `sections` | `int64` | | ☐ | Number of sections in the category. | | `sections` | `int64` | | ☐ | Number of sections in the category. | | `updated_at` | `datetime` | | ☑ | Category update timestamp. | | `updated_at` | `datetime` | | ☑ | Category update timestamp. | | `url` | `varchar2` | | ☐ | Public URL of the category. | | `url` | `varchar2` | | ☐ | Public URL of the category. |