# Issues - Catalog: `YouTrack` - Schema: `Admin` - 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` 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. ## Columns of Table Function 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 | ☐ | |