Navigation: Schema: Articles > Tables

AttachmentById

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/{id}

Insert YouTrack API URL: /articles/{id}

Update YouTrack API URL: /articles/{id}

Delete YouTrack API URL: /articles/{id}

Field Selection Method: NotRequired

Base Path: attachments[*]

Select YouTrack API Operation: get /articles/{id}

Parameters of Table Function

The following parameters can be used to control the behaviour of the table function AttachmentById. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be treated using their default values.

Value specification by position is done by listing all values from the first to the last needed value. For example with `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.

Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.

Name	Data Type	Required	Default Value	Documentation
id	string	☑

Table Function Columns

The columns of the table function AttachmentById are shown below. Each column has an SQL data type.

Name	Data Type	Label	Required
$type_1	string		☐
$type_2	string		☐
$type	string		☐
article_$type_1	string		☐
article_$type	string		☐
article_content_1	string		☐
article_content	string		☐
article_id_1	string		☐
article_id	string		☐
article_summary_1	string		☐
article_summary	string		☐
author_$type_1	string		☐
author_$type	string		☐
author_avatarUrl_1	string		☐
author_avatarUrl	string		☐
author_banned_1	boolean		☐
author_banned	boolean		☐
author_email_1	string		☐
author_email	string		☐
author_fullName_1	string		☐
author_fullName	string		☐
author_guest_1	boolean		☐
author_guest	boolean		☐
author_id_1	string		☐
author_id	string		☐
author_jabberAccountName_1	string		☐
author_jabberAccountName	string		☐
author_login_1	string		☐
author_login	string		☐
author_online_1	boolean		☐
author_online	boolean		☐
author_ringId_1	string		☐
author_ringId	string		☐
base64Content_1	string		☐
base64Content	string	Base64 Content	☐
charset_1	string		☐
charset	string	Charset	☐
comment_$type_1	string		☐
comment_$type	string		☐
comment_created_1	int64		☐
comment_created	int64		☐
comment_id_1	string		☐
comment_id	string		☐
comment_text_1	string		☐
comment_text	string		☐
comment_updated_1	int64		☐
comment_updated	int64		☐
content_1	string		☐
content	string	Content	☐
created_1	int64		☐
created_2	int64		☐
created	int64	Created	☐
draft_1	boolean		☐
draft	boolean	Draft	☐
extension_1	string		☐
extension	string	Extension	☐
externalArticle_$type	string		☐
externalArticle_id	string		☐
externalArticle_key	string		☐
externalArticle_name	string		☐
externalArticle_url	string		☐
hasChildren	boolean	Has Children	☐
hasStar	boolean	Has Star	☐
id_1	string		☐
id_2	string		☐
id	string	ID	☐
idReadable	string	Readable ID	☐
metaData_1	string		☐
metaData	string	Metadata	☐
mimeType_1	string		☐
mimeType	string	MIME-type	☐
name_1	string		☐
name	string	Name	☐
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		☐
removed_1	boolean		☐
removed	boolean	Removed	☐
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		☐
size_1	int64		☐
size	int64	Size	☐
summary_1	string		☐
summary	string	Summary	☐
updated_1	int64		☐
updated_2	int64		☐
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		☐
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

Please enable JavaScript to view this site.

YouTrack API Data Model

AttachmentById

Parameters of Table Function

Table Function Columns

Important Safety and Usage Information