Issues |
Catalog: YouTrack
Schema: Admin
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: /admin/projects
Insert YouTrack API URL: /admin/projects
Update YouTrack API URL: /admin/projects
Delete YouTrack API URL: /admin/projects
Field Selection Method: NotRequired
Base Path: issues[*]
Select YouTrack API Operation: get /admin/projects
Table Function Columns
The columns of the table function Issues are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
$type_1 |
string |
|
☐ |
|
$type |
string |
|
☐ |
|
archived |
boolean |
Archived |
☐ |
|
commentsCount |
int32 |
Comments Count |
☐ |
|
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 |
☐ |
|
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 |
|
☐ |
|
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 |
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 |
|
☐ |
|
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 |
|
☐ |
|
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 |
☐ |
|
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 |
☐ |
|
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 |
|
☐ |
|
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 |
☐ |
|
23-06-2022 19:43 Version 22.0.248-PROD+3461