# WorkItemById - Catalog: `YouTrack` - Schema: `Users` - Select YouTrack API URL: `/workItems/{id}` - Insert YouTrack API URL: `/workItems/{id}` - Update YouTrack API URL: `/workItems/{id}` - Delete YouTrack API URL: `/workItems/{id}` - Field Selection Method: NotRequired - Select YouTrack API Operation: `get /workItems/{id}` 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. ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `id` | `string` | ☑ | | | ## Columns of Table Function The columns of the table function `WorkItemById` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `$type` | `string` | | ☐ | | | `author_$type` | `string` | | ☐ | | | `author_avatarUrl` | `string` | | ☐ | | | `author_banned` | `boolean` | | ☐ | | | `author_email` | `string` | | ☐ | | | `author_fullName` | `string` | | ☐ | | | `author_guest` | `boolean` | | ☐ | | | `author_id` | `string` | | ☐ | | | `author_jabberAccountName` | `string` | | ☐ | | | `author_login` | `string` | | ☐ | | | `author_online` | `boolean` | | ☐ | | | `author_profiles_$type` | `string` | | ☐ | | | `author_profiles_id` | `string` | | ☐ | | | `author_ringId` | `string` | | ☐ | | | `created` | `int64` | Created | ☐ | | | `creator_$type` | `string` | | ☐ | | | `creator_avatarUrl` | `string` | | ☐ | | | `creator_banned` | `boolean` | | ☐ | | | `creator_email` | `string` | | ☐ | | | `creator_fullName` | `string` | | ☐ | | | `creator_guest` | `boolean` | | ☐ | | | `creator_id` | `string` | | ☐ | | | `creator_jabberAccountName` | `string` | | ☐ | | | `creator_login` | `string` | | ☐ | | | `creator_online` | `boolean` | | ☐ | | | `creator_profiles_$type` | `string` | | ☐ | | | `creator_profiles_id` | `string` | | ☐ | | | `creator_ringId` | `string` | | ☐ | | | `date` | `int64` | Date | ☐ | | | `duration_$type` | `string` | | ☐ | | | `duration_id` | `string` | | ☐ | | | `duration_minutes` | `int32` | | ☐ | | | `duration_presentation` | `string` | | ☐ | | | `id` | `string` | ID | ☐ | | | `issue_$type` | `string` | | ☐ | | | `issue_commentsCount` | `int32` | | ☐ | | | `issue_created` | `int64` | | ☐ | | | `issue_description` | `string` | | ☐ | | | `issue_draftOwner_$type` | `string` | | ☐ | | | `issue_draftOwner_avatarUrl` | `string` | | ☐ | | | `issue_draftOwner_banned` | `boolean` | | ☐ | | | `issue_draftOwner_email` | `string` | | ☐ | | | `issue_draftOwner_fullName` | `string` | | ☐ | | | `issue_draftOwner_guest` | `boolean` | | ☐ | | | `issue_draftOwner_id` | `string` | | ☐ | | | `issue_draftOwner_jabberAccountName` | `string` | | ☐ | | | `issue_draftOwner_login` | `string` | | ☐ | | | `issue_draftOwner_online` | `boolean` | | ☐ | | | `issue_draftOwner_ringId` | `string` | | ☐ | | | `issue_externalIssue_$type` | `string` | | ☐ | | | `issue_externalIssue_id` | `string` | | ☐ | | | `issue_externalIssue_key` | `string` | | ☐ | | | `issue_externalIssue_name` | `string` | | ☐ | | | `issue_externalIssue_url` | `string` | | ☐ | | | `issue_id` | `string` | | ☐ | | | `issue_idReadable` | `string` | | ☐ | | | `issue_isDraft` | `boolean` | | ☐ | | | `issue_numberInProject` | `int64` | | ☐ | | | `issue_parent_$type` | `string` | | ☐ | | | `issue_parent_direction` | `string` | | ☐ | | | `issue_parent_id` | `string` | | ☐ | | | `issue_project_archived` | `boolean` | | ☐ | | | `issue_project_description` | `string` | | ☐ | | | `issue_project_fromEmail` | `string` | | ☐ | | | `issue_project_iconUrl` | `string` | | ☐ | | | `issue_project_replyToEmail` | `string` | | ☐ | | | `issue_project_shortName` | `string` | | ☐ | | | `issue_project_startingNumber` | `int64` | | ☐ | | | `issue_project_template` | `boolean` | | ☐ | | | `issue_reporter_$type` | `string` | | ☐ | | | `issue_reporter_avatarUrl` | `string` | | ☐ | | | `issue_reporter_banned` | `boolean` | | ☐ | | | `issue_reporter_email` | `string` | | ☐ | | | `issue_reporter_fullName` | `string` | | ☐ | | | `issue_reporter_guest` | `boolean` | | ☐ | | | `issue_reporter_id` | `string` | | ☐ | | | `issue_reporter_jabberAccountName` | `string` | | ☐ | | | `issue_reporter_login` | `string` | | ☐ | | | `issue_reporter_online` | `boolean` | | ☐ | | | `issue_reporter_ringId` | `string` | | ☐ | | | `issue_resolved` | `int64` | | ☐ | | | `issue_subtasks_$type` | `string` | | ☐ | | | `issue_subtasks_direction` | `string` | | ☐ | | | `issue_subtasks_id` | `string` | | ☐ | | | `issue_summary` | `string` | | ☐ | | | `issue_updated` | `int64` | | ☐ | | | `issue_updater_$type` | `string` | | ☐ | | | `issue_updater_avatarUrl` | `string` | | ☐ | | | `issue_updater_banned` | `boolean` | | ☐ | | | `issue_updater_email` | `string` | | ☐ | | | `issue_updater_fullName` | `string` | | ☐ | | | `issue_updater_guest` | `boolean` | | ☐ | | | `issue_updater_id` | `string` | | ☐ | | | `issue_updater_jabberAccountName` | `string` | | ☐ | | | `issue_updater_login` | `string` | | ☐ | | | `issue_updater_online` | `boolean` | | ☐ | | | `issue_updater_ringId` | `string` | | ☐ | | | `issue_usesMarkdown` | `boolean` | | ☐ | | | `issue_visibility_$type` | `string` | | ☐ | | | `issue_visibility_id` | `string` | | ☐ | | | `issue_voters_$type` | `string` | | ☐ | | | `issue_voters_hasVote` | `boolean` | | ☐ | | | `issue_voters_id` | `string` | | ☐ | | | `issue_votes` | `int32` | | ☐ | | | `issue_watchers_$type` | `string` | | ☐ | | | `issue_watchers_hasStar` | `boolean` | | ☐ | | | `issue_watchers_id` | `string` | | ☐ | | | `issue_wikifiedDescription` | `string` | | ☐ | | | `text` | `string` | Text | ☐ | | | `textPreview` | `string` | Text Preview | ☐ | | | `type_$type` | `string` | | ☐ | | | `type_autoAttached` | `boolean` | | ☐ | | | `type_id` | `string` | | ☐ | | | `type_name` | `string` | | ☐ | | | `updated` | `int64` | Updated | ☐ | | | `usesMarkdown` | `boolean` | Uses Mark Down | ☐ | |