SSIS Components for Linear

Build 26.0.9776

Release

All releases in the workspace, with optional filtering and sorting.

Table-Specific Information

SELECT

The component uses the Linear API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the component.

ColumnSupported Operators
id=, !=, IN, NOT IN
createdAt=, !=, IN, NOT IN, <, <=, >, >=
updatedAt=, !=, IN, NOT IN, <, <=, >, >=
name=, !=, IN, NOT IN, LIKE, CONTAINS
version=, !=, IN, NOT IN, LIKE, CONTAINS
pipelineId=, !=, IN, NOT IN
stageId=, !=, IN, NOT IN
completedAt=, !=, IN, NOT IN, IS, IS NOT, <, <=, >, >=

For example, the following queries are processed server-side:

SELECT * FROM Release LIMIT 1
SELECT * FROM Release WHERE createdAt = '2026-01-01T00:00:00Z' LIMIT 1

INSERT

To insert a Release record:
INSERT INTO Release (name, pipelineId, stageId, createdAt) VALUES ('v1.2.0', '921cb6bf-d5b6-44bb-9c6b-217b97dd27a2', 'e9e975c3-bc37-4fdc-a737-269866061c3e', '2026-01-01T00:00:00Z')

UPDATE

To update a Release record:
UPDATE Release SET description = 'Bug fixes and performance improvements.' WHERE id = '921cb6bf-d5b6-44bb-9c6b-217b97dd27a2'

DELETE

To delete a Release record:
DELETE FROM Release WHERE id = '921cb6bf-d5b6-44bb-9c6b-217b97dd27a2'

Columns

Name Type ReadOnly Description
id [KEY] String False

The unique identifier of the entity.

createdAt Datetime False

The time at which the entity was created.

updatedAt Datetime True

The last time at which the entity was meaningfully updated. This is the same as the creation time if the entity hasn't been updated after creation.

archivedAt Datetime True

The time at which the entity was archived. Null if the entity has not been archived.

name String False

The name of the release.

description String False

The description of the release in plain text or markdown. Null if no description has been set.

version String False

The version identifier for this release (e.g., 'v1.2.3' or a short commit hash). Must be unique within the pipeline. Null if no version has been assigned.

commitSha String False

The Git commit SHA associated with this release. Used for SHA-based idempotency when completing releases and for linking releases to specific points in the repository history. Null if the release was created without a commit reference.

pipelineId String False

The release pipeline that this release belongs to. A release always belongs to exactly one pipeline.

stageId String False

The current stage of the release within its pipeline (e.g., Planned, In Progress, Completed, Canceled). Changing the stage triggers lifecycle timestamp updates and may move non-closed issues to a new release when completing a scheduled pipeline release.

releaseNoteId String True

[Internal] The primary release note covering this release. Null if no release note covers it.

creatorId String True

The user who created the release. Null if the release was created by a non-user context such as an access key or automation.

slugId String True

The release's unique URL slug, used to construct human-readable URLs for the release.

startDate Date False

The estimated start date of the release. This is a date-only value without a time component. Automatically set to today when the release moves to a started stage if not already set. Null if no start date has been specified.

targetDate Date False

The estimated completion date of the release. This is a date-only value without a time component. Null if no target date has been specified.

startedAt Datetime False

The time at which the release first entered a started stage. Null if the release has not yet been started.

completedAt Datetime False

The time at which the release was completed. Set automatically when the release moves to a completed stage. Reset to null if the release moves back to a non-completed stage.

canceledAt Datetime True

The time at which the release was canceled. Set automatically when the release moves to a canceled stage. Reset to null if the release moves back to a non-canceled stage.

autoArchivedAt Datetime True

The time at which the release was automatically archived by the auto pruning process.

trashed Bool False

A flag that indicates whether the release is in the trash bin. Trashed releases are archived and will be permanently deleted after a retention period. Null when the release is not trashed.

progressHistory String True

The historical progress snapshots for the release, tracking how issue completion has evolved over time.

currentProgress String True

The current progress summary for the release, including counts of issues by workflow state type (e.g., completed, in progress, unstarted).

url String True

The URL to the release page in the Linear app.

issueCount Int True

Number of issues associated with the release.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9776