Tables

The driver models the data in Linear as a list of tables in a relational database that can be queried using standard SQL statements.

CData ODBC Driver for Linear Tables


Name	Description
AgentActivity	All agent activities.
AgentSession	All agent sessions.
AgentSkill	All agent skills.
Attachment	All issue attachments. To get attachments for a given URL, use `attachmentsForURL` query.
Comment	All comments the user has access to in the workspace.
Customer	All customers in the workspace, with optional filtering and sorting.
CustomerNeed	All customer needs in the workspace, with optional filtering.
CustomerStatus	All customer statuses defined in the workspace.
CustomerTier	All customer tiers defined in the workspace.
CustomView	All custom views accessible to the user, including personal views and shared workspace views. Excludes views scoped to a specific project or initiative.
Cycle	All cycles accessible to the user.
Document	All documents the user has access to in the workspace.
DocumentSubscribers	Associates Document with User.
Emoji	All custom emojis in the workspace.
Favorite	The authenticated user's favorites. Returns all bookmarked items that appear in the user's sidebar.
Initiative	Returns all initiatives in the workspace, with optional filtering and sorting.
InitiativeLabels	Associates Initiative with InitiativeLabel.
InitiativeRelation	Returns all initiative parent-child relations in the workspace.
InitiativeToProject	Returns all initiative-to-project associations in the workspace.
InitiativeUpdate	Returns all initiative status updates in the workspace, with optional filtering.
Integration	All integrations for the workspace.
IntegrationTemplate	All integration template connections for the workspace, linking templates to integrations.
Issue	All issues. Returns a paginated list of issues visible to the authenticated user. Can be filtered by various criteria including team, assignee, state, labels, project, and cycle.
IssueLabel	All issue labels. Returns a paginated list of labels visible to the authenticated user, including both workspace-level and team-scoped labels.
IssueLabels	Associates Issue with IssueLabel.
IssueRelation	All issue relations. Returns a paginated list of all issue relations (blocks, blocked by, relates to, duplicates) visible to the authenticated user.
IssueSubscribers	Associates Issue with User.
IssueToRelease	All issue-to-release associations. Returns a paginated list of all issue-to-release links visible to the authenticated user.
Notification	The authenticated user's notifications.
NotificationSubscription	The authenticated user's notification subscriptions. These subscriptions control which notifications the user receives for specific entities such as teams, projects, cycles, labels, custom views, initiatives, customers, and users.
OrganizationInvite	All pending and accepted invites for the workspace.
Project	Returns all projects in the workspace, with optional filtering and sorting.
ProjectLabel	Returns all project labels in the workspace, with optional filtering.
ProjectLabels	Associates Project with ProjectLabel.
ProjectMembers	Associates Project with User.
ProjectMilestone	Returns all project milestones in the workspace, with optional filtering.
ProjectRelation	Returns all project dependency relations in the workspace.
ProjectStatus	Returns all project statuses in the workspace.
ProjectTeams	Associates Project with Team.
ProjectUpdate	Returns all project status updates in the workspace, with optional filtering.
Release	All releases in the workspace, with optional filtering and sorting.
ReleaseNote	Release notes in the workspace.
ReleasePipeline	All release pipelines in the workspace, with optional filtering and sorting.
ReleasePipelineTeams	Associates ReleasePipeline with Team.
ReleaseStage	All release stages in the workspace, with optional filtering.
Team	All teams whose issues the user can access. This includes public teams and private teams the user is a member of. This may differ from `administrableTeams`, which returns teams whose settings the user can change but whose issues they don't necessarily have access to.
TeamMembership	All team memberships in the workspace.
TimeSchedule	All time schedules.
TriageResponsibility	All triage responsibilities.
User	All users in the workspace. Supports filtering, sorting, and pagination.
Webhook	All webhooks for the current workspace.
WorkflowState	All issue workflow states (issue statuses). Returns a paginated list of workflow states visible to the authenticated user, across all teams they have access to.