# HelpdeskArticles: Crisp Helpdesk Articles - Catalog: `Crisp` - Schema: `Views` - Label: Helpdesk Articles 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 `HelpdeskArticles` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `article_id` | `varchar2` | | ☑ | Article identifier. | | `article_id` | `varchar2` | | ☑ | Article identifier. | | `category_color` | `varchar2` | | ☐ | Colour of the category as a hexadecimal colour code (if any). | | `category_color` | `varchar2` | | ☐ | Colour of the category as a hexadecimal colour code (if any). | | `category_id` | `varchar2` | | ☐ | Identifier of the category of the article (if any). | | `category_id` | `varchar2` | | ☐ | Identifier of the category of the article (if any). | | `category_name` | `varchar2` | | ☐ | Name of the category of the article (if any). | | `category_name` | `varchar2` | | ☐ | Name of the category of the article (if any). | | `created_at` | `datetime` | | ☑ | Article creation timestamp. | | `created_at` | `datetime` | | ☑ | Article creation timestamp. | | `featured` | `char` | | ☐ | Whether the article is featured or not. | | `featured` | `char` | | ☐ | Whether the article is featured or not. | | `locale` | `varchar2` | | ☑ | Locale code of the helpdesk (ISO 639-1). | | `locale` | `varchar2` | | ☑ | Locale code of the helpdesk (ISO 639-1). | | `order` | `int32` | | ☐ | Article ordering weight. | | `order` | `int32` | | ☐ | Article ordering weight. | | `published_at` | `datetime` | | ☐ | Article publication timestamp. | | `published_at` | `datetime` | | ☐ | Article publication timestamp. | | `section_id` | `varchar2` | | ☐ | Identifier of the section within the category (if any). | | `section_id` | `varchar2` | | ☐ | Identifier of the section within the category (if any). | | `section_name` | `varchar2` | | ☐ | Name of the section within the category (if any). | | `section_name` | `varchar2` | | ☐ | Name of the section within the category (if any). | | `status` | `varchar2` | | ☑ | Status of the article; one of published and draft. | | `status` | `varchar2` | | ☑ | Status of the article; one of published and draft. | | `title` | `varchar2` | | ☑ | Title of the article. | | `title` | `varchar2` | | ☑ | Title of the article. | | `updated_at` | `datetime` | | ☑ | Article update timestamp. | | `updated_at` | `datetime` | | ☑ | Article update timestamp. | | `url` | `varchar2` | | ☐ | Public URL of the article when published. | | `url` | `varchar2` | | ☐ | Public URL of the article when published. | | `visibility` | `varchar2` | | ☐ | Visibility of the article when published; one of visible and hidden. | | `visibility` | `varchar2` | | ☐ | Visibility of the article when published; one of visible and hidden. | | `visits` | `int64` | | ☐ | Number of times the article has been visited. | | `visits` | `int64` | | ☐ | Number of times the article has been visited. |# HelpdeskArticles: Crisp Helpdesk Articles - Catalog: `Crisp` - Schema: `Views` - Label: Helpdesk Articles 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 `HelpdeskArticles` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `article_id` | `varchar2` | | ☑ | Article identifier. | | `article_id` | `varchar2` | | ☑ | Article identifier. | | `category_color` | `varchar2` | | ☐ | Colour of the category as a hexadecimal colour code (if any). | | `category_color` | `varchar2` | | ☐ | Colour of the category as a hexadecimal colour code (if any). | | `category_id` | `varchar2` | | ☐ | Identifier of the category of the article (if any). | | `category_id` | `varchar2` | | ☐ | Identifier of the category of the article (if any). | | `category_name` | `varchar2` | | ☐ | Name of the category of the article (if any). | | `category_name` | `varchar2` | | ☐ | Name of the category of the article (if any). | | `created_at` | `datetime` | | ☑ | Article creation timestamp. | | `created_at` | `datetime` | | ☑ | Article creation timestamp. | | `featured` | `char` | | ☐ | Whether the article is featured or not. | | `featured` | `char` | | ☐ | Whether the article is featured or not. | | `locale` | `varchar2` | | ☑ | Locale code of the helpdesk (ISO 639-1). | | `locale` | `varchar2` | | ☑ | Locale code of the helpdesk (ISO 639-1). | | `order` | `int32` | | ☐ | Article ordering weight. | | `order` | `int32` | | ☐ | Article ordering weight. | | `published_at` | `datetime` | | ☐ | Article publication timestamp. | | `published_at` | `datetime` | | ☐ | Article publication timestamp. | | `section_id` | `varchar2` | | ☐ | Identifier of the section within the category (if any). | | `section_id` | `varchar2` | | ☐ | Identifier of the section within the category (if any). | | `section_name` | `varchar2` | | ☐ | Name of the section within the category (if any). | | `section_name` | `varchar2` | | ☐ | Name of the section within the category (if any). | | `status` | `varchar2` | | ☑ | Status of the article; one of published and draft. | | `status` | `varchar2` | | ☑ | Status of the article; one of published and draft. | | `title` | `varchar2` | | ☑ | Title of the article. | | `title` | `varchar2` | | ☑ | Title of the article. | | `updated_at` | `datetime` | | ☑ | Article update timestamp. | | `updated_at` | `datetime` | | ☑ | Article update timestamp. | | `url` | `varchar2` | | ☐ | Public URL of the article when published. | | `url` | `varchar2` | | ☐ | Public URL of the article when published. | | `visibility` | `varchar2` | | ☐ | Visibility of the article when published; one of visible and hidden. | | `visibility` | `varchar2` | | ☐ | Visibility of the article when published; one of visible and hidden. | | `visits` | `int64` | | ☐ | Number of times the article has been visited. | | `visits` | `int64` | | ☐ | Number of times the article has been visited. |