# ChildArticleAttachments - Catalog: `YouTrack` - Schema: `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 - Base Path: `childArticles[*].attachments[*]` - 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 `ChildArticleAttachments` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `$type_1` | `string` | | ☐ | | | `$type_2` | `string` | | ☐ | | | `$type_3` | `string` | | ☐ | | | `$type` | `string` | | ☐ | | | `base64Content_1` | `string` | | ☐ | | | `base64Content` | `string` | Base64 Content | ☐ | | | `charset_1` | `string` | | ☐ | | | `charset` | `string` | Charset | ☐ | | | `content_1` | `string` | | ☐ | | | `content_2` | `string` | | ☐ | | | `content_3` | `string` | | ☐ | | | `content` | `string` | Content | ☐ | | | `created_1` | `int64` | | ☐ | | | `created_2` | `int64` | | ☐ | | | `created_3` | `int64` | | ☐ | | | `created` | `int64` | Created | ☐ | | | `draft_1` | `boolean` | | ☐ | | | `draft` | `boolean` | Draft | ☐ | | | `extension_1` | `string` | | ☐ | | | `extension` | `string` | Extension | ☐ | | | `externalArticle_$type_1` | `string` | | ☐ | | | `externalArticle_$type` | `string` | | ☐ | | | `externalArticle_id_1` | `string` | | ☐ | | | `externalArticle_id` | `string` | | ☐ | | | `externalArticle_key_1` | `string` | | ☐ | | | `externalArticle_key` | `string` | | ☐ | | | `externalArticle_name_1` | `string` | | ☐ | | | `externalArticle_name` | `string` | | ☐ | | | `externalArticle_url_1` | `string` | | ☐ | | | `externalArticle_url` | `string` | | ☐ | | | `hasChildren_1` | `boolean` | | ☐ | | | `hasChildren` | `boolean` | Has Children | ☐ | | | `hasStar_1` | `boolean` | | ☐ | | | `hasStar` | `boolean` | Has Star | ☐ | | | `id_1` | `string` | | ☐ | | | `id_2` | `string` | | ☐ | | | `id_3` | `string` | | ☐ | | | `id` | `string` | ID | ☐ | | | `idReadable_1` | `string` | | ☐ | | | `idReadable` | `string` | Readable ID | ☐ | | | `metaData_1` | `string` | | ☐ | | | `metaData` | `string` | Metadata | ☐ | | | `mimeType_1` | `string` | | ☐ | | | `mimeType` | `string` | MIME-type | ☐ | | | `name_1` | `string` | | ☐ | | | `name` | `string` | Name | ☐ | | | `ordinal_1` | `int64` | | ☐ | | | `ordinal` | `int64` | Ordinal | ☐ | | | `parentArticle_$type` | `string` | | ☐ | | | `parentArticle_base64Content` | `string` | | ☐ | | | `parentArticle_charset` | `string` | | ☐ | | | `parentArticle_content_1` | `string` | | ☐ | | | `parentArticle_content` | `string` | | ☐ | | | `parentArticle_created_1` | `int64` | | ☐ | | | `parentArticle_created_2` | `int64` | | ☐ | | | `parentArticle_created` | `int64` | | ☐ | | | `parentArticle_draft` | `boolean` | | ☐ | | | `parentArticle_extension` | `string` | | ☐ | | | `parentArticle_externalArticle_$type` | `string` | | ☐ | | | `parentArticle_externalArticle_id` | `string` | | ☐ | | | `parentArticle_externalArticle_key` | `string` | | ☐ | | | `parentArticle_externalArticle_name` | `string` | | ☐ | | | `parentArticle_externalArticle_url` | `string` | | ☐ | | | `parentArticle_hasChildren_1` | `boolean` | | ☐ | | | `parentArticle_hasChildren` | `boolean` | | ☐ | | | `parentArticle_hasStar_1` | `boolean` | | ☐ | | | `parentArticle_hasStar` | `boolean` | | ☐ | | | `parentArticle_id` | `string` | | ☐ | | | `parentArticle_idReadable_1` | `string` | | ☐ | | | `parentArticle_idReadable` | `string` | | ☐ | | | `parentArticle_metaData` | `string` | | ☐ | | | `parentArticle_mimeType` | `string` | | ☐ | | | `parentArticle_name` | `string` | | ☐ | | | `parentArticle_ordinal_1` | `int64` | | ☐ | | | `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_removed` | `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_size` | `int64` | | ☐ | | | `parentArticle_summary_1` | `string` | | ☐ | | | `parentArticle_summary` | `string` | | ☐ | | | `parentArticle_updated_1` | `int64` | | ☐ | | | `parentArticle_updated_2` | `int64` | | ☐ | | | `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_url` | `string` | | ☐ | | | `parentArticle_visibility_$type` | `string` | | ☐ | | | `parentArticle_visibility_id` | `string` | | ☐ | | | `project_archived_1` | `boolean` | | ☐ | | | `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_1` | `string` | | ☐ | | | `project_description` | `string` | | ☐ | | | `project_fromEmail_1` | `string` | | ☐ | | | `project_fromEmail` | `string` | | ☐ | | | `project_iconUrl_1` | `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_1` | `string` | | ☐ | | | `project_replyToEmail` | `string` | | ☐ | | | `project_shortName_1` | `string` | | ☐ | | | `project_shortName` | `string` | | ☐ | | | `project_startingNumber_1` | `int64` | | ☐ | | | `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_1` | `boolean` | | ☐ | | | `project_template` | `boolean` | | ☐ | | | `removed_1` | `boolean` | | ☐ | | | `removed` | `boolean` | Removed | ☐ | | | `reporter_$type_1` | `string` | | ☐ | | | `reporter_$type_2` | `string` | | ☐ | | | `reporter_$type_3` | `string` | | ☐ | | | `reporter_$type` | `string` | | ☐ | | | `reporter_avatarUrl_1` | `string` | | ☐ | | | `reporter_avatarUrl_2` | `string` | | ☐ | | | `reporter_avatarUrl_3` | `string` | | ☐ | | | `reporter_avatarUrl` | `string` | | ☐ | | | `reporter_banned_1` | `boolean` | | ☐ | | | `reporter_banned_2` | `boolean` | | ☐ | | | `reporter_banned_3` | `boolean` | | ☐ | | | `reporter_banned` | `boolean` | | ☐ | | | `reporter_email_1` | `string` | | ☐ | | | `reporter_email_2` | `string` | | ☐ | | | `reporter_email_3` | `string` | | ☐ | | | `reporter_email` | `string` | | ☐ | | | `reporter_fullName_1` | `string` | | ☐ | | | `reporter_fullName_2` | `string` | | ☐ | | | `reporter_fullName_3` | `string` | | ☐ | | | `reporter_fullName` | `string` | | ☐ | | | `reporter_guest_1` | `boolean` | | ☐ | | | `reporter_guest_2` | `boolean` | | ☐ | | | `reporter_guest_3` | `boolean` | | ☐ | | | `reporter_guest` | `boolean` | | ☐ | | | `reporter_id_1` | `string` | | ☐ | | | `reporter_id_2` | `string` | | ☐ | | | `reporter_id_3` | `string` | | ☐ | | | `reporter_id` | `string` | | ☐ | | | `reporter_jabberAccountName_1` | `string` | | ☐ | | | `reporter_jabberAccountName_2` | `string` | | ☐ | | | `reporter_jabberAccountName_3` | `string` | | ☐ | | | `reporter_jabberAccountName` | `string` | | ☐ | | | `reporter_login_1` | `string` | | ☐ | | | `reporter_login_2` | `string` | | ☐ | | | `reporter_login_3` | `string` | | ☐ | | | `reporter_login` | `string` | | ☐ | | | `reporter_online_1` | `boolean` | | ☐ | | | `reporter_online_2` | `boolean` | | ☐ | | | `reporter_online_3` | `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_2` | `string` | | ☐ | | | `reporter_ringId_3` | `string` | | ☐ | | | `reporter_ringId` | `string` | | ☐ | | | `size_1` | `int64` | | ☐ | | | `size` | `int64` | Size | ☐ | | | `summary_1` | `string` | | ☐ | | | `summary_2` | `string` | | ☐ | | | `summary_3` | `string` | | ☐ | | | `summary` | `string` | Summary | ☐ | | | `updated_1` | `int64` | | ☐ | | | `updated_2` | `int64` | | ☐ | | | `updated_3` | `int64` | | ☐ | | | `updated` | `int64` | Updated | ☐ | | | `updatedBy_$type_1` | `string` | | ☐ | | | `updatedBy_$type` | `string` | | ☐ | | | `updatedBy_avatarUrl_1` | `string` | | ☐ | | | `updatedBy_avatarUrl` | `string` | | ☐ | | | `updatedBy_banned_1` | `boolean` | | ☐ | | | `updatedBy_banned` | `boolean` | | ☐ | | | `updatedBy_email_1` | `string` | | ☐ | | | `updatedBy_email` | `string` | | ☐ | | | `updatedBy_fullName_1` | `string` | | ☐ | | | `updatedBy_fullName` | `string` | | ☐ | | | `updatedBy_guest_1` | `boolean` | | ☐ | | | `updatedBy_guest` | `boolean` | | ☐ | | | `updatedBy_id_1` | `string` | | ☐ | | | `updatedBy_id` | `string` | | ☐ | | | `updatedBy_jabberAccountName_1` | `string` | | ☐ | | | `updatedBy_jabberAccountName` | `string` | | ☐ | | | `updatedBy_login_1` | `string` | | ☐ | | | `updatedBy_login` | `string` | | ☐ | | | `updatedBy_online_1` | `boolean` | | ☐ | | | `updatedBy_online` | `boolean` | | ☐ | | | `updatedBy_profiles_$type` | `string` | | ☐ | | | `updatedBy_profiles_id` | `string` | | ☐ | | | `updatedBy_ringId_1` | `string` | | ☐ | | | `updatedBy_ringId` | `string` | | ☐ | | | `url_1` | `string` | | ☐ | | | `url` | `string` | URL | ☐ | | | `visibility_$type_1` | `string` | | ☐ | | | `visibility_$type_2` | `string` | | ☐ | | | `visibility_$type_3` | `string` | | ☐ | | | `visibility_$type` | `string` | | ☐ | | | `visibility_id_1` | `string` | | ☐ | | | `visibility_id_2` | `string` | | ☐ | | | `visibility_id_3` | `string` | | ☐ | | | `visibility_id` | `string` | | ☐ | |