Navigation: Schema: > Tables

AdminProjects_IssuesAttachmentsById

Catalog: YouTrack

Retrieve: true

Select YouTrack API URL: /admin/projects/{id}

Insert YouTrack API URL: /admin/projects/{id}

Update YouTrack API URL: /admin/projects/{id}

Delete YouTrack API URL: /admin/projects/{id}

Field Selection Method: NotRequired

Base Path: issues[*].attachments[*]

Select YouTrack API Operation: get /admin/projects/{id}

Parameters of Table Function

The following parameters can be used to control the behaviour of the table function AdminProjects_IssuesAttachmentsById. 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 AdminProjects_IssuesAttachmentsById are shown below. Each column has an SQL data type.

Name	Data Type	Label	Required
$type_1	string		☐
$type_2	string		☐
$type	string		☐
archived	boolean	Archived	☐
base64Content	string	Base64 Content	☐
charset	string	Charset	☐
commentsCount	int32	Comments Count	☐
created_1	int64		☐
created	int64	Created	☐
createdBy_$type	string		☐
createdBy_avatarUrl	string		☐
createdBy_banned	boolean		☐
createdBy_email	string		☐
createdBy_fullName	string		☐
createdBy_guest	boolean		☐
createdBy_id	string		☐
createdBy_jabberAccountName	string		☐
createdBy_login	string		☐
createdBy_online	boolean		☐
createdBy_profiles_$type	string		☐
createdBy_profiles_id	string		☐
createdBy_ringId	string		☐
description_1	string		☐
description	string	Description	☐
draft	boolean	Draft	☐
draftOwner_$type	string		☐
draftOwner_avatarUrl	string		☐
draftOwner_banned	boolean		☐
draftOwner_email	string		☐
draftOwner_fullName	string		☐
draftOwner_guest	boolean		☐
draftOwner_id	string		☐
draftOwner_jabberAccountName	string		☐
draftOwner_login	string		☐
draftOwner_online	boolean		☐
draftOwner_ringId	string		☐
extension	string	Extension	☐
externalIssue_$type	string		☐
externalIssue_id	string		☐
externalIssue_key	string		☐
externalIssue_name	string		☐
externalIssue_url	string		☐
fromEmail	string	From Email	☐
iconUrl	string	Icon (URL)	☐
id_1	string		☐
id_2	string		☐
id	string	ID	☐
idReadable	string	Readable ID	☐
isDraft	boolean	Is Draft	☐
leader_$type	string		☐
leader_avatarUrl	string		☐
leader_banned	boolean		☐
leader_email	string		☐
leader_fullName	string		☐
leader_guest	boolean		☐
leader_id	string		☐
leader_jabberAccountName	string		☐
leader_login	string		☐
leader_online	boolean		☐
leader_profiles_$type	string		☐
leader_profiles_id	string		☐
leader_ringId	string		☐
metaData	string	Metadata	☐
mimeType	string	MIME-type	☐
name_1	string		☐
name	string	Name	☐
numberInProject	int64	Number in Project	☐
parent_$type	string		☐
parent_direction	string		☐
parent_id	string		☐
project_archived	boolean		☐
project_description	string		☐
project_fromEmail	string		☐
project_iconUrl	string		☐
project_replyToEmail	string		☐
project_shortName	string		☐
project_startingNumber	int64		☐
project_template	boolean		☐
removed	boolean	Removed	☐
replyToEmail	string	Reply-to Email	☐
reporter_$type	string		☐
reporter_avatarUrl	string		☐
reporter_banned	boolean		☐
reporter_email	string		☐
reporter_fullName	string		☐
reporter_guest	boolean		☐
reporter_id	string		☐
reporter_jabberAccountName	string		☐
reporter_login	string		☐
reporter_online	boolean		☐
reporter_ringId	string		☐
resolved	int64	Resolved	☐
shortName	string	Short Name	☐
size	int64	Size	☐
startingNumber	int64	Starting Number	☐
subtasks_$type	string		☐
subtasks_direction	string		☐
subtasks_id	string		☐
summary	string	Summary	☐
team_$type	string		☐
team_allUsersGroup	boolean		☐
team_icon	string		☐
team_id	string		☐
team_name	string		☐
team_ringId	string		☐
team_teamForProject_archived	boolean		☐
team_teamForProject_description	string		☐
team_teamForProject_fromEmail	string		☐
team_teamForProject_iconUrl	string		☐
team_teamForProject_replyToEmail	string		☐
team_teamForProject_shortName	string		☐
team_teamForProject_startingNumber	int64		☐
team_teamForProject_template	boolean		☐
team_usersCount	int64		☐
template	boolean	Template	☐
thumbnailURL	string	Thumbnail (URL)	☐
updated_1	int64		☐
updated	int64	Updated	☐
updater_$type	string		☐
updater_avatarUrl	string		☐
updater_banned	boolean		☐
updater_email	string		☐
updater_fullName	string		☐
updater_guest	boolean		☐
updater_id	string		☐
updater_jabberAccountName	string		☐
updater_login	string		☐
updater_online	boolean		☐
updater_ringId	string		☐
url	string	URL	☐
usesMarkdown	boolean	Uses Mark Down	☐
visibility_$type	string		☐
visibility_id	string		☐
voters_$type	string		☐
voters_hasVote	boolean		☐
voters_id	string		☐
votes	int32	Votes	☐
watchers_$type	string		☐
watchers_hasStar	boolean		☐
watchers_id	string		☐
wikifiedDescription	string	Wikified Description	☐

21-06-2022 17:34 Version 22.1.46-BETA+3385

Please enable JavaScript to view this site.

YouTrack API Data Model Forums

AdminProjects_IssuesAttachmentsById

Parameters of Table Function

Table Function Columns