# Articles: YouTrack Articles - Catalog: `YouTrack` - Schema: `Articles` - Label: Articles - Select YouTrack API URL: `/articles` - Insert YouTrack API URL: `/articles` - Update YouTrack API URL: `/articles` - Delete YouTrack API URL: `/articles` - Field Selection Method: NotRequired - Select YouTrack API Operation: `get /articles` This is a read-only table function. The YouTrack API may not support changing the data or the Invantive SQL driver for YouTrack does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the YouTrack API. ## Columns of Table Function The columns of the table function `Articles` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `$type` | `string` | | ☐ | | | `content_1` | `string` | | ☐ | | | `content` | `string` | Content | ☐ | | | `created` | `int64` | Created | ☐ | | | `externalArticle_$type` | `string` | | ☐ | | | `externalArticle_id` | `string` | | ☐ | | | `externalArticle_key` | `string` | | ☐ | | | `externalArticle_name` | `string` | | ☐ | | | `externalArticle_url` | `string` | | ☐ | | | `hasChildren` | `boolean` | Has Children | ☐ | | | `hasStar` | `boolean` | Has Star | ☐ | | | `id` | `string` | ID | ☐ | | | `idReadable` | `string` | Readable ID | ☐ | | | `ordinal` | `int64` | Ordinal | ☐ | | | `parentArticle_content` | `string` | | ☐ | | | `parentArticle_created` | `int64` | | ☐ | | | `parentArticle_externalArticle_$type` | `string` | | ☐ | | | `parentArticle_externalArticle_id` | `string` | | ☐ | | | `parentArticle_externalArticle_key` | `string` | | ☐ | | | `parentArticle_externalArticle_name` | `string` | | ☐ | | | `parentArticle_externalArticle_url` | `string` | | ☐ | | | `parentArticle_hasChildren` | `boolean` | | ☐ | | | `parentArticle_hasStar` | `boolean` | | ☐ | | | `parentArticle_idReadable` | `string` | | ☐ | | | `parentArticle_ordinal` | `int64` | | ☐ | | | `parentArticle_parentArticle_content` | `string` | | ☐ | | | `parentArticle_parentArticle_created` | `int64` | | ☐ | | | `parentArticle_parentArticle_hasChildren` | `boolean` | | ☐ | | | `parentArticle_parentArticle_hasStar` | `boolean` | | ☐ | | | `parentArticle_parentArticle_idReadable` | `string` | | ☐ | | | `parentArticle_parentArticle_ordinal` | `int64` | | ☐ | | | `parentArticle_parentArticle_summary` | `string` | | ☐ | | | `parentArticle_parentArticle_updated` | `int64` | | ☐ | | | `parentArticle_project_archived` | `boolean` | | ☐ | | | `parentArticle_project_description` | `string` | | ☐ | | | `parentArticle_project_fromEmail` | `string` | | ☐ | | | `parentArticle_project_iconUrl` | `string` | | ☐ | | | `parentArticle_project_replyToEmail` | `string` | | ☐ | | | `parentArticle_project_shortName` | `string` | | ☐ | | | `parentArticle_project_startingNumber` | `int64` | | ☐ | | | `parentArticle_project_template` | `boolean` | | ☐ | | | `parentArticle_reporter_$type` | `string` | | ☐ | | | `parentArticle_reporter_avatarUrl` | `string` | | ☐ | | | `parentArticle_reporter_banned` | `boolean` | | ☐ | | | `parentArticle_reporter_email` | `string` | | ☐ | | | `parentArticle_reporter_fullName` | `string` | | ☐ | | | `parentArticle_reporter_guest` | `boolean` | | ☐ | | | `parentArticle_reporter_id` | `string` | | ☐ | | | `parentArticle_reporter_jabberAccountName` | `string` | | ☐ | | | `parentArticle_reporter_login` | `string` | | ☐ | | | `parentArticle_reporter_online` | `boolean` | | ☐ | | | `parentArticle_reporter_ringId` | `string` | | ☐ | | | `parentArticle_summary` | `string` | | ☐ | | | `parentArticle_updated` | `int64` | | ☐ | | | `parentArticle_updatedBy_$type` | `string` | | ☐ | | | `parentArticle_updatedBy_avatarUrl` | `string` | | ☐ | | | `parentArticle_updatedBy_banned` | `boolean` | | ☐ | | | `parentArticle_updatedBy_email` | `string` | | ☐ | | | `parentArticle_updatedBy_fullName` | `string` | | ☐ | | | `parentArticle_updatedBy_guest` | `boolean` | | ☐ | | | `parentArticle_updatedBy_id` | `string` | | ☐ | | | `parentArticle_updatedBy_jabberAccountName` | `string` | | ☐ | | | `parentArticle_updatedBy_login` | `string` | | ☐ | | | `parentArticle_updatedBy_online` | `boolean` | | ☐ | | | `parentArticle_updatedBy_ringId` | `string` | | ☐ | | | `parentArticle_visibility_$type` | `string` | | ☐ | | | `parentArticle_visibility_id` | `string` | | ☐ | | | `project_archived` | `boolean` | | ☐ | | | `project_createdBy_$type` | `string` | | ☐ | | | `project_createdBy_avatarUrl` | `string` | | ☐ | | | `project_createdBy_banned` | `boolean` | | ☐ | | | `project_createdBy_email` | `string` | | ☐ | | | `project_createdBy_fullName` | `string` | | ☐ | | | `project_createdBy_guest` | `boolean` | | ☐ | | | `project_createdBy_id` | `string` | | ☐ | | | `project_createdBy_jabberAccountName` | `string` | | ☐ | | | `project_createdBy_login` | `string` | | ☐ | | | `project_createdBy_online` | `boolean` | | ☐ | | | `project_createdBy_ringId` | `string` | | ☐ | | | `project_description` | `string` | | ☐ | | | `project_fromEmail` | `string` | | ☐ | | | `project_iconUrl` | `string` | | ☐ | | | `project_leader_$type` | `string` | | ☐ | | | `project_leader_avatarUrl` | `string` | | ☐ | | | `project_leader_banned` | `boolean` | | ☐ | | | `project_leader_email` | `string` | | ☐ | | | `project_leader_fullName` | `string` | | ☐ | | | `project_leader_guest` | `boolean` | | ☐ | | | `project_leader_id` | `string` | | ☐ | | | `project_leader_jabberAccountName` | `string` | | ☐ | | | `project_leader_login` | `string` | | ☐ | | | `project_leader_online` | `boolean` | | ☐ | | | `project_leader_ringId` | `string` | | ☐ | | | `project_replyToEmail` | `string` | | ☐ | | | `project_shortName` | `string` | | ☐ | | | `project_startingNumber` | `int64` | | ☐ | | | `project_team_$type` | `string` | | ☐ | | | `project_team_allUsersGroup` | `boolean` | | ☐ | | | `project_team_icon` | `string` | | ☐ | | | `project_team_id` | `string` | | ☐ | | | `project_team_name` | `string` | | ☐ | | | `project_team_ringId` | `string` | | ☐ | | | `project_team_usersCount` | `int64` | | ☐ | | | `project_template` | `boolean` | | ☐ | | | `reporter_$type_1` | `string` | | ☐ | | | `reporter_$type` | `string` | | ☐ | | | `reporter_avatarUrl_1` | `string` | | ☐ | | | `reporter_avatarUrl` | `string` | | ☐ | | | `reporter_banned_1` | `boolean` | | ☐ | | | `reporter_banned` | `boolean` | | ☐ | | | `reporter_email_1` | `string` | | ☐ | | | `reporter_email` | `string` | | ☐ | | | `reporter_fullName_1` | `string` | | ☐ | | | `reporter_fullName` | `string` | | ☐ | | | `reporter_guest_1` | `boolean` | | ☐ | | | `reporter_guest` | `boolean` | | ☐ | | | `reporter_id_1` | `string` | | ☐ | | | `reporter_id` | `string` | | ☐ | | | `reporter_jabberAccountName_1` | `string` | | ☐ | | | `reporter_jabberAccountName` | `string` | | ☐ | | | `reporter_login_1` | `string` | | ☐ | | | `reporter_login` | `string` | | ☐ | | | `reporter_online_1` | `boolean` | | ☐ | | | `reporter_online` | `boolean` | | ☐ | | | `reporter_profiles_$type_1` | `string` | | ☐ | | | `reporter_profiles_$type` | `string` | | ☐ | | | `reporter_profiles_id_1` | `string` | | ☐ | | | `reporter_profiles_id` | `string` | | ☐ | | | `reporter_ringId_1` | `string` | | ☐ | | | `reporter_ringId` | `string` | | ☐ | | | `summary_1` | `string` | | ☐ | | | `summary` | `string` | Summary | ☐ | | | `updated` | `int64` | Updated | ☐ | | | `updatedBy_$type` | `string` | | ☐ | | | `updatedBy_avatarUrl` | `string` | | ☐ | | | `updatedBy_banned` | `boolean` | | ☐ | | | `updatedBy_email` | `string` | | ☐ | | | `updatedBy_fullName` | `string` | | ☐ | | | `updatedBy_guest` | `boolean` | | ☐ | | | `updatedBy_id` | `string` | | ☐ | | | `updatedBy_jabberAccountName` | `string` | | ☐ | | | `updatedBy_login` | `string` | | ☐ | | | `updatedBy_online` | `boolean` | | ☐ | | | `updatedBy_profiles_$type` | `string` | | ☐ | | | `updatedBy_profiles_id` | `string` | | ☐ | | | `updatedBy_ringId` | `string` | | ☐ | | | `visibility_$type_1` | `string` | | ☐ | | | `visibility_$type` | `string` | | ☐ | | | `visibility_id_1` | `string` | | ☐ | | | `visibility_id` | `string` | | ☐ | |