IntegrationTemplate
All integration template connections for the workspace, linking templates to integrations.
Table-Specific Information
SELECT
Retrieve Linear IntegrationTemplate records:SELECT * FROM IntegrationTemplate LIMIT 1
INSERT
To insert an IntegrationTemplate record:INSERT INTO IntegrationTemplate (integrationId) VALUES ('921cb6bf-d5b6-44bb-9c6b-217b97dd27a2')
DELETE
To delete an IntegrationTemplate record:DELETE FROM IntegrationTemplate WHERE id = 'b6d3252e-3bf4-4fb9-9cd0-cc57c63060a7'
Columns
| Name | Type | ReadOnly | Description |
| id [KEY] | String | False |
The unique identifier of the entity. |
| createdAt | Datetime | True |
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. |
| integrationId | String | False |
The integration that the template is associated with. |
| foreignEntityId | String | False |
The identifier of the foreign entity in the external service that this template is scoped to. For example, a Slack channel ID indicating which channel should use this template for creating issues. When null, the template applies to the integration as a whole rather than a specific external resource. |
| templateId | String | False |
The identifier of the template. Used only when creating or updating a record; reads return NULL. |