| ChildArticleAttachments | 
Catalog: YouTrack
Schema: 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.
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
Table Function Columns
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 | 
 | ☐ | 
 | 
23-06-2022 19:43 Version 22.0.248-PROD+3461
 YouTrack API Data Model
YouTrack API Data Model
  