Customer
All customers in the workspace, with optional filtering and sorting.
Table-Specific Information
SELECT
The add-in 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 add-in.| Column | Supported Operators |
| id | =, !=, IN, NOT IN |
| createdAt | =, !=, IN, NOT IN, <, <=, >, >= |
| updatedAt | =, !=, IN, NOT IN, <, <=, >, >= |
| name | =, !=, IN, NOT IN, LIKE, CONTAINS |
| slackChannelId | =, !=, IN, NOT IN, LIKE, CONTAINS |
| ownerId | =, !=, IN, NOT IN, IS, IS NOT |
| statusId | =, !=, IN, NOT IN |
| revenue | =, !=, IN, NOT IN, <, <=, >, >= |
| size | =, !=, IN, NOT IN, <, <=, >, >= |
| tierId | =, !=, IN, NOT IN |
For example, the following queries are processed server-side:
SELECT * FROM Customer LIMIT 1
SELECT * FROM Customer WHERE revenue = 1 LIMIT 1
INSERT
To insert a Customer record:INSERT INTO Customer (name, logoUrl, slackChannelId) VALUES ('sample', 'sample', 'slackId')
UPDATE
To update a Customer record:UPDATE Customer SET name = 'sample' WHERE id = 'cae81b62-1a35-4aca-8994-79133f1d08a2'
DELETE
To delete a Customer record:DELETE FROM Customer WHERE id = 'cae81b62-1a35-4aca-8994-79133f1d08a2'
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. |
| name | String | False |
The display name of the customer organization. |
| logoUrl | String | False |
URL of the customer's logo image. Null if no logo has been uploaded. |
| domains | String | False |
The email domains associated with this customer (e.g., 'acme.com'). Used to automatically match incoming requests to this customer. Public email domains (e.g., gmail.com) are not allowed. Domains must be unique across all customers in the workspace. Returned as a JSON array of String values; accepts a JSON array or a comma-separated list when written. |
| externalIds | String | False |
Identifiers for this customer in external systems (e.g., CRM IDs from Intercom, Salesforce, or HubSpot). Used for matching customers during integration syncs and upsert operations. External IDs must be unique across customers in the workspace. Returned as a JSON array of String values; accepts a JSON array or a comma-separated list when written. |
| slackChannelId | String | False |
The ID of the Slack channel linked to this customer for communication. Null if no Slack channel has been associated. Must be unique across all customers in the workspace. |
| ownerId | String | False |
The workspace member assigned as the owner of this customer. Null if no owner has been assigned. App users cannot be set as customer owners. |
| statusId | String | False |
The current lifecycle status of the customer. Defaults to the first status by position when a customer is created without an explicit status. |
| revenue | Int | False |
The annual revenue generated by this customer. Null if revenue data has not been provided. May be synced from an external data source such as a CRM integration. |
| size | Double | False |
The number of employees or seats at the customer organization. Null if size data has not been provided. May be synced from an external data source such as a CRM integration. |
| tierId | String | False |
The tier or segment assigned to this customer for prioritization (e.g., Enterprise, Pro, Free). Null if no tier has been assigned. |
| approximateNeedCount | Double | True |
The approximate number of distinct requests associated with this customer, deduplicated per issue or project. This is a denormalized counter and may not reflect the exact count at all times. |
| slugId | String | True |
A unique, human-readable URL slug for the customer. Automatically generated and used in customer page URLs. |
| mainSourceId | String | False |
The primary external source ID when a customer has data from multiple external systems. Must be one of the values in the externalIds array. Null if the customer has zero or one external source. |
| integrationId | String | True |
The integration that manages this customer's data (e.g., Intercom, Salesforce). Null if the customer is not managed by any data source integration. |
| url | String | True |
The URL of the customer's page in the Linear application. |