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